1. Home
  2. Housing Authority
  3. View Housing Authorities in
Search Housing Authority:
570 Housing Authorities Found in/near
Dayton Housing Authority
1
Housing Authority
Save
Dayton Housing Authority
201 Clay Street, Dayton, KY 41074
Dayton Housing Authority is a public housing agency that helps provide decent and safe rental housing for eligible low-income families, the elderly, and persons with disabilities.
Call Now: (859) 491-7749
Low-Rent
45
SUBSIDIZED UNITS
2
Housing Authority
Save
Cincinnati Metropolitan Housing Authority (CMHA)
16 W Central Parkway, Cincinnati, OH 45202
Cincinnati Metropolitan Housing Authority (CMHA) was established in December of 1933 under the provisions of the Ohio Housing Authority Law. CMHA...more info
Call Now: (513) 721-4580

Section 8 Wait List
OPEN
3
Housing Authority
Save
Newport Housing Authority
30 E 8th Street, Newport, KY 41072
We are Neighborhood Foundations, and while you may have known us as The Housing Authority of Newport, we are much more than that. We remain committed...more info
Call Now: (859) 581-2533
Section 8 Voucher
Low-Rent
482
SUBSIDIZED UNITS
4
Housing Authority
Save
Campbell County Housing Authority
1098 Monmouth Street, Newport, KY 41071
The Section 8 Voucher Program was established by the Federal Government. Locally, it is administered by the Campbell County Department of Housing...more info
Call Now: (859) 261-5200
Section 8 Voucher
CALL
SUBSIDIZED UNITS
5
Housing Authority
Save
City of Covington Housing Authority
638 Madison Ave., 5th Floor, Covington, KY 41011
The Mayor appoints board members who are approved by the City Commission, for 4-year terms (KSR 80.030). Each person shall be at least 25 years of...more info
Call Now: (859) 292-2188
Section 8 Voucher
CALL
SUBSIDIZED UNITS
Covington Housing Authority
6
Housing Authority
Save
Covington Housing Authority
2300 Madison Avenue, Covington, KY 41014
Apartments operated by the Housing Authority of Covington are considered “conventional public housing units” The Housing Authority of...more info
Call Now: (859) 491-5311
Low-Rent
958
SUBSIDIZED UNITS
7
Housing Authority
Save
Boone County Assisted Housing Department
2950 Washington St., 3rd Fl. , Burlington, KY 41005
The Boone County Assisted Housing Department administers the local Section 8 Rental Assistance Program. This program is designed to help low income...more info
Call Now: (859) 334-2105
Section 8 Voucher
CALL
SUBSIDIZED UNITS
8
Housing Authority
Save
Clermont Metropolitan Housing Authority
65 S. Market Street, Batavia, OH 45103
Established in 1967, the Authority seeks to assist low-income families, including those who are elderly, disabled, or handicapped, with safe, decent,...more info
Call Now: (513) 732-6010
Section 8 Voucher
Low-Rent
219
SUBSIDIZED UNITS
9
Housing Authority
Save
Butler Metropolitan Housing Authority (BMHA)
4110 Hamilton Middletown Road, Hamilton, OH 45011
** WE ARE NOT ACCEPTING PRE-APPLICATIONS ONLINE. PLEASE CONTACT THE AGENCY FOR MORE INFORMATION. ** The Butler Metropolitan Housing Authority...more info
Call Now: (513) 896-4411
Section 8 Voucher
Low-Rent
1,174
SUBSIDIZED UNITS
Greendale Housing Authority
10
Housing Authority
Save
Greendale Housing Authority
489 Ludlow Street, Greendale, IN 47025
Greendale Housing Authority is a public housing agency that helps provide decent and safe rental housing for eligible low-income families, the elderly, and persons with disabilities.
Call Now: (812) 537-0164
Low-Rent
50
SUBSIDIZED UNITS
Middletown Public Housing Agency (MPHA)
11
Housing Authority
Save
Middletown Public Housing Agency (MPHA)
835 Elliott Drive, Middletown, OH 45044
Middletown Public Housing Agency (MPHA) promotes self-fufficiency through offering participation in the Family Self-Sufficiency Program. We continue...more info
Call Now: (513) 217-5801
Section 8 Voucher
CALL
SUBSIDIZED UNITS
1 - 11 of 570 Results
credit_banner
gazelle

Rental Deals Nearby

Westview Terrace
Westview Terrace
167 Howlett Street
Hillsville , VA 24343
if you qualify, you may pay: $716
Harbour Square
Harbour Square
7102 New Hunter Road
Mechanicsville , VA 23111
if you qualify, you may pay: Call
Rockwood Village
Rockwood Village
3901 Price Club Boulevard
Midlothian , VA 23112
if you qualify, you may pay: $600
Monarch Woods
Monarch Woods
6501 Jahnke Rd.
Richmond , VA 23225
if you qualify, you may pay: $606
Randolph Place
Randolph Place
300 S. Randolph St.
Richmond , VA 23220
if you qualify, you may pay: $1,000
More Nearby Rental Deals >>

DISCOVER
COMPANY
JOIN US ON
  • Twitter
  • Facebook
  • YouTube

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

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

Copyright © 2024 RentalHousingDeals.com, All Rights Reserved  Equal Housing Opportunity    
Application Log
Timestamp Level Category Message
23:31:43.060806 trace system.CModule 
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.061108 trace system.CModule 
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.061214 trace system.CModule 
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.063354 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:43.063450 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:43.064928 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:43.067334 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:43.067821 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:43.068305 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:43.068756 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:43.069185 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:43.069986 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:43.167895 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
(2510)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.169755 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
(2510)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.170382 trace system.db.CDbCommand 
Querying SQL: select name from state where abbr = "" or name = ""
in /home/cavepear/rentalhousingdeals.com/protected/models/State.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2510)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.171195 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `housingauthority`
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2521)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.174302 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `housingauthority`
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2521)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.175139 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
(2529)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.176985 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
(2529)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.177488 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Housing authority' and state = '' 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
(2529)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.178059 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"searchha_title_state"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2535)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.178457 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"searchha_keyword_state"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2536)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.178837 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"searchha_description_state"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2537)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.179200 trace system.CModule 
Loading "myUtility" application component
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2579)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.179353 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 '%OH%' OR concat_ws(' ' ,
replace(replace(replace(`property_city`,'"',''),'/ ',' '),'-','
'),property.property_state ) like '%OH%'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
(2579)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.286648 trace system.CModule 
Loading "clientScript" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(2)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.287426 trace system.CModule 
Loading "widgetFactory" application component
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(74)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:31:43.287873 trace system.CModule 
Loading "assetManager" application component
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/typeahead/TbTypeAhead.php
(179)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/typeahead/TbTypeAhead.php
(155)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(74)
23:31:43.289599 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `property`
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php (45)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(35)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
23:31:43.292449 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `property`
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php (45)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(35)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
23:31:43.293078 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "OH" or abbr = "OH"
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php
(550)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(35)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
23:31:43.293492 trace system.db.CDbCommand 
Querying SQL: select id,(((acos(sin(("39.1248518000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("39.1248518000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-84.4880235000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority as h HAVING distance <= 300 order by distance ASC
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(52)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.303900 trace system.db.CDbCommand 
Querying SQL: select id,(((acos(sin(("39.1248518000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("39.1248518000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-84.4880235000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority as h HAVING distance <= 300 order by distance ASC LIMIT 11
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(105)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.311830 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=1160
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.312184 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=1160 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.312558 trace system.CModule 
Loading "user" application component
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/views/_view.php
(44)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(145)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
23:31:43.312635 trace system.CModule 
Loading "session" application component
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/views/_view.php
(44)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(145)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
23:31:43.313157 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=2728
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.313508 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=2728 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.314378 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=1213
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.314727 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=1213 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.315376 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=1212
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.315726 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=1212 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.316333 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=1154
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.316674 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=1154 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.317382 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=1153
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.317740 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=1153 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.318475 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=1145
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.318834 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=1145 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.319677 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=2718
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.320035 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=2718 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.320791 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=2744
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.321136 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=2744 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.321873 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=982
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.322235 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=982 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.322920 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=2763
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(140)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.323312 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=2763 order by sort ASC limit 1
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchharesultlist/SearchHAResultList.php
(141)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(116)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.325088 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "OH" or abbr = "OH"
in /home/cavepear/rentalhousingdeals.com/protected/models/Property.php
(550)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchhagmap/searchhagmap.php
(27)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(182)
23:31:43.325481 trace system.db.CDbCommand 
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("39.1248518000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("39.1248518000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-84.4880235000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority HAVING distance <= 300 order by distance ASC
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchhagmap/searchhagmap.php
(43)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(182)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.341325 trace system.db.CDbCommand 
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("39.1248518000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("39.1248518000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-84.4880235000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority HAVING distance <= 300 order by distance ASC limit 0,10
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/searchhagmap/searchhagmap.php
(62)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(182)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.350229 trace system.db.CDbCommand 
Querying SQL: select p.id_property,p.property_title, p.property_address
,p.property_city,p.property_state,p.property_type ,
p.property_zip,pd.header_description,pd.header_value,pp.photo,
        (((acos(sin(('39.1248518000000000' *pi()/180)) *
sin((`lat`*pi()/180))+cos(('39.1248518000000000' *pi()/180)) *
cos((`lat`*pi()/180)) * cos((('-84.4880235000000000'-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from property p 
        left join property_photo pp on p.id_property = pp.id_property and
pp.status = 'Active'
        left join property_deals pd on pd.id_property = p.id_property
        where p.status = 'Approved' 
        group by p.id_property HAVING distance <= 500 order by
p.property_type DESC limit 5
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(28)
in
/home/cavepear/rentalhousingdeals.com/protected/views/propertysearch/searchHA.php
(270)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2621)
23:31:43.892718 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `property_deals`
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(27)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:31:43.894268 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `property_deals`
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(27)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:31:43.894835 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 21265
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(105)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:31:43.895224 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 21312
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(105)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:31:43.895584 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 21314
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(105)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:31:43.895920 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 21440
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(105)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:31:43.896255 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 21446
in /home/cavepear/rentalhousingdeals.com/protected/models/PropertyDeals.php
(105)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/views/_view.php
(34)
in
/home/cavepear/rentalhousingdeals.com/protected/extensions/propertynearby/propertynearby.php
(30)
23:31:43.897008 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
(2621)
in /home/cavepear/rentalhousingdeals.com/index.php (16)