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 ('Y21486','Y21536','Y21540','Y21805','Y21812','Y21886','Y21888','Y22337','Y22467','Y22853') AND l.FEATURES LIKE '%X37F%' AND l.MLS_AREA IN ('NA06') RSS

Gulf View Homes



$11,750,000
Single Family

6 Bedroom(s) /6 Full Bath(s); 1 Half Bath(s)
Size: 6515 SqFt
Lot Dimensions: 108x200x108x200
Acreage: 0.50 acs.
Community: Olde Naples
Subdivision: Olde Naples
Naples, 34102

Save This Listing | More Info


$2,250,000
Single Family

3 Bedroom(s) /3 Full Bath(s); 0 Half Bath(s)
Size: 3007 SqFt
Lot Dimensions: 0x0x0x0
Community: Olde Naples
Subdivision: La Galleria
Naples, 34102

Save This Listing | More Info


$8,900,000
Single Family

5 Bedroom(s) /7 Full Bath(s); 2 Half Bath(s)
Size: 6377 SqFt
Lot Dimensions: 95x150x95x150
Acreage: 0.33 acs.
Community: Olde Naples
Subdivision: Olde Naples
Naples, 34102

Save This Listing | More Info


$8,300,000
Single Family

4 Bedroom(s) /6 Full Bath(s); 2 Half Bath(s)
Size: 7318 SqFt
Lot Dimensions: 120x150x120x150
Acreage: 0.41 acs.
Community: Olde Naples
Subdivision: Olde Naples
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