Search Housing Authority:
63 Housing Authorities Found in/near Gardena, CA
23
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
24
Housing Authority
Save
11277 Garden Grove Blvd., Ste 101C, Garden Grove, CA 92840
The Garden Grove Housing Authority operates under federal grants received from the Department of Housing and Urban Development to provide rental...more info
Call Now: (714) 741-5150
Section 8 Voucher
CALL
SUBSIDIZED UNITS
25
Housing Authority
Save
201 S. Anaheim Blvd., Ste 201, Anaheim, CA 92805
Anaheim Housing Authority (AHA) provides information about the Section 8 Housing Choice Voucher (HCV) Program and how to apply for the program. The...more info
Call Now: (714) 765-4320
Section 8 Voucher
CALL
SUBSIDIZED UNITS
26
Housing Authority
Save
14403 Pacific Ave., Baldwin Park, CA 91706
** AT THIS TIME, WE ARE NOT ACCEPTING PRE-APPLICATIONS ONLINE. PLEASE CONTACT THE AGENCY FOR MORE INFORMATION. ** Baldwin Park Housing Authority...more info
Call Now: (626) 813-5285
Section 8 Voucher
Low-Rent

12
SUBSIDIZED UNITS
27
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
28
Housing Authority
Save
1200 N. Campus Ave., Upland, CA 91786
The Housing Authority of the City of Upland (UHA) was founded on August 8, 1940, by a resolution of the Upland City Council. The Council Resolution...more info
Call Now: (909) 982-2649
Section 8 Voucher
Low-Rent

98
SUBSIDIZED UNITS
29
Housing Authority
Save
5555 Arlington Ave., Riverside, CA 92504
** AT THIS TIME, WE ARE NOT ACCEPTING PRE-APPLICATIONS ONLINE. PLEASE CONTACT THE AGENCY FOR MORE INFORMATION. ** The Housing Authority of the...more info
Call Now: (951) 351-0700
Section 8 Voucher
Low-Rent

469
SUBSIDIZED UNITS
30
Housing Authority
Save
250 N. Ventura Rd., Port Hueneme, CA 93041
The Housing Authority of the City of Port Hueneme provides quality affordable housing to eligible households in a professional, fiscally prudent...more info
Call Now: (805) 986-6522
Section 8 Voucher
Low-Rent

90
SUBSIDIZED UNITS
31
Housing Authority
Save
435 South D Street, Oxnard, CA 93030
Established in Oxnard in 1945, the Oxnard Housing Authority (OHA) owns and operates 780 units of federally subsidized low-income public housing. ...more info
Call Now: (805) 385-8041
Section 8 Voucher
Low-Rent

780
SUBSIDIZED UNITS
32
Housing Authority
Save
15500 W. Telegraph Rd., Ste. B-11, Santa Paula, CA 93061
The City of Santa Paula provides several housing assistance programs, either directly or through various local or state programs. The Santa Paula...more info
Call Now: (805) 525-9333
Section 8 Voucher
CALL
SUBSIDIZED UNITS
33
Housing Authority
Save
715 E. Brier Dr., San Bernardino, CA 92408
Established in 1941, the Housing Authority of the County of San Bernardino (HACSB) is the largest provider of affordable housing, serving nearly...more info
Call Now: (909) 890-9533
Section 8 Voucher
Low-Rent

1,260
SUBSIDIZED UNITS
23 - 33 of 63 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:37:04.555535 trace system.CModule
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:37:04.555852 trace system.CModule
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:37:04.555960 trace system.CModule
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:37:04.558661 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:37:04.558785 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:37:04.560314 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:37:04.562777 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:37:04.563313 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:37:04.563802 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:37:04.564237 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:37:04.564652 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:37:04.565576 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:37:04.650103 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:37:04.651649 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:37:04.652189 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:37:04.652826 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:37:04.655253 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:37:04.655983 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:37:04.657422 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:37:04.657881 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`,'"',''),'/ ',' '),'-',' ') = 'Gardena'  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:37:04.658271 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:37:04.658724 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:37:04.659147 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:37:04.659533 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:37:04.659868 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:37:04.660031 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 '%Gardena CA%' OR concat_ws(' ' ,
replace(replace(replace(`property_city`,'"',''),'/ ',' '),'-','
'),property.property_state ) like '%Gardena 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:37:04.712783 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:37:04.713522 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:37:04.713918 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:37:04.714925 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:37:04.717205 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:37:04.717772 trace system.db.CDbCommand
Querying SQL: select count(*) from state where name = "Gardena CA" or abbr
= "Gardena 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:37:04.718206 trace system.db.CDbCommand
Querying SQL: select id,(((acos(sin(("33.8856720000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("33.8856720000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.3224550000000000"-
`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:37:04.726023 trace system.db.CDbCommand
Querying SQL: select id,(((acos(sin(("33.8856720000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("33.8856720000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.3224550000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority as h HAVING distance <= 300 order by distance ASC LIMIT 11
OFFSET 22
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:37:04.733700 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:37:04.734230 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:37:04.734839 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:37:04.734993 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:37:04.735992 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=355
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:37:04.736659 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=355 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:37:04.737817 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=333
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:37:04.738279 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=333 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:37:04.739339 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=336
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:37:04.740003 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=336 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:37:04.741187 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:37:04.741662 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:37:04.743205 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=436
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:37:04.743720 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=436 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:37:04.744848 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=398
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:37:04.745296 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=398 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:37:04.746421 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=390
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:37:04.747056 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=390 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:37:04.747730 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=382
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:37:04.748100 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=382 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:37:04.748766 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=425
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:37:04.749084 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=425 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:37:04.749700 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=405
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:37:04.750061 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=405 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:37:04.751377 trace system.db.CDbCommand
Querying SQL: select count(*) from state where name = "Gardena CA" or abbr
= "Gardena 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:37:04.751936 trace system.db.CDbCommand
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("33.8856720000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("33.8856720000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.3224550000000000"-
`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:37:04.761826 trace system.db.CDbCommand
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("33.8856720000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("33.8856720000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.3224550000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority HAVING distance <= 300 order by distance ASC limit 2,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:37:04.770785 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(('33.8856720000000000' *pi()/180)) *
sin((`lat`*pi()/180))+cos(('33.8856720000000000' *pi()/180)) *
cos((`lat`*pi()/180)) * cos((('-118.3224550000000000'-
`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:37:05.295876 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:37:05.297486 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:37:05.298029 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:37:05.298496 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:37:05.298892 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:37:05.299273 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:37:05.299629 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:37:05.300430 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)