Search Housing Authority:
60 Housing Authorities Found in/near La Puente, CA
12
Housing Authority
Save
21815 Pioneer Blvd., Hawaiian Gardens, CA 90716
The Housing Division administers a wide variety of housing and commercial rehabilitation programs that contribute to the quality of life, economic...more info
Call Now: (562) 420-2641 x 270
Section 8 Voucher
CALL
SUBSIDIZED UNITS
13
Housing Authority
Save
5050 Clark Ave., Lakewood, CA 90712
Section 8 programs in Lakewood are administered by the Housing Authority of Los Angeles County. The program assists eligible families afford safe,...more info
Call Now: (626) 262-4510
Section 8 Voucher
CALL
SUBSIDIZED UNITS
14
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
15
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
16
Housing Authority
Save
600 N. Alameda, Compton, CA 90220
The Compton Local Housing Authority (LHA) was established in 1969 pursuant to State legislation. On December 1, 1976, the LHA entered into an Annual...more info
Call Now: (310) 605-3080
Section 8 Voucher
CALL
SUBSIDIZED UNITS
17
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
18
Housing Authority
Save
521 E. 4th St., Long Beach, CA 90802
** AT THIS TIME, WE ARE NOT ACCEPTING PRE-APPLICATIONS ONLINE. PLEASE CONTACT THE AGENCY FOR MORE INFORMATION. ** The City of Long Beach Housing...more info
Call Now: (562) 570-6985
Section 8 Voucher
CALL
SUBSIDIZED UNITS
19
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
20
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
21
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
22
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
12 - 22 of 60 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:29:25.393532 trace system.CModule
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:29:25.393795 trace system.CModule
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:29:25.393887 trace system.CModule
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:29:25.396059 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:29:25.396159 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:29:25.397543 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:29:25.399786 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:29:25.400257 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:29:25.400688 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:29:25.401079 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:29:25.401470 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:29:25.402278 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:29:25.487828 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:29:25.489159 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:29:25.489542 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:29:25.490019 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:29:25.492290 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:29:25.492913 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:29:25.494311 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:29:25.494784 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`,'"',''),'/ ',' '),'-',' ') = 'La Puente' 
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:29:25.495179 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:29:25.495640 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:29:25.496018 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:29:25.496378 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:29:25.496732 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:29:25.496908 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 '%La Puente CA%' OR concat_ws(' ' ,
replace(replace(replace(`property_city`,'"',''),'/ ',' '),'-','
'),property.property_state ) like '%La Puente 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:29:25.551291 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:29:25.551759 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:29:25.552006 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:29:25.552869 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:29:25.554991 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:29:25.555526 trace system.db.CDbCommand
Querying SQL: select count(*) from state where name = "La Puente CA" or
abbr = "La Puente 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:29:25.555911 trace system.db.CDbCommand
Querying SQL: select id,(((acos(sin(("34.0367419000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.0367419000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-117.9448460000000000"-
`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:29:25.563560 trace system.db.CDbCommand
Querying SQL: select id,(((acos(sin(("34.0367419000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.0367419000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-117.9448460000000000"-
`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 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:29:25.570907 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=358
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:29:25.571309 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=358 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:29:25.571791 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:29:25.571921 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:29:25.572786 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=422
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:29:25.573235 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=422 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:29:25.574178 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:29:25.574577 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:29:25.575499 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:29:25.575901 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:29:25.576826 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=345
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:29:25.577244 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=345 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:29:25.578136 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:29:25.578541 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:29:25.579459 trace system.db.CDbCommand
Querying SQL: Select * from housingauthority where id=364
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:29:25.579865 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=364 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:29:25.580799 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:29:25.581181 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:29:25.582093 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:29:25.582484 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:29:25.583385 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:29:25.583775 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:29:25.584677 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:29:25.585082 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:29:25.587199 trace system.db.CDbCommand
Querying SQL: select count(*) from state where name = "La Puente CA" or
abbr = "La Puente 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:29:25.587614 trace system.db.CDbCommand
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("34.0367419000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.0367419000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-117.9448460000000000"-
`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:29:25.598543 trace system.db.CDbCommand
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("34.0367419000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.0367419000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-117.9448460000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority HAVING distance <= 300 order by distance ASC limit 1,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:29:25.607443 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.0367419000000000' *pi()/180)) *
sin((`lat`*pi()/180))+cos(('34.0367419000000000' *pi()/180)) *
cos((`lat`*pi()/180)) * cos((('-117.9448460000000000'-
`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:29:26.135873 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:29:26.137464 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:29:26.137936 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:29:26.138360 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:29:26.138735 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:29:26.139096 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:29:26.139435 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:29:26.140187 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)