1. Home
  2. CA
  3. Los Angeles
$0
$5000
363 Senior Housing in/near Los Angeles, CA
1
Save
Sangnok Villa
732 S. Bonnie Brae | Los Angeles, CA, 90057
1 bedroom affordable housing apartments from $1141 up to $1145
  • r_a
  • r_c
Call Now: (213) 483-1192
Senior Housing For Seniors 62 years or older  $ Accepting Applications 1 BR | 1 BA   
2
Save
Mac Arthur Park Towers
450 Grand View Street | Los Angeles, CA, 90057
affordable housing apartments
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (213) 382-8395
Affordable Housing Rent is 30% of adjusted income. Income limitations apply. Call for more information  $ Accepting Applications 1 BR | 1 BA   
3
Save
Angelus Plaza
255 South Hill Street | Los Angeles, CA, 90012
1 bedroom apartments
  • r_a
  • pet allowed
  • r_c
Call Now: (213) 623-4352
Affordable Housing   $ 1,260 1 BR | 1 BA   
4
Save
Angelus Plaza North
255 South Hill Street | Los Angeles, CA, 90012
1 bedroom affordable housing apartments
  • r_a
  • pet allowed
  • r_c
Call Now: (213) 623-4352
Affordable Housing   $ 1,260 1 BR | 1 BA   
5
Save
Rittenhouse Square
1100 E 33rd Street | Los Angeles, CA, 90011
1 to 2 bedroom affordable housing apartments from $900 up to $1153
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (323) 432-0890
Affordable Housing Subsidized Rent   SPECIALS 1 BR | 1 BA   
6
Save
Broadwood Terrace
5005 S. Main St | Los Angeles, CA, 90037
apartments
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (323) 235-5280
Affordable Housing Rent is 30% of adjusted income  1 BR | 1 BA   
7
Save
Colonia Jess Lopez
2627 E. Olympic Boulevard | Los Angeles, CA, 90023
affordable housing apartments
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (323) 266-4300
Affordable Housing Rent is 30% of adjusted income. Income limitations apply. Call for more information.  $ Accepting Applications 1 BR | 1 BA   
8
Save
Hollenbeck Terrace
610 S. St. Louis Street | Los Angeles, CA, 90023
Studio to 1 bedroom affordable housing apartments
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (323) 265-3949
Affordable Housing   $ 751 Studio BR | 1 BA   
9
Save
Hollyview
5411 Hollywood Blvd. | Hollywood, CA, 90027
apartments
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (323) 467-5117
  1 BR | 1 BA   
10
Save
Figueroa Senior Apartments
7621 S. Figueroa Street | Los Angeles, CA, 90003
1 bedroom affordable housing apartments from $734 up to $889
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (323) 750-2000
Affordable Housing   $ 889 1 BR | 1 BA   
11
Save
Las Alturas Apartments
3535 Whittier Blvd. | Los Angeles, CA, 90023
apartments
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (323) 526-6990
Affordable Housing Waiting list is closed.  $ Not Accepting Applications 1 BR | 1 BA   
1 - 11 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
20:59:14.412889 trace system.CModule 
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:59:14.413347 trace system.CModule 
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:59:14.413482 trace system.CModule 
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:59:14.416557 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)
20:59:14.416729 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)
20:59:14.418265 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)
20:59:14.420263 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)
20:59:14.420717 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)
20:59:14.421107 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)
20:59:14.421468 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)
20:59:14.421811 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)
20:59:14.422873 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)
20:59:14.552078 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)
20:59:14.554111 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)
20:59:14.554761 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)
20:59:14.555501 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)
20:59:14.557578 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)
20:59:14.558124 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)
20:59:14.558614 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)
20:59:14.559134 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)
20:59:14.559647 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)
20:59:14.560286 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)
20:59:14.560743 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)
20:59:14.561131 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)
20:59:14.561501 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)
20:59:14.561881 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)
20:59:14.562242 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)
20:59:14.562594 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)
20:59:14.562958 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)
20:59:14.563297 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)
20:59:14.563632 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)
20:59:14.563961 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)
20:59:14.564528 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)
20:59:14.566701 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)
20:59:14.567265 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)
20:59:14.567431 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)
20:59:14.630942 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)
20:59:14.631220 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)
20:59:14.631797 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)
20:59:14.633339 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)
20:59:14.633965 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)
20:59:14.672744 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
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)
20:59:14.714168 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)
20:59:14.714991 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)
20:59:14.718045 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)
20:59:14.718803 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 = 38508
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)
20:59:14.719530 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=38508 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)
20:59:14.720254 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)
20:59:14.721764 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)
20:59:14.722342 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)
20:59:14.722791 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)
20:59:14.723603 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)
20:59:14.723781 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)
20:59:14.725055 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38508
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.725486 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38508
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.725800 trace system.db.CDbCommand 
Querying SQL: select min(beds) as mbeds ,min((baths* 1) / 0.5) as mbath
from property_floor_plan where id_property = 38508
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.726249 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 = 38566
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)
20:59:14.726759 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=38566 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)
20:59:14.727092 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)
20:59:14.727185 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)
20:59:14.727864 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38566
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.728307 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38566
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.728637 trace system.db.CDbCommand 
Querying SQL: select min(beds) as mbeds ,min((baths* 1) / 0.5) as mbath
from property_floor_plan where id_property = 38566
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.729094 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 = 38549
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)
20:59:14.729652 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=38549 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)
20:59:14.729999 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)
20:59:14.730096 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)
20:59:14.730786 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38549
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.731277 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38549
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.731652 trace system.db.CDbCommand 
Querying SQL: select min(beds) as mbeds ,min((baths* 1) / 0.5) as mbath
from property_floor_plan where id_property = 38549
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.732315 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 = 38550
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)
20:59:14.733041 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=38550 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)
20:59:14.733450 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)
20:59:14.733594 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)
20:59:14.734643 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38550
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.735104 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38550
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.735507 trace system.db.CDbCommand 
Querying SQL: select min(beds) as mbeds ,min((baths* 1) / 0.5) as mbath
from property_floor_plan where id_property = 38550
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.736088 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 = 38124
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)
20:59:14.736764 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=38124 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)
20:59:14.737198 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)
20:59:14.737304 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)
20:59:14.738231 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38124
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.738743 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38124
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.739155 trace system.db.CDbCommand 
Querying SQL: select min(beds) as mbeds ,min((baths* 1) / 0.5) as mbath
from property_floor_plan where id_property = 38124
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.739728 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 = 38558
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)
20:59:14.740379 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=38558 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)
20:59:14.740803 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)
20:59:14.740905 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)
20:59:14.741913 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38558
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.742368 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38558
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.742758 trace system.db.CDbCommand 
Querying SQL: select min(beds) as mbeds ,min((baths* 1) / 0.5) as mbath
from property_floor_plan where id_property = 38558
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.743421 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 = 38587
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)
20:59:14.744000 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=38587 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)
20:59:14.744421 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)
20:59:14.744560 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)
20:59:14.745469 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38587
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.745937 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38587
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.746354 trace system.db.CDbCommand 
Querying SQL: select min(beds) as mbeds ,min((baths* 1) / 0.5) as mbath
from property_floor_plan where id_property = 38587
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.747000 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 = 33480
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)
20:59:14.747651 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=33480 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)
20:59:14.748029 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)
20:59:14.748116 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)
20:59:14.748861 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 33480
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.749229 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 33480
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.749573 trace system.db.CDbCommand 
Querying SQL: select min((baths* 1) / 0.5) as mbath from
property_floor_plan where id_property = 33480
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(186)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.750021 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 = 38660
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)
20:59:14.750575 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=38660 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)
20:59:14.750948 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)
20:59:14.751039 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)
20:59:14.751753 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38660
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.752182 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38660
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.752537 trace system.db.CDbCommand 
Querying SQL: select min(beds) as mbeds ,min((baths* 1) / 0.5) as mbath
from property_floor_plan where id_property = 38660
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.753046 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 = 34196
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)
20:59:14.753611 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=34196 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)
20:59:14.753984 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)
20:59:14.754084 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)
20:59:14.754792 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 34196
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.755223 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 34196
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.755578 trace system.db.CDbCommand 
Querying SQL: select min(beds) as mbeds ,min((baths* 1) / 0.5) as mbath
from property_floor_plan where id_property = 34196
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.756047 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 = 38672
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)
20:59:14.756616 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=38672 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)
20:59:14.757117 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)
20:59:14.757224 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)
20:59:14.758044 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38672
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.758475 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38672
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.758893 trace system.db.CDbCommand 
Querying SQL: select min(beds) as mbeds ,min((baths* 1) / 0.5) as mbath
from property_floor_plan where id_property = 38672
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:59:14.761879 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)
20:59:14.762453 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)
20:59:14.868985 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 0,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)
20:59:14.979538 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)
20:59:14.996076 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)
20:59:14.996469 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)
20:59:14.996792 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)
20:59:14.997083 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)
20:59:14.997359 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)
20:59:14.997926 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)