Chico, Chico, Ca, real estate, Helping Chico Sell and Buy homes using the mls - Matthew Herman (809-3754):Your trusted Real Estate advisor

 

db.class.php Error:
Table 'mls.copRes' doesn't exist

Last SQL Query:
SELECT C_ListingID, C_ListingNumber, C_MarketingRemarks , C_ListingPrice,C_StreetNumber, C_StreetDirection, C_StreetName, C_StreetPostDirection, C_StreetSuffix, C_City, C_Bedrooms,
C_FullBaths, C_YearBuilt, C_ApxSqFt, C_ApxLotSize, C_PoolFlag, C_GarageParking, C_RooftopLatitude, C_RooftopLongitude
FROM `copRes` WHERE C_Status LIKE 'ACTIVE' and C_ListingPrice >= '0' and C_ListingPrice <= '9000000' and C_Bedrooms >= '0' and C_FullBaths >= '0' and ((C_ApxSqFt >= 0 and C_ApxSqFt <= 9999 ) or C_ApxSqFt IS NULL ) and ((C_ApxLotSize >= 0 and C_ApxLotSize <= 9999 ) or C_ApxLotSize IS NULL ) and C_YearBuilt >= 0 and C_YearBuilt <= 3000 and C_BankOwnedREO = '1' and C_EntryDate <= '2010-03-12' and C_EntryDate >= '2007-06-16' and ( C_City LIKE 'Chico' or C_City LIKE 'fakequery' ) ORDER BY C_ListingPrice