1. Home
  2. CA
  3. Los Angeles
$0
$5000
363 Senior Housing in/near Los Angeles, CA
67
Save
Ellendale Arms
2711 ELLENDALE PL | LOS ANGELES, CA, 90007
Ellendale Arms apartments is an affordable housing community with 1 Bed(s) apartments units.
  • r_c
Call Now: 323 731-4312
Affordable Housing   $ CALL 1 BR   
68
Save
Budlong Apartments
2727 Budlong Avenue | Los Angeles, CA, 90007
Budlong Apartments apartments is an affordable housing community with 2 Bed(s) to 4 Bed(s) apartments units.
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (213) 741-0581
Affordable Housing Subsidized Rent   $ CALL 2 BR - 4 BR   
69
Save
Alegria Apartments
801 W. 23rd St. | Los Angeles, CA, 90007
Alegria Apartments apartments is an affordable housing community with 1 Bed(s) to 4 Bed(s) apartments units.
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (323) 251-5188
Affordable Housing Subsidized Rent   $ CALL 1 BR - 4 BR   
70
Save
Oxford Park
1920 S OXFORD ST | LOS ANGELES, CA, 90018
Oxford Park apartments is an affordable housing community with 1 Bed(s) apartments units.
  • r_c
Call Now: 310 204 2050
Affordable Housing   $ CALL 1 BR   
71
Save
La Estrella Apartments
1979 Estrella Avenue | Los Angeles, CA, 90007
La Estrella Apartments apartments is an affordable housing community with 2 Bed(s) to 3 Bed(s) apartments units.
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (213) 741-0581
Affordable Housing Subsidized Rent   $ CALL 2 BR - 3 BR   
72
Save
Amistad Apartments
1953 Estrella Avenue | Los Angeles, CA, 90007
Amistad Apartments apartments is an affordable housing community with 1 Bed(s) to 3 Bed(s) apartments units.
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (213) 741-0581
Affordable Housing Subsidized Rent   $ CALL 1 BR - 3 BR   
73
Save
Jessie L Terry Manor
3100 S Vermont AVE | LOS ANGELES, CA, 90007
Jessie L Terry Manor apartments is an affordable housing community with 1 Bed(s) to 2 Bed(s) apartments units.
  • r_c
Call Now: 323 734-1664
Affordable Housing   $ CALL 1 BR - 2 BR   
74
Save
Adams Senior Housing
1921 Adams Boulevard | LOS ANGELES, CA, 90018
Adams Senior Housing apartments is an affordable housing community with 1 Bed(s) apartments units.
  • r_c
Affordable Housing   $ CALL 1 BR   
75
Save
New Hampshire Arms
819 S NEW HAMPSHIRE AVE | LOS ANGELES, CA, 90005
New Hampshire Arms apartments is an affordable housing community with 1 Bed(s) apartments units.
  • r_c
Call Now: 310 204 2050
Affordable Housing   $ CALL 1 BR   
76
Save
Preservation V
833 S CARONDELET ST | LOS ANGELES, CA, 90057
Preservation V apartments is an affordable housing community with 1 Bed(s) apartments units.
  • r_c
Affordable Housing   $ CALL 1 BR   
77
Save
Burlington Arms
817 S BURLINGTON | LOS ANGELES, CA, 90057
Burlington Arms apartments is an affordable housing community with 1 Bed(s) apartments units.
  • r_c
Affordable Housing   $ CALL 1 BR   
67 - 77 of 363 Apts Results



credit_banner
gazelle

Housing Authority Nearby

West Hollywood Housing
West Hollywood Housing
8300 W. Santa Monica Blvd.
West Hollywood , CA 90069
Culver City Housing Authority
Culver City Housing Authority
9770 Culver Blvd.
Culver City , CA 90232
Inglewood Housing Authority
Inglewood Housing Authority
One Manchester Boulevard Suite 750
Inglewood , CA 90301
South Gate Housing Authority
South Gate Housing Authority
8650 California Avenue
South Gate , CA 90280
Glendale Housing Authority
Glendale Housing Authority
141 N. Glendale Ave., Ste. 202
Glendale , CA 91206
More Nearby Housing Authorities >>

DISCOVER
COMPANY
JOIN US ON
  • Twitter
  • Facebook
  • YouTube

  • Rental Housing Deals, Inc. is a BBB Accredited Real Estate Agent in San Gabriel, CA
    logo

The best place to begin your search for the perfect home, where you can find affordable rental housing deals, RentalHousingDeals.com is an all-in-one affordable rental housing site. We can help you save money by finding the best rental deals with detailed information on all types of affordable housing such as low income housing, affordable senior housing for rent, Section 8 housing for rent. Visit RentalHousingDeals.com to find the best rental deals and rental assistance on all affordable housing types such as houses, apartments, condos, lofts and townhouses. Easily customize your search with filters based by price, number of bedrooms, baths and more. Our simple-to-use interface allows you to search Public Housing Authorities and submit pre-applications to receive rental assistance, low rent programs, qualifying income limits, help with paid utilities, Section 8 vouchers, subsidized units, housing choice vouchers, and waiting list information. Our resource center provides information about all different types of rental assistance programs and a rental calculator to help you figure out how much to pay for rent. Our content-rich blog shows you ways to save money, with tips and advice for improving your home and making the most with your budget.

Copyright © 2024 RentalHousingDeals.com, All Rights Reserved  Equal Housing Opportunity    
Application Log
Timestamp Level Category Message
23:23:59.150841 trace system.CModule 
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.151139 trace system.CModule 
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.151240 trace system.CModule 
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.153821 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:23:59.153937 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:23:59.155193 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:23:59.156997 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:23:59.157361 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:23:59.157671 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:23:59.158026 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:23:59.158365 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:23:59.159131 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:23:59.245373 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
(36)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.246771 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
(36)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.247248 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
(36)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.247756 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
(39)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.249123 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
(39)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.249583 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Affordable housing' and state = 'CA' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = 'Los Angeles' 
and individual_type = ''
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(39)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.249958 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Senior Housing' and state = 'CA' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = 'Los Angeles' 
and individual_type = ''
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(40)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.250313 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Section 8 Housing' and state = 'CA' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = 'Los Angeles' 
and individual_type = ''
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(41)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.250664 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Affordable housing' and state = 'CA' 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
(48)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.251077 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"search_title_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.251425 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"search_keyword_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(55)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.251761 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"search_description_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(56)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.252095 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Senior Housing' and state = 'CA' 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
(65)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.252433 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"sin_search_title_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(71)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.252785 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"sin_search_keyword_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(72)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.253123 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"sin_search_description_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(73)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.253437 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Section 8 Housing' and state = 'CA' 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
(82)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.253765 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"s8_search_title_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(88)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.254087 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"s8_search_keyword_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(89)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.254403 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"s8_search_description_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(90)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.254868 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `property`
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(237)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.256879 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `property`
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(237)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.257379 trace system.CModule 
Loading "myUtility" application component
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(239)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.257534 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 '%Los Angeles CA%' OR concat_ws(' ' ,
replace(replace(replace(`property_city`,'"',''),'/ ',' '),'-','
'),property.property_state ) like '%Los Angeles 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
(239)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.312438 trace system.CModule 
Loading "clientScript" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(2)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.312606 trace system.CModule 
Loading "widgetFactory" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(59)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.312954 trace system.CModule 
Loading "assetManager" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(59)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:23:59.314264 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "Los Angeles CA" or
abbr = "Los Angeles CA"
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php
(550)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
23:23:59.314826 trace system.db.CDbCommand 
Querying SQL: select p.id_property as pid,(CASE p.property_type WHEN
"premium" THEN 1 WHEN  "classified" THEN 2 else 3 END) as ordval,
p.property_type as pt , (((acos(sin((34.0408 *pi()/180)) *
sin((`lat`*pi()/180))+cos((34.0408 *pi()/180)) * cos((`lat`*pi()/180)) *
cos(((-118.2906 - `lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance
from property p  left join property_detail pd  on p.id_property =
pd.id_property   where 1=1 and (status = "Approved") and
p.property_state="CA"  and pd.min_rent between 0 and  5000 and
pd.seniorprop =  "Yes" group by pid HAVING distance <= 60
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(97)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.349334 trace system.db.CDbCommand 
Querying SQL: select p.id_property as pid,(CASE p.property_type WHEN
"premium" THEN 1 WHEN  "classified" THEN 2 else 3 END) as ordval,
p.property_type as pt , (((acos(sin((34.0408 *pi()/180)) *
sin((`lat`*pi()/180))+cos((34.0408 *pi()/180)) * cos((`lat`*pi()/180)) *
cos(((-118.2906 - `lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance
from property p  left join property_detail pd  on p.id_property =
pd.id_property   where 1=1 and (status = "Approved") and
p.property_state="CA"  and pd.min_rent between 0 and  5000 and
pd.seniorprop =  "Yes" group by pid HAVING distance <= 60 order by ordval
ASC , distance ASC  LIMIT 11 OFFSET 66
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(150)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.389187 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "Los Angeles CA" or
abbr = "Los Angeles CA"
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php
(550)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(158)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
23:23:59.389863 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `property_detail`
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyDetail.php
(61)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(186)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
23:23:59.392558 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `property_detail`
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyDetail.php
(61)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(186)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
23:23:59.393362 trace system.db.CDbCommand 
Querying SQL: select
p.id_property,p.property_title,p.property_type,p.property_address,
                       
p.property_city,pdd.pet_allowed,pdd.coq,pdd.section8,pdd.handicap,p.sq_ft,p.property_zip,p.property_state,p.description,p.prog_type,p.tag_line,pdd.min_bath,pdd.min_bed,pdd.max_bed,pdd.min_rent,pdd.max_rent,pdd.seniorprop,pdd.seniorpropval,pd.
header_description,pd.header_value , p.phone ,pdd.seniorprop,pdd.seniorprop
                        from property p
                        left join
                        property_detail pdd on p.id_property =
pdd.id_property
                        left join 
                        property_deals pd on p.id_property = pd.id_property

                        left join 
                        property_contact pc on pc.id_property =
p.id_property 
                        where p.id_property = 1576
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.393990 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=1576 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.394530 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `rating`
in /home/cavepear/rentalhousingdeals.com/protected/models/Rating.php (25)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
23:23:59.395824 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `rating`
in /home/cavepear/rentalhousingdeals.com/protected/models/Rating.php (25)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
23:23:59.396228 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.396445 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.396969 trace system.CModule 
Loading "user" application component
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(41)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
23:23:59.397074 trace system.CModule 
Loading "session" application component
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(41)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
23:23:59.397805 trace system.db.CDbCommand 
Querying SQL: select
p.id_property,p.property_title,p.property_type,p.property_address,
                       
p.property_city,pdd.pet_allowed,pdd.coq,pdd.section8,pdd.handicap,p.sq_ft,p.property_zip,p.property_state,p.description,p.prog_type,p.tag_line,pdd.min_bath,pdd.min_bed,pdd.max_bed,pdd.min_rent,pdd.max_rent,pdd.seniorprop,pdd.seniorpropval,pd.
header_description,pd.header_value , p.phone ,pdd.seniorprop,pdd.seniorprop
                        from property p
                        left join
                        property_detail pdd on p.id_property =
pdd.id_property
                        left join 
                        property_deals pd on p.id_property = pd.id_property

                        left join 
                        property_contact pc on pc.id_property =
p.id_property 
                        where p.id_property = 33497
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.398442 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=33497 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.398823 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.398936 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.399802 trace system.db.CDbCommand 
Querying SQL: select
p.id_property,p.property_title,p.property_type,p.property_address,
                       
p.property_city,pdd.pet_allowed,pdd.coq,pdd.section8,pdd.handicap,p.sq_ft,p.property_zip,p.property_state,p.description,p.prog_type,p.tag_line,pdd.min_bath,pdd.min_bed,pdd.max_bed,pdd.min_rent,pdd.max_rent,pdd.seniorprop,pdd.seniorpropval,pd.
header_description,pd.header_value , p.phone ,pdd.seniorprop,pdd.seniorprop
                        from property p
                        left join
                        property_detail pdd on p.id_property =
pdd.id_property
                        left join 
                        property_deals pd on p.id_property = pd.id_property

                        left join 
                        property_contact pc on pc.id_property =
p.id_property 
                        where p.id_property = 33495
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.400480 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=33495 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.400877 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.400990 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.401860 trace system.db.CDbCommand 
Querying SQL: select
p.id_property,p.property_title,p.property_type,p.property_address,
                       
p.property_city,pdd.pet_allowed,pdd.coq,pdd.section8,pdd.handicap,p.sq_ft,p.property_zip,p.property_state,p.description,p.prog_type,p.tag_line,pdd.min_bath,pdd.min_bed,pdd.max_bed,pdd.min_rent,pdd.max_rent,pdd.seniorprop,pdd.seniorpropval,pd.
header_description,pd.header_value , p.phone ,pdd.seniorprop,pdd.seniorprop
                        from property p
                        left join
                        property_detail pdd on p.id_property =
pdd.id_property
                        left join 
                        property_deals pd on p.id_property = pd.id_property

                        left join 
                        property_contact pc on pc.id_property =
p.id_property 
                        where p.id_property = 1689
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.402807 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=1689 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.403392 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.403510 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.404628 trace system.db.CDbCommand 
Querying SQL: select
p.id_property,p.property_title,p.property_type,p.property_address,
                       
p.property_city,pdd.pet_allowed,pdd.coq,pdd.section8,pdd.handicap,p.sq_ft,p.property_zip,p.property_state,p.description,p.prog_type,p.tag_line,pdd.min_bath,pdd.min_bed,pdd.max_bed,pdd.min_rent,pdd.max_rent,pdd.seniorprop,pdd.seniorpropval,pd.
header_description,pd.header_value , p.phone ,pdd.seniorprop,pdd.seniorprop
                        from property p
                        left join
                        property_detail pdd on p.id_property =
pdd.id_property
                        left join 
                        property_deals pd on p.id_property = pd.id_property

                        left join 
                        property_contact pc on pc.id_property =
p.id_property 
                        where p.id_property = 33500
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.405498 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=33500 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.406064 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.406183 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.407272 trace system.db.CDbCommand 
Querying SQL: select
p.id_property,p.property_title,p.property_type,p.property_address,
                       
p.property_city,pdd.pet_allowed,pdd.coq,pdd.section8,pdd.handicap,p.sq_ft,p.property_zip,p.property_state,p.description,p.prog_type,p.tag_line,pdd.min_bath,pdd.min_bed,pdd.max_bed,pdd.min_rent,pdd.max_rent,pdd.seniorprop,pdd.seniorpropval,pd.
header_description,pd.header_value , p.phone ,pdd.seniorprop,pdd.seniorprop
                        from property p
                        left join
                        property_detail pdd on p.id_property =
pdd.id_property
                        left join 
                        property_deals pd on p.id_property = pd.id_property

                        left join 
                        property_contact pc on pc.id_property =
p.id_property 
                        where p.id_property = 33496
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.408139 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=33496 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.408713 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.408833 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.409852 trace system.db.CDbCommand 
Querying SQL: select
p.id_property,p.property_title,p.property_type,p.property_address,
                       
p.property_city,pdd.pet_allowed,pdd.coq,pdd.section8,pdd.handicap,p.sq_ft,p.property_zip,p.property_state,p.description,p.prog_type,p.tag_line,pdd.min_bath,pdd.min_bed,pdd.max_bed,pdd.min_rent,pdd.max_rent,pdd.seniorprop,pdd.seniorpropval,pd.
header_description,pd.header_value , p.phone ,pdd.seniorprop,pdd.seniorprop
                        from property p
                        left join
                        property_detail pdd on p.id_property =
pdd.id_property
                        left join 
                        property_deals pd on p.id_property = pd.id_property

                        left join 
                        property_contact pc on pc.id_property =
p.id_property 
                        where p.id_property = 1632
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.410710 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=1632 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.411261 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.411401 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.412484 trace system.db.CDbCommand 
Querying SQL: select
p.id_property,p.property_title,p.property_type,p.property_address,
                       
p.property_city,pdd.pet_allowed,pdd.coq,pdd.section8,pdd.handicap,p.sq_ft,p.property_zip,p.property_state,p.description,p.prog_type,p.tag_line,pdd.min_bath,pdd.min_bed,pdd.max_bed,pdd.min_rent,pdd.max_rent,pdd.seniorprop,pdd.seniorpropval,pd.
header_description,pd.header_value , p.phone ,pdd.seniorprop,pdd.seniorprop
                        from property p
                        left join
                        property_detail pdd on p.id_property =
pdd.id_property
                        left join 
                        property_deals pd on p.id_property = pd.id_property

                        left join 
                        property_contact pc on pc.id_property =
p.id_property 
                        where p.id_property = 1528
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.413381 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=1528 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.413924 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.414042 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.415107 trace system.db.CDbCommand 
Querying SQL: select
p.id_property,p.property_title,p.property_type,p.property_address,
                       
p.property_city,pdd.pet_allowed,pdd.coq,pdd.section8,pdd.handicap,p.sq_ft,p.property_zip,p.property_state,p.description,p.prog_type,p.tag_line,pdd.min_bath,pdd.min_bed,pdd.max_bed,pdd.min_rent,pdd.max_rent,pdd.seniorprop,pdd.seniorpropval,pd.
header_description,pd.header_value , p.phone ,pdd.seniorprop,pdd.seniorprop
                        from property p
                        left join
                        property_detail pdd on p.id_property =
pdd.id_property
                        left join 
                        property_deals pd on p.id_property = pd.id_property

                        left join 
                        property_contact pc on pc.id_property =
p.id_property 
                        where p.id_property = 1682
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.415831 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=1682 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.416205 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.416318 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.417176 trace system.db.CDbCommand 
Querying SQL: select
p.id_property,p.property_title,p.property_type,p.property_address,
                       
p.property_city,pdd.pet_allowed,pdd.coq,pdd.section8,pdd.handicap,p.sq_ft,p.property_zip,p.property_state,p.description,p.prog_type,p.tag_line,pdd.min_bath,pdd.min_bed,pdd.max_bed,pdd.min_rent,pdd.max_rent,pdd.seniorprop,pdd.seniorpropval,pd.
header_description,pd.header_value , p.phone ,pdd.seniorprop,pdd.seniorprop
                        from property p
                        left join
                        property_detail pdd on p.id_property =
pdd.id_property
                        left join 
                        property_deals pd on p.id_property = pd.id_property

                        left join 
                        property_contact pc on pc.id_property =
p.id_property 
                        where p.id_property = 1706
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.417808 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=1706 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.418181 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.418296 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.419138 trace system.db.CDbCommand 
Querying SQL: select
p.id_property,p.property_title,p.property_type,p.property_address,
                       
p.property_city,pdd.pet_allowed,pdd.coq,pdd.section8,pdd.handicap,p.sq_ft,p.property_zip,p.property_state,p.description,p.prog_type,p.tag_line,pdd.min_bath,pdd.min_bed,pdd.max_bed,pdd.min_rent,pdd.max_rent,pdd.seniorprop,pdd.seniorpropval,pd.
header_description,pd.header_value , p.phone ,pdd.seniorprop,pdd.seniorprop
                        from property p
                        left join
                        property_detail pdd on p.id_property =
pdd.id_property
                        left join 
                        property_deals pd on p.id_property = pd.id_property

                        left join 
                        property_contact pc on pc.id_property =
p.id_property 
                        where p.id_property = 1546
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.419934 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=1546 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.420306 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.420420 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.422734 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "Los Angeles CA" or
abbr = "Los Angeles CA"
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php
(550)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchgmap/searchgmap.php
(31)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(201)
23:23:59.423180 trace system.db.CDbCommand 
Querying SQL: select p.id_property as pid, p.property_title as name,p.lat,
p.lng, (CASE p.property_type WHEN "premium" THEN 1 WHEN  "classified" THEN
2 else 3 END) as ordval,p.property_address as address,p.property_state as
state,property_city as city, "all" as ptype, p.property_type as pt ,
(((acos(sin(("34.0408027000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.0408027000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.2905733000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from property p 
left join property_detail pd  on p.id_property = pd.id_property   where 1=1
and (status = "Approved" OR status = "Pending")  and pd.seniorprop =  "Yes"
GROUP by pid  HAVING distance <= 60 
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchgmap/searchgmap.php
(85)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(201)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.516911 trace system.db.CDbCommand 
Querying SQL: select p.id_property as pid, p.property_title as name,p.lat,
p.lng, (CASE p.property_type WHEN "premium" THEN 1 WHEN  "classified" THEN
2 else 3 END) as ordval,p.property_address as address,p.property_state as
state,property_city as city, "all" as ptype, p.property_type as pt ,
(((acos(sin(("34.0408027000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.0408027000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.2905733000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from property p 
left join property_detail pd  on p.id_property = pd.id_property   where 1=1
and (status = "Approved" OR status = "Pending")  and pd.seniorprop =  "Yes"
GROUP by pid  HAVING distance <= 60  order by ordval ASC , distance ASC 
limit 6,10
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchgmap/searchgmap.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(201)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.609707 trace system.db.CDbCommand 
Querying SQL: select h.*,(((acos(sin(("34.0408027000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.0408027000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.2905733000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority h HAVING distance <= 150  order by distance ASC limit 5
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/housingauthoritynearby.php
(23)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(278)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
23:23:59.624341 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where id =3457
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/views/_view.php
(8)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/housingauthoritynearby.php
(25)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(278)
23:23:59.624824 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where id =1334
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/views/_view.php
(8)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/housingauthoritynearby.php
(25)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(278)
23:23:59.625252 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where id =1467
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/views/_view.php
(8)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/housingauthoritynearby.php
(25)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(278)
23:23:59.625629 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where id =1649
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/views/_view.php
(8)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/housingauthoritynearby.php
(25)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(278)
23:23:59.625983 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where id =5188
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/views/_view.php
(8)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/housingauthoritynearby.php
(25)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(278)
23:23:59.626835 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
(346)
in /home/cavepear/rentalhousingdeals.com/index.php (16)