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 ('Y22337') AND l.FEATURES LIKE '%X36F%'

Marco Island Beach Front Condos



Displaying items 1-12 of 265

$364,000
Condo\Town Home

1 Bedroom(s) /2 Full Bath(s); 1 Half Bath(s)
Size: 597 SqFt
Lot Dimensions: 0x0x0x0
Community: Marco Beach
Subdivision: Tradewinds Apts Of Marco Islan
Marco Island, 34145

Save This Listing | More Info


$485,000
Condo\Town Home

2 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1070 SqFt
Community: Marco Island
Subdivision: Marco Island
Marco Island, 34145

Save This Listing | More Info


$459,000
Condo\Town Home

2 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1075 SqFt
Lot Dimensions: 0x0x0x0
Community: South Seas Club Condo
Subdivision: South Seas Club Condo
Marco Island, 34145

Save This Listing | More Info


$930,000
Condo\Town Home

2 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1978 SqFt
Community: Cape Marco
Subdivision: Monterrey At Cape Marco
Marco Island, 34145

Save This Listing | More Info


$397,000
Condo\Town Home

2 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1000 SqFt
Community: Olde Marco
Subdivision: Ville De Marco
Marco Island, 34145

Save This Listing | More Info


$2,689,000
Condo\Town Home

4 Bedroom(s) /4 Full Bath(s); 1 Half Bath(s)
Size: 3830 SqFt
Lot Dimensions: 0x0x0x0
Community: Cape Marco
Subdivision: Veracruz
Marco Island, 34145

Save This Listing | More Info


$599,000
Condo\Town Home

2 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1148 SqFt
Community: Marco Island
Subdivision: Marco Island
Marco Island, 34145

Save This Listing | More Info


$1,095,000
Condo\Town Home

2 Bedroom(s) /3 Full Bath(s); 1 Half Bath(s)
Size: 1664 SqFt
Lot Dimensions: 0x0x0x0
Community: Duchess I Condo
Subdivision: Duchess I Condo
Marco Island, 34145

Save This Listing | More Info


$600,000
Condo\Town Home

2 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 837 SqFt
Community: Marco Beach
Subdivision: Admiralty House
Marco Island, 34145

Save This Listing | More Info


$5,950,000
Condo\Town Home

4 Bedroom(s) /4 Full Bath(s); 1 Half Bath(s)
Size: 7876 SqFt
Community: Marco Island
Subdivision: Belize At Cape Marco
Marco Island, 34145

Save This Listing | More Info


$5,950,000
Condo\Town Home

4 Bedroom(s) /5 Full Bath(s); 1 Half Bath(s)
Size: 7876 SqFt
Community: Cape Marco
Subdivision: Belize
Marco Island, 34145

Save This Listing | More Info


$1,699,000
Condo\Town Home

3 Bedroom(s) /4 Full Bath(s); 1 Half Bath(s)
Size: 3110 SqFt
Lot Dimensions: 0x0x0x0
Community: Cape Marco
Subdivision: Belize
Marco Island, 34145

Save This Listing | More Info


Displaying items 1-12 of 265

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