1. Home
  2. CA
  3. Santa Fe Springs
$0
$5000
942 Affordable Housings in/near Santa Fe Springs, CA
23
Save
Gibson Manor
1501 E Century Blvd | Los Angeles, CA, 90002
1 bedroom apartments from $700 up to $700
  • r_a
  • r_c
Call Now: (323) 564-0478
Rental Deal   $ MOVE-IN
SPECIALS 1 BR | 1 BA   
24
Save
Telacu Senior Court
14442 Pacific Avenue | Baldwin Park, CA, 91706
1 to 1 bedroom apartments
  • r_a
  • r_c
Call Now: (626) 813-9937
Rental Deal   $ MOVE-IN
SPECIALS Studio BR | 1 BA   
25
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   
26
Save
Rio Vista Village
1310 Rio Vista Avenue | Los Angeles, CA, 90023
affordable housing apartments
  • r_b
  • pet allowed
Call Now: (323) 266-2014
  2 BR | 1 BA   
27
Save
Courtyards On Long Beach
1027 and 1045 Redondo Ave | Long Beach, CA, 90804
Studio bedroom affordable housing apartments from $1179 up to $1179
  • r_a
Call Now: (562) 433-3473
Affordable Housing   $ 1,179 Studio BR | 1 BA   
28
Save
Burke Manor
15 N 3rd St. | Alhambra, CA, 91801
1 to 1 bedroom affordable housing apartments
  • r_b
  • r_a
  • r_c
Call Now: (626) 458-1505
Affordable Housing   $ Waiting List Closed Studio BR | 1 BA   
29
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   
30
Save
West Covina Senior Villas II
1838 Workman Avenue | West Covina, CA, 91791
1 bedroom affordable housing apartments from $950 up to $950
  • r_b
  • r_a
  • r_c
Call Now: (626) 331-7100
Affordable Housing   $ 950 1 BR | 1 BA   
31
Save
West Covina Senior Villas
1842 Workman Avenue | West Covina, CA, 91791
1 bedroom affordable housing apartments from $950 up to $950
  • r_b
  • r_a
  • r_c
Call Now: (626) 331-0208
Affordable Housing   $ 950 1 BR | 1 BA   
32
Save
L.A. Pro III
5426 Sierra Vista Ave | Los Angeles, CA, 90038
1 bedroom affordable housing apartments from $600 up to $600
  • r_b
Call Now: (323) 971-6387
Affordable Housing Subsidized Rent   SPECIALS Studio BR | 1 BA   
33
Save
Broadway City Lights
8000 S Broadway | Los Angeles, CA, 90003
4 bedroom affordable housing apartments
  • r_a
  • pet allowed
Call Now: (323) 750-5346
Affordable Housing Subsidized Rent   SPECIALS 4 BR | 2 BA   
23 - 33 of 942 Apts Results



credit_banner
gazelle

Housing Authority Nearby

Lawndale Housing Authority
Lawndale Housing Authority
12131 Telegraph Rd.
Santa Fe Springs , CA 90607
Norwalk Housing Authority
Norwalk Housing Authority
12700 Norwalk Blvd., Rm. 11
Norwalk , CA 90650
Santa Fe Springs Housing Authority
Santa Fe Springs Housing Authority
11710 E. Telegraph Rd.
Santa Fe Springs , CA 90670
Pico Rivera Housing Division
Pico Rivera Housing Division
6615 Passons Blvd.
Pico Rivera , CA 90660
Paramount Housing Authority
Paramount Housing Authority
16400 Colorado Avenue
Paramount , CA 90723
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:41:58.526005 trace system.CModule 
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:41:58.526308 trace system.CModule 
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:41:58.526412 trace system.CModule 
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:41:58.528970 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:41:58.529084 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:41:58.530457 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:41:58.532663 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:41:58.533113 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:41:58.533559 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:41:58.533982 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:41:58.534389 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:41:58.535211 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:41:58.635513 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:41:58.636991 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:41:58.637515 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:41:58.638180 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:41:58.639858 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:41:58.640362 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`,'"',''),'/ ',' '),'-',' ') = 'Santa Fe
Springs'  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:41:58.640782 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`,'"',''),'/ ',' '),'-',' ') = 'Santa Fe
Springs'  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:41:58.641274 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`,'"',''),'/ ',' '),'-',' ') = 'Santa Fe
Springs'  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:41:58.641748 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:41:58.642297 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:41:58.642755 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:41:58.643136 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:41:58.643506 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:41:58.643879 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:41:58.644236 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:41:58.644588 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:41:58.644957 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:41:58.645271 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:41:58.645612 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:41:58.645942 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:41:58.646421 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:41:58.648555 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:41:58.649166 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:41:58.649312 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 '%Santa Fe Springs CA%' OR concat_ws(' '
, replace(replace(replace(`property_city`,'"',''),'/ ',' '),'-','
'),property.property_state ) like '%Santa Fe Springs 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:41:58.721366 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:41:58.721544 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:41:58.721895 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:41:58.723165 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "Santa Fe Springs CA"
or abbr = "Santa Fe Springs 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:41:58.723639 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((33.9317 *pi()/180)) *
sin((`lat`*pi()/180))+cos((33.9317 *pi()/180)) * cos((`lat`*pi()/180)) *
cos(((-118.0474 - `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 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:41:58.763092 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((33.9317 *pi()/180)) *
sin((`lat`*pi()/180))+cos((33.9317 *pi()/180)) * cos((`lat`*pi()/180)) *
cos(((-118.0474 - `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 group by pid
HAVING distance <= 60 order by ordval ASC , distance ASC  LIMIT 11 OFFSET
22
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:41:58.798990 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "Santa Fe Springs CA"
or abbr = "Santa Fe Springs 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:41:58.799657 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:41:58.802525 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:41:58.803114 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 = 32876
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:41:58.803673 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=32876 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:41:58.804235 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:41:58.805425 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:41:58.805830 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:41:58.806092 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:41:58.806641 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:41:58.806787 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:41:58.807857 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 32876
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)
23:41:58.808326 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 32876
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)
23:41:58.808712 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 = 32876
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)
23:41:58.809314 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 = 1043
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:41:58.809870 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=1043 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:41:58.810233 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:41:58.810375 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:41:58.811367 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 1043
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)
23:41:58.811762 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 1043
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)
23:41:58.812109 trace system.db.CDbCommand 
Querying SQL: select min((baths* 1) / 0.5) as mbath from
property_floor_plan where id_property = 1043
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)
23:41:58.812678 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)
23:41:58.813224 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)
23:41:58.813592 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:41:58.813738 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:41:58.814743 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)
23:41:58.815134 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)
23:41:58.815474 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)
23:41:58.816052 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 = 38651
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:41:58.816605 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=38651 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:41:58.817012 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:41:58.817154 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:41:58.818188 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38651
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)
23:41:58.818639 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38651
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)
23:41:58.819039 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 = 38651
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)
23:41:58.819686 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 = 33193
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:41:58.820336 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=33193 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:41:58.820776 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:41:58.820928 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:41:58.821974 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 33193
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)
23:41:58.822422 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 33193
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)
23:41:58.822815 trace system.db.CDbCommand 
Querying SQL: select min((baths* 1) / 0.5) as mbath from
property_floor_plan where id_property = 33193
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)
23:41:58.823430 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 = 986
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:41:58.824073 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=986 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:41:58.824491 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:41:58.824635 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:41:58.825644 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 986
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)
23:41:58.826097 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 986
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)
23:41:58.826493 trace system.db.CDbCommand 
Querying SQL: select min((baths* 1) / 0.5) as mbath from
property_floor_plan where id_property = 986
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)
23:41:58.827111 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)
23:41:58.827770 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)
23:41:58.828202 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:41:58.828345 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:41:58.829413 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)
23:41:58.829874 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)
23:41:58.830285 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)
23:41:58.830914 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 = 34135
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:41:58.831597 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=34135 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:41:58.832029 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:41:58.832174 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:41:58.833241 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 34135
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)
23:41:58.833695 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 34135
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)
23:41:58.834109 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 = 34135
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)
23:41:58.834748 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 = 34132
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:41:58.835464 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=34132 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:41:58.835880 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:41:58.836024 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:41:58.837093 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 34132
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)
23:41:58.837555 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 34132
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)
23:41:58.837970 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 = 34132
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)
23:41:58.838624 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 = 1640
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:41:58.839287 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=1640 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:41:58.839731 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:41:58.839876 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:41:58.840950 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 1640
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)
23:41:58.841430 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 1640
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)
23:41:58.841849 trace system.db.CDbCommand 
Querying SQL: select min((baths* 1) / 0.5) as mbath from
property_floor_plan where id_property = 1640
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)
23:41:58.842482 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 = 37926
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:41:58.843190 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=37926 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:41:58.843637 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:41:58.843782 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:41:58.844856 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 37926
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)
23:41:58.845293 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 37926
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)
23:41:58.845711 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 = 37926
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)
23:41:58.848443 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "Santa Fe Springs CA"
or abbr = "Santa Fe Springs 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:41:58.848968 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(("33.9317403000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("33.9317403000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.0474420000000000"-
`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")  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:41:59.035186 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(("33.9317403000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("33.9317403000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.0474420000000000"-
`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")  GROUP by pid  HAVING
distance <= 60  order by ordval ASC , distance ASC  limit 2,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:41:59.272574 trace system.db.CDbCommand 
Querying SQL: select h.*,(((acos(sin(("33.9317403000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("33.9317403000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-118.0474420000000000"-
`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:41:59.287302 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where id =1488
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:41:59.287679 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where id =1506
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:41:59.287996 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where id =1606
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:41:59.288302 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where id =1529
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:41:59.288605 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where id =1518
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:41:59.289335 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)