Search Housing Authority:
66 Housing Authorities Found in/near Reseda, CA
1
Housing Authority
Save
8300 W. Santa Monica Blvd., West Hollywood, CA 90069
The Housing Unit facilitates the development of new housing, the rehabilitation of existing buildings, and the development of mixed-use projects with...more info
Call Now: (323) 848-6323
Section 8 Voucher
CALL
SUBSIDIZED UNITS
2
Housing Authority
Save
1901 Main St., Santa Monica, CA 90405
The Housing Division is dedicated to preserving existing affordable housing in Santa Monica and creating new housing opportunities for residents with...more info
Call Now: (310) 458-8740
Section 8 Voucher
CALL
SUBSIDIZED UNITS
3
Housing Authority
Save
9770 Culver Blvd., Culver City, CA 90232
****** Please note that their programs are now closed and they are not accepting any applications nor are they adding to their waiting list....more info
Call Now: (310) 253-5780
Section 8 Voucher
CALL
SUBSIDIZED UNITS
4
Housing Authority
Save
141 N. Glendale Ave., Ste. 202, Glendale, CA 91206
The City of Glendale prides itself on the variety of housing options it offers to its residents. The Community Development Department, under...more info
Call Now: (818) 548-3936
Section 8 Voucher
CALL
SUBSIDIZED UNITS
5
Housing Authority
Save
One Manchester Boulevard Suite 750, Inglewood, CA 90301
The Housing Authority strives to significantly increase its current level of affordable housing by increasing the supply of vouchers for very...more info
Call Now: (310) 412-5221
Section 8 Voucher
CALL
SUBSIDIZED UNITS
6
Housing Authority
Save
4445 W. 126th Street, Hawthorne, CA 90250
The Department of Housing is responsible for administering the Section 8 Housing Choice Voucher Program under the Federal Program of U, S. Department...more info
Call Now: (310) 349-1600
Section 8 Voucher
CALL
SUBSIDIZED UNITS
7
Housing Authority
Save
1400 W. Hillcrest Dr., Newbury Park, CA 91320
The Area Housing Authority of the County of Ventura is an independent, non-profit agency serving the unincorporated areas of Ventura County and the...more info
Call Now: (805) 480-9991


Section 8 Wait List
OPEN
8
Housing Authority
Save
649 N. Fair Oaks Ave, Ste. 202, Pasadena, CA 91103
The City of Pasadena Housing Department's waiting list will be open on October 15, 2014. Please visit the website and register to get e-notify for...more info
Call Now: (626) 744-8300
Section 8 Voucher
CALL
SUBSIDIZED UNITS
9
Housing Authority
Save
1922 Artesia Blvd., Redondo Beach, CA 90278
The Housing Authority administers two programs for the City; the Section 8 Rent Assistance Program and a Landlord/Tenant Fair Housing Program. Both...more info
Call Now: (310) 318-0635
Section 8 Voucher
CALL
SUBSIDIZED UNITS
10
Housing Authority
Save
700 W. Main St., Alhambra, CA 91801
Formerly known as the Community Development Commission/Housing Authority of the County of Los Angeles, the agency was rebranded as the Los Angeles...more info
Call Now: (626) 262-4510
Section 8 Voucher
Low-Rent

2,962
SUBSIDIZED UNITS
11
Housing Authority
Save
8650 California Avenue, South Gate, CA 90280
The Housing Authority serves as an advisory body to the City Council on the various housing programs offered by the City of South Gate. These...more info
Call Now: (323) 563-9500
Section 8 Voucher
CALL
SUBSIDIZED UNITS
1 - 11 of 66 Results
credit_banner

Rental Deals Nearby

Eagle Tail Village
306 S. 7th St.
Buckeye , AZ 85326
if you qualify, you may pay: 1 BR, 1 BA $820
Tuzigoot Village
1600 E. Skyline Dr.
Cottonwood , AZ 86326
if you qualify, you may pay: Accepting Applications
Kachina Place
6238 N 63rd Ave
Glendale , AZ 85301
if you qualify, you may pay: $638
Paradise Valley Retirement Center
11640 N. 27th Street
Phoenix , AZ 85028
if you qualify, you may pay: Call
Memorial Towers
1405 S. 7th Ave.
Phoenix , AZ 85007
if you qualify, you may pay: $730

Application Log
Timestamp Level Category Message
23:28:07.146758 trace system.CModule
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.147212 trace system.CModule
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.147353 trace system.CModule
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.150350 trace system.CModule
Loading "db" application component
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.150497 trace system.db.CDbConnection
Opening DB connection
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.152141 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `settings`
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.154634 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `settings`
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.155170 trace system.db.CDbCommand
Querying SQL: select value from settings where setting_key = "facebook_url"
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.155646 trace system.db.CDbCommand
Querying SQL: select value from settings where setting_key = "twitter_url"
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(56)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.156086 trace system.db.CDbCommand
Querying SQL: select value from settings where setting_key = "admin_email"
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(58)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.156511 trace system.db.CDbCommand
Querying SQL: select image from banner where status = "Active"
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(60)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.157639 trace system.db.CDbCommand
Querying SQL: select p.property_state,p.property_city
,(((acos(sin(("34.052235" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.052235" *pi()/180)) * cos((`lat`*pi()/180))
* cos((("-118.243683"- `lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as
distance from property p group by p.property_city HAVING distance <= 50
order by distance ASC
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(127)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.251671 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `state`
in /home/cavepear/rentalhousingdeals.com/protected/models/State.php (20)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2510)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.253186 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `state`
in /home/cavepear/rentalhousingdeals.com/protected/models/State.php (20)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2510)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.253699 trace system.db.CDbCommand
Querying SQL: select name from state where abbr = "CA" or name = "CA"
in /home/cavepear/rentalhousingdeals.com/protected/models/State.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2510)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.254547 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `housingauthority`
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2521)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.258306 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `housingauthority`
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2521)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.259175 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `seo_template`
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(24)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2551)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.260915 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `seo_template`
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(24)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2551)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.261421 trace system.db.CDbCommand
Querying SQL: select title,keyword,description from seo_template where 
home = 'Housing authority' and state = 'CA' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = 'Reseda'  and
individual_type = ''
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2551)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.261892 trace system.db.CDbCommand
Querying SQL: select title,keyword,description from seo_template where 
home = 'Housing authority' and state = '' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = 'All'  and
individual_type = ''
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2558)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.262490 trace system.db.CDbCommand
Querying SQL: select seo_val from seo_settings where seo_key =
"searchha_title_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2565)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.262876 trace system.db.CDbCommand
Querying SQL: select seo_val from seo_settings where seo_key =
"searchha_keyword_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2566)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.263241 trace system.db.CDbCommand
Querying SQL: select seo_val from seo_settings where seo_key =
"searchha_description_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2567)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.263586 trace system.CModule
Loading "myUtility" application component
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2579)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.263763 trace system.db.CDbCommand
Querying SQL: select property_city, lat, lng, property_state, property_zip,
count(property.id_property ) as prop_count from property where concat_ws(',
' , replace(replace(replace(`property_city`,'"',''),'/ ',' '),'-','
'),property.property_state ) like '%Reseda CA%' OR concat_ws(' ' ,
replace(replace(replace(`property_city`,'"',''),'/ ',' '),'-','
'),property.property_state ) like '%Reseda CA%'group by concat_ws(',' ,
property.property_city,property.property_state ) order by prop_count desc
limit 1
in /home/cavepear/rentalhousingdeals.com/protected/components/MyUtility.php
(31)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2579)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.325768 trace system.CModule
Loading "clientScript" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(2)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.326381 trace system.CModule
Loading "widgetFactory" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(74)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:28:07.326738 trace system.CModule
Loading "assetManager" application component
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/typeahead/TbTypeAhead.php
(179)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/typeahead/TbTypeAhead.php
(155)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(74)
23:28:07.327961 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `property`
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php (45)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(35)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
23:28:07.330348 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `property`
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php (45)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(35)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
23:28:07.331048 trace system.db.CDbCommand
Querying SQL: select count(*) from state where name = "Reseda CA" or abbr =
"Reseda CA"
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php
(550)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(35)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
23:28:07.331815 trace system.db.CDbCommand
Querying SQL: select id,(((acos(sin(("34.1913233000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.1913233000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.5335026000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority as h HAVING distance <= 300 order by distance ASC
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(52)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.346801 trace system.db.CDbCommand
Querying SQL: select id,(((acos(sin(("34.1913233000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.1913233000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.5335026000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority as h HAVING distance <= 300 order by distance ASC LIMIT 11
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(105)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.355242 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=443
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.355700 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=443 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.356237 trace system.CModule
Loading "user" application component
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/views/_view.php
(44)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(145)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
23:28:07.356401 trace system.CModule
Loading "session" application component
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/views/_view.php
(44)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(145)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
23:28:07.357403 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=424
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.357862 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=424 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.358937 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=347
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.359391 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=347 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.360424 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=356
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.360934 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=356 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.361974 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=361
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.362483 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=361 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.363509 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=359
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.363969 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=359 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.365009 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=378
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.365470 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=378 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.366938 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=383
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.367374 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=383 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.368520 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=395
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.369024 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=395 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.370066 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=373
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.370544 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=373 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.371649 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=429
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.372175 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=429 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.374675 trace system.db.CDbCommand
Querying SQL: select count(*) from state where name = "Reseda CA" or abbr =
"Reseda CA"
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php
(550)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchhagmap/searchhagmap.php
(27)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(182)
23:28:07.375216 trace system.db.CDbCommand
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("34.1913233000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.1913233000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.5335026000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority HAVING distance <= 300 order by distance ASC
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchhagmap/searchhagmap.php
(43)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(182)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.386704 trace system.db.CDbCommand
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("34.1913233000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.1913233000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.5335026000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority HAVING distance <= 300 order by distance ASC limit 0,10
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchhagmap/searchhagmap.php
(62)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(182)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.395771 trace system.db.CDbCommand
Querying SQL: select p.id_property,p.property_title, p.property_address
,p.property_city,p.property_state,p.property_type ,
p.property_zip,pd.header_description,pd.header_value,pp.photo,
        (((acos(sin(('34.1913233000000000' *pi()/180)) *
sin((`lat`*pi()/180))+cos(('34.1913233000000000' *pi()/180)) *
cos((`lat`*pi()/180)) * cos((('-118.5335026000000000'-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from property p 
        left join property_photo pp on p.id_property = pp.id_property and
pp.status = 'Active'
        left join property_deals pd on pd.id_property = p.id_property
        where p.status = 'Approved' 
        group by p.id_property HAVING distance <= 500 order by
p.property_type DESC limit 5
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(28)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(270)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:28:07.935116 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `property_deals`
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(27)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:28:07.936728 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `property_deals`
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(27)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:28:07.937262 trace system.db.CDbCommand
Querying SQL: select header_description,header_value from property_deals
where id_property = 810
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(105)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:28:07.937730 trace system.db.CDbCommand
Querying SQL: select header_description,header_value from property_deals
where id_property = 825
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(105)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:28:07.938127 trace system.db.CDbCommand
Querying SQL: select header_description,header_value from property_deals
where id_property = 840
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(105)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:28:07.938503 trace system.db.CDbCommand
Querying SQL: select header_description,header_value from property_deals
where id_property = 902
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(105)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:28:07.938854 trace system.db.CDbCommand
Querying SQL: select header_description,header_value from property_deals
where id_property = 904
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(105)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:28:07.939647 trace system.CModule
Loading "uri" application component
in /home/cavepear/rentalhousingdeals.com/protected/views/layouts/main2.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
in /home/cavepear/rentalhousingdeals.com/index.php (16)