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,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 FROM listings l LEFT JOIN listings_inc i USING(MLS_NUM) WHERE ( l.PROP_TYPE='S' ) AND l.CITY IN ('Y22467') AND l.YEAR_BUILT>=2000 AND l.YEAR_BUILT<=2011 AND ( l.FEATURES LIKE '%U01%' OR l.FEATURES LIKE '%U02%' OR l.FEATURES LIKE '%U03%' OR l.FEATURES LIKE '%U04%' OR l.FEATURES LIKE '%U05%' OR l.FEATURES LIKE '%U06%' OR l.FEATURES LIKE '%U07%' OR l.FEATURES LIKE '%U08%' OR l.FEATURES LIKE '%U09%' OR l.FEATURES LIKE '%U10%' OR l.FEATURES LIKE '%U11%' OR l.FEATURES LIKE '%U12%') AND l.LIST_PRICE>=0 AND l.LIST_PRICE<=250000

Newer Naples Pool Homes Under $250,000



No data found.


Top^

Quick Search

Search by MLS number



Advanced search

Quick Contact




 

Sign Up for FREE!
  • Property Alerts via Email
  • Save Property Searches
  • Save Your Favorite Listings



    Already Registered? Sign In