Chico Real Estate on MLS Chico homes on the MLS
 

Waterford ACTIVE listings


db.class.php Error:
Table 'mls.res' doesn't exist
Last SQL Query:
SELECT C_L_ListingID, C_L_Remarks, C_L_AskingPrice, C_L_Address, C_L_City, C_L_Keyword1,
C_L_Keyword2, C_LM_Int4_1, C_LM_Int4_2, C_LM_Dec_2, C_L_Keyword8, C_L_Keyword5,
C_LMD_MP_Latitude, C_LMD_MP_Longitude
FROM `res` WHERE C_L_Status = 'ACTIVE' and C_L_AskingPrice >= '0' and C_L_AskingPrice <= '9000000' and C_L_Keyword1 >= '0' and C_L_Keyword2 >= '0' and ((C_LM_Int4_2 >= 0 and C_LM_Int4_2 <= 9999 ) or C_LM_Int4_2 IS NULL ) and ((C_LM_Dec_2 >= 0 and C_LM_Dec_2 <= 9999 ) or C_LM_Dec_2 IS NULL ) and C_LM_Int4_1 >= 0 and C_LM_Int4_1 <= 3000 and C_L_InputDate <= '2010-07-30' and C_L_InputDate >= '2007-11-03' and ( C_L_Area LIKE '1A%' or C_L_Area LIKE '1B%' or C_L_Area LIKE '1C%' or C_L_Area LIKE '1D%' or C_L_Area LIKE '1E%' or C_L_Area LIKE '1F%' or C_L_Area LIKE '1G%' or C_L_Area LIKE '1H%' or C_L_Area LIKE '1I%' or C_L_Area LIKE '1J%' or C_L_Area LIKE '1K%' or C_L_Area LIKE '1L%' or C_L_Area LIKE 'fakequery' ) and sub_ID = '38' ORDER BY C_L_AskingPrice

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/subs/recentsales.php on line 47
Pin # PIC Asking Address Beds Bath Year Built Sq Feet Lot Size Pool Garage

No Listings

► Waterford RECENT Sales


db.class.php Error:
Table 'mls.res' doesn't exist
Last SQL Query:
SELECT C_L_ListingID, C_L_Remarks, C_L_AskingPrice, C_L_Address, C_L_City, C_L_Keyword1,
C_L_Keyword2, C_LM_Int4_1, C_LM_Int4_2, C_LM_Dec_2, C_L_Keyword8, C_L_Keyword5,
C_LMD_MP_Latitude, C_LMD_MP_Longitude, C_L_ClosingDate
FROM `res` WHERE sub_ID = '38' and C_L_ClosingDate <= '2010-07-30' ORDER BY C_L_ClosingDate desc

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/subs/recentsales.php on line 106
Price Address Beds Bath Sale Date Sq Feet Lot Size Pool Year Built

No Listings


Last Updated 12/31/1969. Sold information from Butte County Assessor database. Sold prices may not necessarily reflect actual sale price. Active listings from Sierra North Valley MLS. Information is deemed reliable but not guarantee.



 
 

Amanacita Commons Amber Grove
Aspen Glen Autumn Parks
Big Chico Creek Cal Park
California Park Canyon Oaks
Chico Ca Homes For Sale Chico Creek Estates
Chico Homes on MLS Chico Investor
Chico Neighborhoods Chico Real Estate
Chico Real Estate Investor Chico Renters
Chico Subdivisions Chico Subs
Chicos Agent Doe Mill
Durham Real Estate Eaton Village
Fine Chico Homes Foreclosures in Chico
Forest Ranch Real Estate Hancock Park
Heritage Oaks Herman Real Estate Chico
Hillview Terrace Holly Brook
Husa Ranch Hyde Park
Little Chico Creek Mansion Park
Matthew Herman Matthew Herman.net
Mission Ranch Mountain Vista
Nob Hill Northwood Commons
Orland Real Estate Oroville Area Real Estate
Oroville Ca Homes for Sale Paradise Area Real Estate
Paradise Homes on MLS Pebblewood Pines
Rosewood Estates Sierra Sunrise
Sorrento Springfield
Stilson Canyon Stratford Estates
Sycamore Glen The Avenues
The Streets Victorian Park
Waterford Westside Green
Willoughby Glen Windmill Falls
Woodcrest Woodoak Condos