1. Home
  2. CA
  3. Santa Fe Springs
$0
$5000
942 Affordable Housings in/near Santa Fe Springs, CA
78
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   
79
Save
Harbor Tower
340 South Mesa | San Pedro, CA, 90731
affordable housing apartments
  • r_a
  • pet allowed
  • r_c
Call Now: (310) 831-8981
  Studio BR | 1 BA   
80
Save
Voorhis Village
505 N. San Dimas Canyon Rd. | San Dimas, CA, 91773
1 to 4 bedroom affordable housing apartments
  • r_a
Call Now: (909) 599-3412
Affordable Housing Subsidized Rent   SPECIALS 1 BR | 1 BA   
81
Save
Park Western Estates
1327 Park Western Dr. | San Pedro, CA, 90732
1 to 4 bedroom affordable housing apartments from $1175 up to $1818
  • r_b
  • r_a
Call Now: (310) 831-4418
Affordable Housing   $ 1,818 1 BR | 1 BA   
82
Save
Park Grand Apartments
858 E Grand Ave | Pomona, CA, 91766
2 to 4 bedroom affordable housing apartments from $783 up to $1464
  • r_b
Call Now: (909) 397-7771
Affordable Housing   $ 1,014-$1,267 2 BR | 1 BA   
83
Save
Heritage Pointe Senior Apartments
1801 Aviation Way | Redondo Beach, CA, 90278
1 to 2 bedroom affordable housing apartments from $1125 up to $1638
  • r_a
  • pet allowed
  • r_c
Call Now: (310) 318-8418
Rental Deal   $ 2,450 1 BR | 1 BA   
84
Save
Clemson Corbett / Clemson Market
5751 Corbett Street | Los Angeles, CA, 90016
2 bedroom affordable housing apartments
  • r_b
  • r_a
  • pet allowed
Call Now: (323) 730-2924
Affordable Housing Subsidized Rent   SPECIALS 2 BR | 2 BA   
85
Save
Sunset City Lights
2006 W Sunset Blvd | Los Angeles, CA, 90026
3 bedroom affordable housing apartments
  • r_a
  • pet allowed
Call Now: (213) 483-5769
Affordable Housing Subsidized Rent   SPECIALS 3 BR | 1.5 BA   
86
Save
Serenity Villas
158 East Bonita Avenue | Pomona, CA, 91767
1 to 2 bedroom affordable housing apartments from $1053 up to $1528
  • r_b
  • pet allowed
  • r_c
Call Now: (909) 596-2900
Affordable Housing   $ 1053 1 BR | 1 BA   
87
Save
Drake Manor
200 W Drake Street | Pomona, CA, 91767
1 bedroom affordable housing apartments
  • r_b
  • r_a
  • pet allowed
Call Now: (909) 593-9615
Affordable Housing Subsidized Rent   SPECIALS 1 BR | 1 BA   
88
Save
Mariposa Villa
3773 University Drive | Irvine, CA, 92612
1 bedroom affordable housing apartments
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (800) 500-7725
Waiting List Closed Please call for more information.  $ Waiting List Closed 1 BR | 1 BA   
78 - 88 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:43:36.198223 trace system.CModule 
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:36.198472 trace system.CModule 
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:36.198559 trace system.CModule 
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:36.200567 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:43:36.200659 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:43:36.201895 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:43:36.203593 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:43:36.203999 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:43:36.204412 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:43:36.204819 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:43:36.205178 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:43:36.205955 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:43:36.327321 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:43:36.328670 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:43:36.329138 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:43:36.329617 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:43:36.330883 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:43:36.331330 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:43:36.331691 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:43:36.332040 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:43:36.332382 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:43:36.332789 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:43:36.333133 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:43:36.333468 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:43:36.333796 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:43:36.334136 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:43:36.334474 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:43:36.334799 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:43:36.335127 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:43:36.335449 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:43:36.335782 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:43:36.336101 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:43:36.336550 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:43:36.338495 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:43:36.338953 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:43:36.339097 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:43:36.393960 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:43:36.394125 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:43:36.394431 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:43:36.395243 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:43:36.395662 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:43:36.434711 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
77
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:43:36.472040 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:43:36.472692 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:43:36.475447 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:43:36.476104 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)
23:43:36.476614 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)
23:43:36.477155 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:43:36.478360 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:43:36.478710 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:43:36.478955 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:43:36.479538 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:43:36.479676 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:43:36.480674 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)
23:43:36.481165 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)
23:43:36.481499 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)
23:43:36.482048 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 = 38643
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:43:36.482644 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=38643 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:43:36.483027 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:43:36.483159 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:43:36.484098 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38643
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:43:36.484555 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38643
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:43:36.484951 trace system.db.CDbCommand 
Querying SQL: select min((baths* 1) / 0.5) as mbath from
property_floor_plan where id_property = 38643
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:43:36.485510 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 = 2337
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:43:36.486112 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=2337 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:43:36.486505 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:43:36.486635 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:43:36.487574 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 2337
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:43:36.487993 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 2337
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:43:36.488358 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 = 2337
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:43:36.488941 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 = 2501
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:43:36.489533 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=2501 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:43:36.489919 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:43:36.490041 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:43:36.490962 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 2501
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:43:36.491424 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 2501
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:43:36.491794 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 = 2501
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:43:36.492357 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 = 34756
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:43:36.492989 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=34756 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:43:36.493397 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:43:36.493519 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:43:36.494426 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 34756
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:43:36.494869 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 34756
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:43:36.495253 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 = 34756
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:43:36.495840 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 = 37883
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:43:36.496506 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=37883 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:43:36.496925 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:43:36.497045 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:43:36.497958 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 37883
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:43:36.498400 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 37883
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:43:36.498781 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 = 37883
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:43:36.499362 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 = 32882
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:43:36.499974 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=32882 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:43:36.500379 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:43:36.500510 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:43:36.501455 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 32882
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:43:36.501877 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 32882
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:43:36.502250 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 = 32882
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:43:36.502832 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 = 37931
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:43:36.503464 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=37931 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:43:36.503868 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:43:36.503997 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:43:36.504925 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 37931
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:43:36.505373 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 37931
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:43:36.505744 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 = 37931
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:43:36.506316 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 = 33483
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:43:36.507050 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=33483 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:43:36.507451 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:43:36.507580 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:43:36.508544 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 33483
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:43:36.508995 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 33483
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:43:36.509381 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 = 33483
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:43:36.509968 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 = 38126
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:43:36.510596 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=38126 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:43:36.510997 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:43:36.511087 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:43:36.511708 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38126
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:43:36.512110 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38126
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:43:36.512439 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 = 38126
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:43:36.512898 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 = 1423
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:43:36.513465 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=1423 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:43:36.513833 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:43:36.513921 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:43:36.514745 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 1423
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:43:36.515122 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 1423
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:43:36.515489 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 = 1423
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:43:36.518003 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:43:36.518476 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:43:36.706186 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 7,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:43:36.920887 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:43:36.935611 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:43:36.936001 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:43:36.936320 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:43:36.936630 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:43:36.936943 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:43:36.937684 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)