SELECT l.MLS_NUM,l.LIST_PRICE,l.PROP_TYPE,l.BEDROOMS,l.BATHS,l.BATHS_HALF,l.UNITS,l.IM_SQFT,l.LOT_SQFT,l.LOT_DIM,l.ACREAGE,l.STR_NUM,l.STREET_DIR,l.STR_NAME,l.STR_TYPE,l.CITY,l.ZIP, l.FEATURES,l.PHOTO_QUANTITY,l.PHOTO_URL,LCASE(l.COMMUNITY_NAME) AS commname,LCASE(l.SUBDIVISION) AS subdiv,IF(l.FEATURES LIKE '%H21%',0,1) AS shortsale,IF(l.FEATURES LIKE '%H20%',0,1) AS foreclosure,IF(i.MLS_NUM!='',0,1) AS newlist,l.firmID,IF(l.firmID IN ('NPPR','NPPR3','FPRP','PREP','359'), 0, 1) AS `firm_listing`,g.latitude AS LATITUDE,g.longitude AS LONGITUDE FROM listings l LEFT JOIN listings_inc i USING(MLS_NUM) LEFT JOIN geocodes g USING(MLS_NUM) WHERE l.PROP_TYPE='S' AND l.CITY IN ('Y22467') AND l.LIST_PRICE>=200000 AND l.LIST_PRICE<=400000

Map Search

Property Type
Select City
Bedroom(s)
Price Range
687 matching properties
Previous Next Previous Next
Loading