Chico Real Estate on MLS Chico homes on the MLS
 

Map (Click on Markers for Real Estate Details or Scroll down for table)




Amber Grove ACTIVE listings


db.class.php Error:
Unknown column 'CRMLSlisting_mrmls_resi.Matrix_Unique_ID' in 'field list'
Last SQL Query:
SELECT MLnumber, CRMLSlisting_mrmls_resi.Matrix_Unique_ID, Status,
PropertyDescription, ListPrice,
StreetNumber, StreetDirection, StreetName,
StreetSuffix, StreetSuffix, City,
State, ZIPCode,
Bedrooms, BathsHalf, BathsFull,
YearBuilt, SquareFootageStructure,
LotSquareFootage,
PoolYN, NumberGarageSpaces, Latitude,
Longitude, SaleType, PicCount,
TimestampOriginalEntry
FROM CRMLSlisting_mrmls_resi LEFT JOIN RetsExtra ON RetsExtra.Matrix_Unique_ID = CRMLSlisting_mrmls_resi.Matrix_Unique_ID WHERE (Status LIKE 'Active' or Status LIKE 'Backup Offer' or Status LIKE 'Pending Sale') and ListPrice >= '0' and ListPrice <= '9000000' and Bedrooms >= '0' and BathsFull >= '0' and ((SquareFootageStructure >= 0 and SquareFootageStructure <= 9999 )
or SquareFootageStructure IS NULL ) and LotSquareFootage >= 0 and LotSquareFootage <= 435556440 and YearBuilt >= 0 and YearBuilt <= 3000 and (DATE(TimestampOriginalEntry) BETWEEN '2012-05-02' and '2015-01-27' ) and City LIKE 'chico' and sub_ID = '1' ORDER BY ListPrice DESC LIMIT 1500
Pin # PIC Asking Address Beds Bath Year Built Sq Feet Lot Size Pool Garage

No Listings



Click here for MOST Amber Grove Floor Plans


Complete MLS Real Estate Listing


Here is a link for all of the Chico Real Estate Listings Or Paradise Real Estate or Oroville Real Estate


View Other Chico Neighborhoods


Stilson Canyon Herman Real Estate Chico
Chico Real Estate Investor Rosewood Estates
Chico Renters Mansion Park
Waterford Husa Ranch

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 Commercial Real Estate
Chico Creek Estates Chico Homes
Chico Investor Chico Neighborhoods
Chico Real Estate Investor Chico Renters
Chico Subdivisions Chico Subs
Chicos Agent Doe Mill
Eaton Village Fine Chico Homes
Foreclosures in Chico 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
Oroville Ca Homes for Sale Paradise Homes on MLS
Pebblewood Pines Red Bluff Ca Real Estate For Sale
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