1. Home
  2. Housing Authority
  3. View Housing Authorities in Bell, CA
Search Housing Authority:
62 Housing Authorities Found in/near Bell, CA
12
Housing Authority
Save
Hollister Housing Authority
365 4th Street, Hollister, CA 95023
The Housing Authority of the County of Santa Cruz was created in 1969 to provide housing assistance for the county's low and moderate-income...more info
Call Now: (831) 637-0487
Section 8 Voucher
CALL
SUBSIDIZED UNITS
13
Housing Authority
Save
San Juan Bautista Housing Authority
365 4th Street, Hollister, CA 95023
The Housing Authority of the County of Santa Cruz was created in 1969 to provide housing assistance for the county's low and moderate-income...more info
Call Now: (831) 637-0487
Section 8 Voucher
CALL
SUBSIDIZED UNITS
14
Housing Authority
Save
Housing Authority of the County of Monterey
123 Rico Street, Salinas, CA 93907
The Housing Authority of the County of Monterey (HACM) is a public agency that provides rental assistance and develops and manages affordable housing...more info
Call Now: (831) 775-5000

Section 8 Wait List
OPEN
15
Housing Authority
Save
Berkeley Housing Authority
1936 University Ave., Ste. 105, Berkeley, CA 94703
******THE SECTION 8 WAIT LIST IS CLOSED******* The Berkeley Housing Authority is not accepting applications at this time. The Berkeley Housing...more info
Call Now: (510) 981-5470
Section 8 Voucher
CALL
SUBSIDIZED UNITS
16
Housing Authority
Save
Richmond Housing Authority
330 24th Street, Richmond, CA 94804
The Richmond Housing Authority, is a public entity chartered by the City of Richmond, California in 1941 as a separate legal entity under the...more info
Call Now: (510) 621-1300
Section 8 Voucher
Low-Rent
715
SUBSIDIZED UNITS
17
Housing Authority
Save
Housing Authority of the County of Contra Costa
3133 Estudillo Street, Martinez, CA 94553
The Housing Authority of the County of Contra Costa provides rental subsidies and manages and develops affordable housing for low income families,...more info
Call Now: (925) 957-8000
Section 8 Voucher
Low-Rent
1,179
SUBSIDIZED UNITS
18
Housing Authority
Save
The Housing Authority of the City of Pittsburg
916 Cumberland Street, Pittsburg, CA 94565
The Housing Authority of the City of Pittsburg 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: (925) 252-4830
Section 8 Voucher
CALL
SUBSIDIZED UNITS
19
Housing Authority
Save
Mariposa County Housing Authority
1701 Robertson Rd, Modesto, CA 95351
The Housing Choice Voucher Program (HCV Program), formerly known as the "Section 8 Program" is now being administered by the Housing Authority of the...more info
Call Now: (209) 557-2000
Section 8 Voucher
CALL
SUBSIDIZED UNITS
20
Housing Authority
Save
Housing Authority of the County of Stanislaus
1701 Robertson Rd, Modesto, CA 95351
Housing Authority of the County of Stanislaus 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: (209) 557-2000
Section 8 Voucher
Low-Rent
647
SUBSIDIZED UNITS
21
Housing Authority
Save
Housing Authority of the County of San Joaquin
448 S Center Street, Stockton, CA 95203
Since 1942, the Housing Authority of the County of San Joaquin has been continually serving the residents of San Joaquin County. The Authority was...more info
Call Now: (209) 460-5000

Section 8 Wait List
OPEN
22
Housing Authority
Save
Vallejo Housing Authority
200 Georgia St., Vallejo, CA 94590
The Housing and Community Development division operates the Housing Choice Voucher program, which provides rental subsidy to low income families and...more info
Call Now: (707) 648-4507
Section 8 Voucher
CALL
SUBSIDIZED UNITS
12 - 22 of 62 Results
credit_banner
gazelle

Rental Deals Nearby

Burke Manor
Burke Manor
15 N 3rd St.
Alhambra , CA 91801
if you qualify, you may pay: Waiting List Closed
Miracle Terrace
Miracle Terrace
225 S. Western Ave.
Anaheim , CA 92804
if you qualify, you may pay: $1,345
Alexander Center
Alexander Center
901 Gail Ave
Arbuckle , CA 95912
if you qualify, you may pay: Accepting Applications
Telacu Senior Court
Telacu Senior Court
14442 Pacific Avenue
Baldwin Park , CA 91706
if you qualify, you may pay: Call
Beaumont Terrace Co-op Senior Apartments
Beaumont Terrace Co-op Senior Apartments
752 Pennsylvania Avenue
Beaumont , CA 92223
if you qualify, you may pay: Call
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:29:37.607702 trace system.CModule 
Loading "log" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:29:37.608010 trace system.CModule 
Loading "request" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:29:37.608115 trace system.CModule 
Loading "urlManager" application component
in /home/cavepear/rentalhousingdeals.com/index.php (16)
23:29:37.610409 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:29:37.610482 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:29:37.611478 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:29:37.612703 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:29:37.612974 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:29:37.613260 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:29:37.613527 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:29:37.613785 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:29:37.614300 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:29:37.695622 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:29:37.696837 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:29:37.697222 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:29:37.697715 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:29:37.699595 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:29:37.700081 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:29:37.701252 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:29:37.701612 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`,'"',''),'/ ',' '),'-',' ') = 'Bell'  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:29:37.701966 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:29:37.702347 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:29:37.702677 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:29:37.703001 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:29:37.703315 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:29:37.703406 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 '%Bell CA%' OR concat_ws(' ' ,
replace(replace(replace(`property_city`,'"',''),'/ ',' '),'-','
'),property.property_state ) like '%Bell 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:29:37.756844 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:29:37.757121 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:29:37.757266 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:29:37.757782 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:29:37.759515 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:29:37.759924 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "Bell CA" or abbr =
"Bell 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:29:37.760257 trace system.db.CDbCommand 
Querying SQL: select id,(((acos(sin(("37.2805483000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("37.2805483000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-121.9543015000000000"-
`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:29:37.767779 trace system.db.CDbCommand 
Querying SQL: select id,(((acos(sin(("37.2805483000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("37.2805483000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-121.9543015000000000"-
`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 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:29:37.774924 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=417
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:29:37.775247 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=417 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:29:37.775635 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:29:37.775713 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:29:37.776227 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=418
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:29:37.776541 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=418 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:29:37.777216 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=404
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:29:37.777520 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=404 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:29:37.778373 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=339
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:29:37.778707 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=339 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:29:37.779335 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=396
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:29:37.779642 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=396 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:29:37.780284 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=369
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:29:37.780591 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=369 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:29:37.781243 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=386
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:29:37.781550 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=386 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:29:37.782160 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=368
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:29:37.782465 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=368 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:29:37.783088 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=372
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:29:37.783392 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=372 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:29:37.784008 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=431
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:29:37.784308 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=431 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:29:37.784966 trace system.db.CDbCommand 
Querying SQL: Select * from housingauthority where id=439
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:29:37.785270 trace system.db.CDbCommand 
Querying SQL: Select * from tbl_housingauthorityimage where
housingauthority_id=439 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:29:37.786570 trace system.db.CDbCommand 
Querying SQL: select count(*) from state where name = "Bell CA" or abbr =
"Bell 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:29:37.786899 trace system.db.CDbCommand 
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("37.2805483000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("37.2805483000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-121.9543015000000000"-
`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:29:37.795101 trace system.db.CDbCommand 
Querying SQL: select id, name, address,city,state,zip, lat, lng,
(((acos(sin(("37.2805483000000000" *pi()/180)) *
sin((`lat`*pi()/180))+cos(("37.2805483000000000" *pi()/180)) *
cos((`lat`*pi()/180)) * cos((("-121.9543015000000000"-
`lng`)*pi()/180))))*180/pi())*60*1.1515)*1 as distance from
housingauthority HAVING distance <= 300 order by distance ASC limit 1,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:29:37.803060 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(('37.2805483000000000' *pi()/180)) *
sin((`lat`*pi()/180))+cos(('37.2805483000000000' *pi()/180)) *
cos((`lat`*pi()/180)) * cos((('-121.9543015000000000'-
`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:29:38.304485 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:29:38.305800 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:29:38.306169 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 986
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:29:38.306493 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 995
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:29:38.306793 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 1003
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:29:38.307089 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 1043
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:29:38.307378 trace system.db.CDbCommand 
Querying SQL: select header_description,header_value from property_deals
where id_property = 1047
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:29:38.307895 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)