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='M' ) AND l.CITY IN ('Y22467') AND l.FEATURES LIKE '%X37F%' AND (l.COMMUNITY_NAME LIKE '%Aqualane Shores%' OR l.COMMUNITY_NAME LIKE '%Moorings%' OR l.COMMUNITY_NAME LIKE '%Old Naples%' OR l.COMMUNITY_NAME LIKE '%Pelican Bay%') AND l.LIST_PRICE>=0 AND l.LIST_PRICE<=500000

Naples Beach Condos Under $500,000



$445,000
Condo\Town Home

2 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1200 SqFt
Lot Dimensions: 0x0x0x0
Community: Moorings
Subdivision: Spindrift Club
Naples, 34103

Save This Listing | More Info


$500,000
Condo\Town Home

2 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1420 SqFt
Lot Dimensions: 0x0x0x0
Community: Moorings
Subdivision: La Villa Riviera
Naples, 34102

Save This Listing | More Info



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