1. Home
  2. TN
$0
$5000
573 Affordable Housings in/near TN
1
Save
South Central Village of Clarksville
1420 Paradise Hill Road | Clarksville, TN, 37043
1 to 2 bedroom affordable housing apartments from $951 up to $1095
  • r_b
  • r_a
  • r_c
Call Now: (931) 645-1274
Affordable Housing   $ 951 1 BR | 1 BA   
2
Save
Cedar Springs Apartments
364 Cedar View Way | Knoxville, TN, 37919
1 to 4 bedroom affordable housing apartments
  • r_b
Call Now: (865) 693-3644
Affordable Housing Subsidized Rent   SPECIALS 1 BR | 1 BA   
3
Save
Westgate Towers
134 Ridenour Lane | Jacksboro, TN, 37757
1 bedroom affordable housing apartments from $715 up to $715
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (423) 562-1650
Affordable Housing Subsidized Rent   SPECIALS 1 BR | 1 BA   
4
Save
Mckendree Lambuth At Gallatin
1054 Hartsville Pike | Gallatin, TN, 37066
1 bedroom affordable housing apartments
  • r_a
  • pet allowed
  • r_c
Call Now: (615) 230-2267
Affordable Housing Currently there is a waiting list.  $ Accepting Applications 1 BR | 1 BA   
5
Save
Mckendree Oaks At Savannah II
1700 Florence Rd. | Savannah, TN, 38372
1 bedroom affordable housing apartments from $400 up to $400
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (731) 925-8951
Affordable Housing Subsidized Rent   SPECIALS 1 BR | 1 BA   
6
Save
Kiwanis Towers
2701 East Center St. | Kingsport, TN, 37664
1 to 2 bedroom affordable housing apartments from $700 up to $788
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (423) 246-4302
Affordable Housing   $ 700 1 BR | 1 BA   
7
Save
River View Tower
500 W. Martin Luther King Blvd. | Chattanooga, TN, 37402
1 to 1 bedroom affordable housing apartments
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (423) 266-8740
Rental Deal   $ MOVE-IN
SPECIALS Studio BR | 1 BA   
8
Save
Bethel Housing
1113 Persimmon Ridge Rd. | Jonesborough, TN, 37659
1 bedroom affordable housing apartments
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (423) 753-7026
Affordable Housing   $ 756 1 BR | 1 BA   
9
Save
Indian Hills Apartments
48 Indian Hills Circle | Greeneville, TN, 37743
2 to 3 bedroom affordable housing apartments
  • r_b
  • r_a
Call Now: (423) 639-3866
Affordable Housing Subsidized Rent   SPECIALS 2 BR | 1 BA   
10
Save
Pecan Grove
520 Pecan Dr., #600 | Bolivar, TN, 38008
1 to 1 bedroom affordable housing apartments
  • r_a
  • pet allowed
  • r_c
Call Now: (731) 658-3140
Affordable Housing   $ 824 Studio BR | 1 BA   
11
Save
Forest Ridge Manor
1252 Bloomingdale Pike | Kingsport, TN, 37660
1 bedroom affordable housing apartments
  • r_b
  • r_a
  • pet allowed
  • r_c
Call Now: (423) 246-1562
Affordable Housing Subsidized Rent   SPECIALS 1 BR | 1 BA   
1 - 11 of 573 Apts Results



credit_banner
gazelle

Housing Authority Nearby

Memphis Housing Authority (MHA)
Memphis Housing Authority (MHA)
700 Adams Avenue
Memphis , TN 38105
West Memphis Housing Authority
West Memphis Housing Authority
2820 E. Harrison Ave.
West Memphis , AR 72301
Earle Section 8 Housing Authority
Earle Section 8 Housing Authority
2820 E. Harrison Ave.
West Memphis , AR 72301
Shelby County Department of Housing
Shelby County Department of Housing
1075 Mullins Station Rd.
Memphis , TN 38134
Millington Housing Authority
Millington Housing Authority
4888 Bill Knight Avenue
Millington , TN 38053
More Nearby Housing Authorities >>

DISCOVER
COMPANY
JOIN US ON
  • Twitter
  • Facebook
  • YouTube

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

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

Copyright © 2024 RentalHousingDeals.com, All Rights Reserved  Equal Housing Opportunity    
Application Log
Timestamp Level Category Message
20:48:12.536607 trace system.CModule 
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.537009 trace system.CModule 
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.537126 trace system.CModule 
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.539669 trace system.CModule 
Loading "db" application component
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.539799 trace system.db.CDbConnection 
Opening DB connection
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.541277 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `settings`
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.543585 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `settings`
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.544055 trace system.db.CDbCommand 
Querying SQL: select value from settings where setting_key = "facebook_url"
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.544486 trace system.db.CDbCommand 
Querying SQL: select value from settings where setting_key = "twitter_url"
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(56)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.544912 trace system.db.CDbCommand 
Querying SQL: select value from settings where setting_key = "admin_email"
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(58)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.545311 trace system.db.CDbCommand 
Querying SQL: select image from banner where status = "Active"
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(60)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.546324 trace system.db.CDbCommand 
Querying SQL: select p.property_state,p.property_city
,(((acos(sin(("34.052235" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.052235" *pi()/180)) * cos((`lat`*pi()/180))
* cos((("-118.243683"- `lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as
distance from property p group by p.property_city HAVING distance <= 50
order by distance ASC
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(127)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.644130 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `state`
in /home/cavepear/rentalhousingdeals.com/protected/models/State.php (20)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(36)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.645685 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `state`
in /home/cavepear/rentalhousingdeals.com/protected/models/State.php (20)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(36)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.646137 trace system.db.CDbCommand 
Querying SQL: select name from state where abbr = "TN" or name = "TN"
in /home/cavepear/rentalhousingdeals.com/protected/models/State.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(36)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.646704 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
(116)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.648164 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
(116)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.648621 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Affordable housing' and state = 'TN' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = ''  and
individual_type = ''
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(116)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.648992 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Senior Housing' and state = 'TN' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = ''  and
individual_type = ''
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(117)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.649338 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Section 8 Housing' and state = 'TN' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = ''  and
individual_type = ''
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(118)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.649679 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Affordable housing' and state = 'All' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = ''  and
individual_type = ''
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(125)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.650156 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"search_title_state"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(131)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.650501 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"search_keyword_state"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(132)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.650836 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"search_description_state"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(133)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.651165 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Senior Housing' and state = 'All' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = ''  and
individual_type = ''
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(142)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.651490 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"sin_search_title_state"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(148)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.651810 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"sin_search_keyword_state"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(149)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.652126 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"sin_search_description_state"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(150)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.652441 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Section 8 Housing' and state = 'All' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = ''  and
individual_type = ''
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(159)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.652769 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"s8_search_title_state"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(165)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.653090 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"s8_search_keyword_state"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(166)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.653403 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"s8_search_description_state"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(167)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.653924 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `property`
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(237)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.656007 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `property`
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(237)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.656511 trace system.CModule 
Loading "myUtility" application component
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(239)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.656657 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 '%TN%' OR concat_ws(' ' ,
replace(replace(replace(`property_city`,'"',''),'/ ',' '),'-','
'),property.property_state ) like '%TN%'group by concat_ws(',' ,
property.property_city,property.property_state ) order by prop_count desc
limit 1
in /home/cavepear/rentalhousingdeals.com/protected/components/MyUtility.php
(31)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(239)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.712744 trace system.CModule 
Loading "clientScript" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(2)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.712918 trace system.CModule 
Loading "widgetFactory" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(59)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.713300 trace system.CModule 
Loading "assetManager" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(59)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
20:48:12.714565 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "TN" or abbr = "TN"
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php
(550)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
20:48:12.715038 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 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 = (select abbr from state where name = "TN")  or
p.property_state = "TN") and pd.min_rent between 0 and  5000 group by pid 
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(97)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.733721 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 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 = (select abbr from state where name = "TN")  or
p.property_state = "TN") and pd.min_rent between 0 and  5000 group by pid 
order by ordval ASC   LIMIT 11
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(150)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.751204 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "TN" or abbr = "TN"
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php
(550)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(158)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
20:48:12.751621 trace system.db.CDbCommand 
Querying SQL: select name from state where abbr = "TN" or name = "TN"
in /home/cavepear/rentalhousingdeals.com/protected/models/State.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(160)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
20:48:12.752191 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `property_detail`
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyDetail.php
(61)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(186)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
20:48:12.754992 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `property_detail`
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyDetail.php
(61)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(186)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
20:48:12.755578 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 = 19648
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.756093 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=19648 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.756634 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `rating`
in /home/cavepear/rentalhousingdeals.com/protected/models/Rating.php (25)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
20:48:12.757760 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `rating`
in /home/cavepear/rentalhousingdeals.com/protected/models/Rating.php (25)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
20:48:12.758110 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.758358 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.758903 trace system.CModule 
Loading "user" application component
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(41)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
20:48:12.759054 trace system.CModule 
Loading "session" application component
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(41)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
20:48:12.760118 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19648
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.760618 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19648
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.760963 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 = 19648
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.761511 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 = 19811
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.762034 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=19811 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.762377 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.762506 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.763407 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19811
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.763778 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19811
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.764111 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 = 19811
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.764652 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 = 19755
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.765201 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=19755 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.765526 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.765655 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.766566 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19755
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.766987 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19755
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.767304 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 = 19755
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.767868 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 = 19724
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.768771 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=19724 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.769283 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.769411 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.770406 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19724
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.770972 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19724
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.771456 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 = 19724
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.772150 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 = 38131
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.773067 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=38131 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.773596 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.773722 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.774748 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38131
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.775310 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 38131
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.775804 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 = 38131
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.776504 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 = 19796
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.777376 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=19796 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.777905 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.778033 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.779056 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19796
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.779627 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19796
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.780128 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 = 19796
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.780879 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 = 19622
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.781708 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=19622 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.782072 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.782179 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.782913 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19622
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.783284 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19622
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.783612 trace system.db.CDbCommand 
Querying SQL: select min((baths* 1) / 0.5) as mbath from
property_floor_plan where id_property = 19622
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(186)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.784054 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 = 19787
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.784651 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=19787 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.785039 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.785147 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.785913 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19787
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.786292 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19787
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.786618 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 = 19787
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.787094 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 = 19733
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.787682 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=19733 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.788064 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.788186 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.789087 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19733
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.789491 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19733
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.789836 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 = 19733
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.790352 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 = 19601
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.790908 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=19601 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.791265 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.791383 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.792210 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19601
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.792795 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19601
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.793189 trace system.db.CDbCommand 
Querying SQL: select min((baths* 1) / 0.5) as mbath from
property_floor_plan where id_property = 19601
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(186)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.793697 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 = 19789
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(207)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.794342 trace system.db.CDbCommand 
Querying SQL: Select * from property_photo where id_property=19789 and
status = 'Active' order by id_property_photo ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(208)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.794754 trace system.db.ar.CActiveRecord 
Rating.findByAttributes()
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.794893 trace system.db.CDbCommand 
Querying SQL: SELECT * FROM `rating` `t` WHERE `t`.`id_property`=:yp0 LIMIT
1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(211)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(128)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.795672 trace system.db.CDbCommand 
Querying SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19789
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(183)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.796241 trace system.db.CDbCommand 
Executing SQL: select beds from property_floor_plan where beds = 'Studio'
and id_property = 19789
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(184)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.796597 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 = 19789
in
/home/cavepear/rentalhousingdeals.com/protected/models/PropertyFloorPlan.php
(191)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/views/_view.php
(283)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchresultlist/SearchResultList.php
(218)
20:48:12.798378 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "TN" or abbr = "TN"
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php
(550)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchgmap/searchgmap.php
(31)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(201)
20:48:12.799005 trace system.db.CDbCommand 
Querying SQL: select p.id_property as pid, p.property_title as name,(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, p.lat,
p.lng from property p  left join property_detail pd  on p.id_property =
pd.id_property   where 1=1 and (status = "Approved" OR status = "Pending")
and (p.property_state = (select abbr from state where name = "TN")  or
p.property_state = "TN") GROUP by pid 
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchgmap/searchgmap.php
(85)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(201)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.808034 trace system.db.CDbCommand 
Querying SQL: select p.id_property as pid, p.property_title as name,(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, p.lat,
p.lng from property p  left join property_detail pd  on p.id_property =
pd.id_property   where 1=1 and (status = "Approved" OR status = "Pending")
and (p.property_state = (select abbr from state where name = "TN")  or
p.property_state = "TN") GROUP by pid  order by ordval ASC   limit 0,10
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchgmap/searchgmap.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(201)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.813520 trace system.db.CDbCommand 
Querying SQL: select h.*,(((acos(sin(("35.1351678" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("35.1351678" *pi()/180)) * cos((`lat`*pi()/180))
* cos((("-90.0344408"- `lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as
distance from housingauthority h HAVING distance <= 150  order by distance
ASC limit 5
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/housingauthoritynearby.php
(23)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(278)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(346)
20:48:12.829144 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where id =3503
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/views/_view.php
(8)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/housingauthoritynearby.php
(25)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(278)
20:48:12.829567 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where id =1203
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/views/_view.php
(8)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/housingauthoritynearby.php
(25)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(278)
20:48:12.829992 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where id =4426
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/views/_view.php
(8)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/housingauthoritynearby/housingauthoritynearby.php
(25)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/search.php
(278)
20:48:12.830801 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)