1. Home
  2. Housing Authority
  3. View Housing Authorities in
Search Housing Authority:
571 Housing Authorities Found in/near
1
Housing Authority
Save
Huntington Housing Authority
300 7th Avenue West, Huntington, WV 25701
Huntington Housing Authority is an equal opportunity agency and strive to render our services without bias or preferences. Our housing programs meet...more info
Call Now: (304) 526-4400
Section 8 Voucher
Low-Rent
914
SUBSIDIZED UNITS
Catlettsburg Housing Authority
2
Housing Authority
Save
Catlettsburg Housing Authority
210 24th Street, Catlettsburg, KY 41129
Catlettsburg 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: (606) 739-6851
Low-Rent
150
SUBSIDIZED UNITS
3
Housing Authority
Save
Ashland Housing Authority
3131 Winchester Avenue, Ashland, KY 41101
The Ashland Housing Authority is a public agency that provides subsidized housing to low and moderate income individuals and families. In addition to...more info
Call Now: (606) 325-7112
Low-Rent
373
SUBSIDIZED UNITS
4
Housing Authority
Save
Ashland CDA
1436 Greenup Ave., Ashland, KY 41101
Ashland offers the ideal location to work and relax away from the rush of the big city. Our City is an attractive community on the banks of the Ohio...more info
Call Now: (606) 327-5456
Section 8 Voucher
CALL
SUBSIDIZED UNITS
5
Housing Authority
Save
Ironton MHA
720 Washington Street, Ironton, OH 45638
The Ironton Metropolitan Housing Authority is not accepting applications for the housing choice voucher program at this time....more info
Call Now: (740) 532-8658
Section 8 Voucher
Low-Rent
260
SUBSIDIZED UNITS
Appalachian Foothills Housing Agency
6
Housing Authority
Save
Appalachian Foothills Housing Agency
1214 Riverside Boulevard, Wurtland, KY 41144
Appalachian Foothills Housing Agency 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: (606) 836-0911
Section 8 Voucher
CALL
SUBSIDIZED UNITS
7
Housing Authority
Save
Lawrence County Housing Authority
200 Gene Wilson Blvd., Louisa, KY 41230
Lawrence County was formed in 1822 and it is located in the Eastern Coal Field region of the state. Lawrence County offers you an opportunity to...more info
Call Now: (606) 638-9414
Section 8 Voucher
Low-Rent
88
SUBSIDIZED UNITS
8
Housing Authority
Save
Gallia MHA
381 Buck Ridge Road, Bidwell, OH 45614
Gallia Metropolitan Housing Authority are committed to serving the housing needs of low income families in the County of Gallia. Section 8 Housing...more info
Call Now: (740) 446-0251
Section 8 Voucher
Low-Rent
144
SUBSIDIZED UNITS
9
Housing Authority
Save
Point Pleasant Housing Authority
404 Second Street, Point Pleasant, WV 25550
Point Pleasant 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: (304) 675-4414
Section 8 Voucher
Low-Rent
137
SUBSIDIZED UNITS
10
Housing Authority
Save
St. Albans Housing Authority
650 6th Street, Saint Albans, WV 25177
City Of St Albans Housing Authority is a private company categorized under City Housing Programs. It was established in 1969 and incorporated in...more info
Call Now: (304) 727-5441
Low-Rent
90
SUBSIDIZED UNITS
11
Housing Authority
Save
Portsmouth Metropolitan Housing Authority (PMHA)
410 Court Street, Portsmouth, OH 45662
In 1938 a group of concerned citizens faced the problems of the recent destruction of housing by the 1937 flood, the large number of substandard...more info
Call Now: (740) 354-4547
Section 8 Voucher
Low-Rent
886
SUBSIDIZED UNITS
1 - 11 of 571 Results
credit_banner
gazelle

Rental Deals Nearby

Verona Senior Citizens
Verona Senior Citizens
100 Hillwood Terrace
Verona , NJ 07044
if you qualify, you may pay: Call
Zion Towers
Zion Towers
1100 Pennsylvania Avenue
Baltimore , MD 21201
if you qualify, you may pay: $1079
Berkley Village
Berkley Village
900 Daphia Circle
Newport News , VA 23601
if you qualify, you may pay: Call
Canterbury Townhouses
Canterbury Townhouses
193 Old Mayhew Road
Starkville , MS 39759
if you qualify, you may pay: Call
Water View Apartments
Water View Apartments
1200 Sycamore Estates Drive
Lawrenceburg , IN 46204
if you qualify, you may pay: $273
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:43:41.090852 trace system.CModule 
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:41.091185 trace system.CModule 
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:41.091289 trace system.CModule 
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:41.093554 trace system.CModule 
Loading "db" application component
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:41.093664 trace system.db.CDbConnection 
Opening DB connection
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:41.095149 trace system.db.CDbCommand 
Querying SQL: SHOW FULL COLUMNS FROM `settings`
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:41.097728 trace system.db.CDbCommand 
Querying SQL: SHOW CREATE TABLE `settings`
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (21)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:41.098243 trace system.db.CDbCommand 
Querying SQL: select value from settings where setting_key = "facebook_url"
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(54)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:41.098548 trace system.db.CDbCommand 
Querying SQL: select value from settings where setting_key = "twitter_url"
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(56)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:41.098818 trace system.db.CDbCommand 
Querying SQL: select value from settings where setting_key = "admin_email"
in /home/cavepear/rentalhousingdeals.com/protected/models/Settings.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(58)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:41.099071 trace system.db.CDbCommand 
Querying SQL: select image from banner where status = "Active"
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(60)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:41.100059 trace system.db.CDbCommand 
Querying SQL: select p.property_state,p.property_city
,(((acos(sin(("34.052235" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.052235" *pi()/180)) * cos((`lat`*pi()/180))
* cos((("-118.243683"- `lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as
distance from property p group by p.property_city HAVING distance <= 50
order by distance ASC
in
/home/cavepear/rentalhousingdeals.com/protected/components/Controller.php
(127)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:43:41.191343 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:43:41.192897 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:43:41.193384 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:43:41.193989 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:43:41.196270 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:43:41.197089 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:43:41.198460 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:43:41.198875 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:43:41.199363 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:43:41.199693 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:43:41.200007 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:43:41.200309 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:43:41.200462 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 '%WV%' OR concat_ws(' ' ,
replace(replace(replace(`property_city`,'"',''),'/ ',' '),'-','
'),property.property_state ) like '%WV%'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:43:41.255050 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:43:41.255570 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:43:41.255765 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:43:41.256460 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:43:41.258861 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:43:41.259454 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "WV" or abbr = "WV"
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:43:41.259866 trace system.db.CDbCommand 
Querying SQL: select id,(((acos(sin(("38.4171040000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("38.4171040000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-82.4704390000000000"-
`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:43:41.272742 trace system.db.CDbCommand 
Querying SQL: select id,(((acos(sin(("38.4171040000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("38.4171040000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-82.4704390000000000"-
`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:43:41.280863 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=3493
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:43:41.281260 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=3493 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:43:41.281728 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:43:41.281873 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:43:41.282761 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=1149
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:43:41.283153 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=1149 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:43:41.284020 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=1132
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:43:41.284456 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=1132 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:43:41.285353 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=1133
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:43:41.285787 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=1133 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:43:41.286688 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=2745
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:43:41.287070 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=2745 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:43:41.287935 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=1252
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:43:41.288319 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=1252 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:43:41.289200 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=1196
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:43:41.289550 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=1196 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:43:41.290543 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=2720
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:43:41.290972 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=2720 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:43:41.291928 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=3502
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:43:41.292349 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=3502 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:43:41.293263 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=3505
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:43:41.293683 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=3505 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:43:41.294598 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=2775
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:43:41.295016 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=2775 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:43:41.297470 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "WV" or abbr = "WV"
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:43:41.297955 trace system.db.CDbCommand 
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("38.4171040000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("38.4171040000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-82.4704390000000000"-
`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:43:41.322294 trace system.db.CDbCommand 
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("38.4171040000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("38.4171040000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-82.4704390000000000"-
`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:43:41.341072 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(('38.4171040000000000' *pi()/180)) *
sin((`lat`*pi()/180))+cos(('38.4171040000000000' *pi()/180)) *
cos((`lat`*pi()/180)) * cos((('-82.4704390000000000'-
`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:43:41.943088 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:43:41.944616 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:43:41.945060 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 34564
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:43:41.945411 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 34568
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:43:41.945754 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 34571
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:43:41.946073 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 34590
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:43:41.946409 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 34592
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:43:41.947104 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)