1. Home
  2. Housing Authority
  3. View Housing Authorities in San Dimas, CA
Search Housing Authority:
60 Housing Authorities Found in/near San Dimas, CA
45
Housing Authority
Save
Calexico Housing Authority
608 Heber Avenue, Calexico, CA 92231
Housing Division is under the Office of the City Manager. The Housing Division is responsible for implementing and managing a variety of...more info
Call Now: (760) 768-2177
Section 8 Voucher
Low-Rent
264
SUBSIDIZED UNITS
46
Housing Authority
Save
Housing Authority of the County of Tulare
5140 W. Cypress Ave., Visalia, CA 93277
The Housing Authority of the County of Tulare provides rental assistance to very low and moderate-income families, seniors and the handicapped...more info
Call Now: (559) 627-3700
Section 8 Voucher
Low-Rent
710
SUBSIDIZED UNITS
47
Housing Authority
Save
Housing Authority of Kings County
680 N. Douty Street, Hanford, CA 93230
The Housing Authority provides low income families with affordable rental housing that is decent, safe, and sanitary. The Housing Authority provides...more info
Call Now: (559) 582-2806
Section 8 Voucher
Low-Rent
268
SUBSIDIZED UNITS
48
Housing Authority
Save
Needles Housing Authority
908 Sycamore Dr., Needles, CA 92363
**WE ARE NOT ACCEPTING PRE-APPLICATIONS ONLINE. PLEASE CONTACT THE AGENCY FOR MORE INFORMATION. ** The Housing Authority of the City of Needles...more info
Call Now: (760) 326-3222
Section 8 Voucher
Low-Rent
52
SUBSIDIZED UNITS
49
Housing Authority
Save
Paso Robles Housing Authority
3201 Pine Street, Paso Robles, CA 93446
Welcome The Paso Robles Housing Authority manages 148 units of low-income public housing known as Oak Park. The Housing Authority co-sponsors an...more info
Call Now: (805) 238-4015
Low-Rent
CALL
SUBSIDIZED UNITS
50
Housing Authority
Save
Yuma County Housing Department
8450 W. Highway 95, Suite 88, Somerton, AZ 85350
The County of Yuma acting by and through the Yuma County Housing Department owns and operates low-rent housing apartments for low-income families....more info
Call Now: (928) 627-8828
Section 8 Voucher
Low-Rent
159
SUBSIDIZED UNITS
51
Housing Authority
Save
Housing Authority of the City of Yuma
420 S. Madison Ave., Yuma, AZ 85364
The City of Yuma established the Housing Authority of the City of Yuma (HACY) as an independent agency in 1976. HACY began its operation with funds...more info
Call Now: (928) 782-3823
Section 8 Voucher
Low-Rent
235
SUBSIDIZED UNITS
52
Housing Authority
Save
Southern Nevada Housing Authority
340 North 11th Street, Las Vegas, NV 89101
Our vision is that of a well-recognized, innovative leader in the continuum of housing programs. We will offer opportunities that are creative,...more info
Call Now: (702) 922-6855
Section 8 Voucher
Low-Rent
2,982
SUBSIDIZED UNITS
53
Housing Authority
Save
Fresno Housing Authority
1331 Fulton Mall, Fresno, CA 93721
Founded more than 70 years ago, Fresno Housing Authority helps approximately 16,500 low-income families (including seniors and the disabled) afford...more info
Call Now: (559) 443-8400

Section 8 Wait List
OPEN
54
Housing Authority
Save
Mohave County Housing Authority
201 N. 4th St., Kingman, AZ 86401
Mohave County Housing Authority (MCHA) was created in 1990 by Mohave County Board of Supervisors to provide various housing programs for low income...more info
Call Now: 928-753-0723
Section 8 Voucher
CALL
SUBSIDIZED UNITS
55
Housing Authority
Save
Housing Authority of the City of Madera
205 N. G Street, Madera, CA 93637
The well-being of our community matters to HACM. If we were not constrained by U.S. Department of Housing and Urban Development (HUD) rules, we...more info
Call Now: (559) 674-5695
Section 8 Voucher
Low-Rent
244
SUBSIDIZED UNITS
45 - 55 of 60 Results
credit_banner
gazelle

Rental Deals Nearby

Eagle Tail Village
Eagle Tail Village
306 S. 7th St.
Buckeye , AZ 85326
if you qualify, you may pay: 1 BR, 1 BA $820
Tuzigoot Village
Tuzigoot Village
1600 E. Skyline Dr.
Cottonwood , AZ 86326
if you qualify, you may pay: Accepting Applications
Kachina Place
Kachina Place
6238 N 63rd Ave
Glendale , AZ 85301
if you qualify, you may pay: $638
Paradise Valley Retirement Center
Paradise Valley Retirement Center
11640 N. 27th Street
Phoenix , AZ 85028
if you qualify, you may pay: Call
Memorial Towers
Memorial Towers
1405 S. 7th Ave.
Phoenix , AZ 85007
if you qualify, you may pay: $730
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:26:39.903112 trace system.CModule 
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:26:39.903582 trace system.CModule 
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:26:39.903736 trace system.CModule 
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:26:39.906657 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:26:39.906754 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:26:39.908049 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:26:39.910131 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:26:39.910619 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:26:39.911040 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:26:39.911437 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:26:39.911813 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:26:39.912637 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:26:39.997267 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:26:39.998796 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:26:39.999316 trace system.db.CDbCommand 
Querying SQL: select name from state where abbr = "CA" or name = "CA"
in /home/cavepear/rentalhousingdeals.com/protected/models/State.php (94)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2510)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:26:40.000020 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:26:40.002516 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:26:40.003195 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
(2551)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:26:40.004651 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
(2551)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:26:40.005129 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Housing authority' and state = 'CA' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = 'San Dimas' 
and individual_type = ''
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2551)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:26:40.005515 trace system.db.CDbCommand 
Querying SQL: select title,keyword,description from seo_template where 
home = 'Housing authority' and state = '' and
replace(replace(replace(`city`,'"',''),'/ ',' '),'-',' ') = 'All'  and
individual_type = ''
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoTemplate.php
(104)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2558)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:26:40.005964 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"searchha_title_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2565)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:26:40.006325 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"searchha_keyword_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2566)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:26:40.006668 trace system.db.CDbCommand 
Querying SQL: select seo_val from seo_settings where seo_key =
"searchha_description_city"
in /home/cavepear/rentalhousingdeals.com/protected/models/SeoSettings.php
(87)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2567)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:26:40.006988 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:26:40.007164 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 '%San Dimas CA%' OR concat_ws(' ' ,
replace(replace(replace(`property_city`,'"',''),'/ ',' '),'-','
'),property.property_state ) like '%San Dimas CA%'group by concat_ws(',' ,
property.property_city,property.property_state ) order by prop_count desc
limit 1
in /home/cavepear/rentalhousingdeals.com/protected/components/MyUtility.php
(31)
in
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php
(2579)
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:26:40.061842 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:26:40.062361 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:26:40.062647 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:26:40.063508 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:26:40.065699 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:26:40.066354 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "San Dimas CA" or
abbr = "San Dimas CA"
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:26:40.066819 trace system.db.CDbCommand 
Querying SQL: select id,(((acos(sin(("34.1050330000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.1050330000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-117.8146850000000000"-
`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:26:40.074549 trace system.db.CDbCommand 
Querying SQL: select id,(((acos(sin(("34.1050330000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.1050330000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-117.8146850000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority as h HAVING distance <= 300 order by distance ASC LIMIT 11
OFFSET 44
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:26:40.082087 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=342
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:26:40.082552 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=342 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:26:40.083117 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:26:40.083266 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:26:40.084237 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=441
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:26:40.084815 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=441 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:26:40.085933 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=357
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:26:40.086441 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=357 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:26:40.087492 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=376
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:26:40.087970 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=376 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:26:40.089030 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=384
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:26:40.089493 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=384 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:26:40.090550 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=324
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:26:40.091063 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=324 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:26:40.092017 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=331
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:26:40.092402 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=331 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:26:40.093151 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=2532
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:26:40.093499 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=2532 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:26:40.094157 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=353
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:26:40.094517 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=353 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:26:40.095489 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=315
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:26:40.095834 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=315 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:26:40.096510 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=367
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:26:40.096868 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=367 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:26:40.098331 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "San Dimas CA" or
abbr = "San Dimas CA"
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:26:40.098702 trace system.db.CDbCommand 
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("34.1050330000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.1050330000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-117.8146850000000000"-
`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:26:40.109502 trace system.db.CDbCommand 
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("34.1050330000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("34.1050330000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-117.8146850000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority HAVING distance <= 300 order by distance ASC limit 4,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:26:40.118624 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(('34.1050330000000000' *pi()/180)) *
sin((`lat`*pi()/180))+cos(('34.1050330000000000' *pi()/180)) *
cos((`lat`*pi()/180)) * cos((('-117.8146850000000000'-
`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:26:40.664657 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:26:40.666091 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:26:40.666548 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 810
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:26:40.666924 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 825
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:26:40.667273 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 840
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:26:40.667609 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 902
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:26:40.667942 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 904
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:26:40.668673 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)