$0
$5000
114 Affordable Housings in/near DC
89
Save
2700-07 Douglas PL SE | WASHINGTON, DC, 20020
Sayles Place Homes Inc. apartments is an affordable housing community with 3 Bed(s) to 5+ Bed(s) apartments units.
Call Now: 202-889-2998
Affordable Housing   $ CALL 3 BR - 5+ BR   
90
Save
4335 4th Street SE | WASHINGTON, DC, 20032
Southern Hills Apts apartments is an affordable housing community with 1 Bed(s) to 3 Bed(s) apartments units.
Call Now: 202-561-8600
Affordable Housing   $ CALL 1 BR - 3 BR   
91
Save
215 O ST SW | WASHINGTON, DC, 20024
St James Mutual Home apartments is an affordable housing community with 1 Bed(s) to 3 Bed(s) apartments units.
Call Now: 703-484-3149
Affordable Housing   $ CALL 1 BR - 3 BR   
92
Save
725 24TH ST NW | WASHINGTON, DC, 20037
St. Mary's Court apartments is an affordable housing community with 1 Bed(s) apartments units.
  • r_c
Call Now: (202)223-5712
Affordable Housing   $ CALL 1 BR   
93
Save
325 ANACOSTIA RD SE | WASHINGTON, DC, 20019
Stoneridge Apts. Sec Ii apartments is an affordable housing community with 1 Bed(s) to 3 Bed(s) apartments units.
Call Now: 202-659-0700
Affordable Housing   $ CALL 1 BR - 3 BR   
94
Save
324 ANACOSTIA AVE SE | WASHINGTON, DC, 20019
Stoneridge I apartments is an affordable housing community with 1 Bed(s) to 3 Bed(s) apartments units.
Call Now: 202-659-0700
Affordable Housing   $ CALL 1 BR - 3 BR   
95
Save
1440 Meridian Pl NW | WASHINGTON, DC, 20010
Sunflower House apartments is an affordable housing community with 2 Bed(s) to 4 Bed(s) apartments units.
  • r_a
Call Now: 202-639-0361
Affordable Housing   $ CALL 2 BR - 4 BR   
96
Save
1112 FIRST TER NW | WASHINGTON, DC, 20001
Sursum Corda Cooperative apartments is an affordable housing community with 1 Bed(s) to 5+ Bed(s) apartments units.
Call Now: (202) 789-0636
Affordable Housing   $ CALL 1 BR - 5+ BR   
97
Save
34 O ST SW | WASHINGTON, DC, 20024
Tel Court Cooperative * apartments is an affordable housing community with 1 Bed(s) to 2 Bed(s) apartments units.
Call Now: 202-488-0552
Affordable Housing   $ CALL 1 BR - 2 BR   
98
Save
33 K ST NW | WASHINGTON, DC, 20001
Temple Courts apartments is an affordable housing community with Bed(s) apartments units.
Call Now: (202)789-0226
Affordable Housing   $ CALL   
99
Save
1222 T ST NW | WASHINGTON, DC, 20009
Terrific Inn apartments is an affordable housing community with 1 Bed(s) apartments units.
  • r_c
Call Now: (202) 234-4128
Affordable Housing   $ CALL 1 BR   
89 - 99 of 114 Apts Results



credit_banner

Housing Authority Nearby

D.C. Housing Authority
1133 N. Capitol Street, NE
Washington , DC 20002
Community Connections
801 Pennsylvania Ave. SE, Ste. 201
Washington , DC 20003
Arlington County Department of Human Services (ACDHS)
3033 Wilson Blvd
Arlington , VA 22201
College Park Housing Authority
9014 Rhode Island Avenue
College Park , MD 20740
Glenarden Housing Authority
8639 Glenarden Parkway
Glenarden , MD 20706

Application Log
Timestamp Level Category Message
23:31:09.516988 trace system.CModule
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:09.517277 trace system.CModule
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:09.517374 trace system.CModule
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:09.519711 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:31:09.519815 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:31:09.521260 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:31:09.523607 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:31:09.524080 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:31:09.524523 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:31:09.524955 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:31:09.525361 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:31:09.526161 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:31:09.609790 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:31:09.611243 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:31:09.611697 trace system.db.CDbCommand
Querying SQL: select name from state where abbr = "DC" or name = "DC"
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:31:09.612185 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)
23:31:09.613465 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)
23:31:09.613888 trace system.db.CDbCommand
Querying SQL: select title,keyword,description from seo_template where 
home = 'Affordable housing' and state = 'DC' 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)
23:31:09.614233 trace system.db.CDbCommand
Querying SQL: select title,keyword,description from seo_template where 
home = 'Senior Housing' and state = 'DC' 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)
23:31:09.614557 trace system.db.CDbCommand
Querying SQL: select title,keyword,description from seo_template where 
home = 'Section 8 Housing' and state = 'DC' 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)
23:31:09.614875 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)
23:31:09.615257 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)
23:31:09.615580 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)
23:31:09.615886 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)
23:31:09.616197 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)
23:31:09.616511 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)
23:31:09.616827 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)
23:31:09.617131 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)
23:31:09.617434 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)
23:31:09.617738 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)
23:31:09.618046 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)
23:31:09.618340 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)
23:31:09.618777 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:31:09.620754 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:31:09.621241 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:31:09.621381 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 '%DC%' OR concat_ws(' ' ,
replace(replace(replace(`property_city`,'"',''),'/ ',' '),'-','
'),property.property_state ) like '%DC%'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:31:09.675117 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:31:09.675263 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:31:09.675575 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:31:09.676749 trace system.db.CDbCommand
Querying SQL: select count(*) from state where name = "DC" or abbr = "DC"
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:31:09.677203 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 = "DC")  or
p.property_state = "DC") 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)
23:31:09.689837 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 = "DC")  or
p.property_state = "DC") and pd.min_rent between 0 and  5000 group by pid 
order by ordval ASC   LIMIT 11 OFFSET 88
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:31:09.702292 trace system.db.CDbCommand
Querying SQL: select count(*) from state where name = "DC" or abbr = "DC"
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:31:09.702732 trace system.db.CDbCommand
Querying SQL: select name from state where abbr = "DC" or name = "DC"
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)
23:31:09.703305 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:31:09.706089 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:31:09.706688 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 = 3616
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:31:09.707206 trace system.db.CDbCommand
Querying SQL: Select * from property_photo where id_property=3616 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:31:09.707746 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:31:09.708986 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:31:09.709367 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:31:09.709608 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:31:09.710148 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:31:09.710278 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:31:09.711198 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 = 3617
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:31:09.711843 trace system.db.CDbCommand
Querying SQL: Select * from property_photo where id_property=3617 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:31:09.712222 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:31:09.712357 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:31:09.713414 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 = 3618
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:31:09.713994 trace system.db.CDbCommand
Querying SQL: Select * from property_photo where id_property=3618 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:31:09.714355 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:31:09.714489 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:31:09.715549 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 = 3619
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:31:09.716188 trace system.db.CDbCommand
Querying SQL: Select * from property_photo where id_property=3619 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:31:09.716547 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:31:09.716696 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:31:09.717680 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 = 3620
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:31:09.718261 trace system.db.CDbCommand
Querying SQL: Select * from property_photo where id_property=3620 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:31:09.718622 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:31:09.718756 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:31:09.719773 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 = 3621
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:31:09.720386 trace system.db.CDbCommand
Querying SQL: Select * from property_photo where id_property=3621 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:31:09.720740 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:31:09.720880 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:31:09.721911 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 = 3622
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:31:09.722609 trace system.db.CDbCommand
Querying SQL: Select * from property_photo where id_property=3622 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:31:09.722969 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:31:09.723103 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:31:09.724133 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 = 3623
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:31:09.724834 trace system.db.CDbCommand
Querying SQL: Select * from property_photo where id_property=3623 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:31:09.725197 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:31:09.725338 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:31:09.726401 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 = 3624
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:31:09.727066 trace system.db.CDbCommand
Querying SQL: Select * from property_photo where id_property=3624 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:31:09.727474 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:31:09.727607 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:31:09.728672 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 = 3625
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:31:09.729350 trace system.db.CDbCommand
Querying SQL: Select * from property_photo where id_property=3625 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:31:09.729758 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:31:09.729893 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:31:09.730782 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 = 3626
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:31:09.731467 trace system.db.CDbCommand
Querying SQL: Select * from property_photo where id_property=3626 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:31:09.731878 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:31:09.732007 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:31:09.734963 trace system.db.CDbCommand
Querying SQL: select count(*) from state where name = "DC" or abbr = "DC"
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:31:09.735562 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 = "DC")  or
p.property_state = "DC") 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)
23:31:09.739156 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 = "DC")  or
p.property_state = "DC") GROUP by pid  order by ordval ASC   limit 8,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:31:09.742940 trace system.db.CDbCommand
Querying SQL: select h.*,(((acos(sin(("38.9226960000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("38.9226960000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-76.9989140000000000"-
`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:31:09.770344 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where id =299
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:31:09.770662 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where id =5331
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:31:09.770946 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where id =3025
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:31:09.771222 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where id =4981
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:31:09.771495 trace system.db.CDbCommand
Querying SQL: Select * from tbl_housingauthorityimage where id =4994
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:31:09.771994 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)