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 ('Y21540','Y22853') AND l.LIST_PRICE>=0 AND l.LIST_PRICE<=1000000 RSS

Captiva & Sanibel Homes Under $1M



1 2 3 4 5 6 7 8 9 10 next > |>>>
Displaying items 1-12 of 120

$490,000
Single Family

3 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1571 SqFt
Lot Dimensions: 75x115x75x115
Acreage: 0.20 acs.
Community: North Captiva Sands
Subdivision: North Captiva Sands
Captiva, 33924

Save This Listing | More Info


$580,000
Single Family

3 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1756 SqFt
Lot Dimensions: 0x0x0x0
Acreage: 0.07 acs.
Community: Useppa Island
Subdivision: Useppa Island
Captiva, 33924

Save This Listing | More Info


$892,000
Single Family

3 Bedroom(s) /3 Full Bath(s); 0 Half Bath(s)
Size: 2045 SqFt
Lot Dimensions: 75x140x75x140
Acreage: 0.25 acs.
Community: Safety Harbor Club
Subdivision: Village
Captiva, 33924

Save This Listing | More Info


$529,000
Single Family

3 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1430 SqFt
Lot Dimensions: 80x126x80x126
Acreage: 0.18 acs.
Community: Safety Harbor Club
Subdivision: Village
Captiva, 33924

Save This Listing | More Info


$575,000
Single Family

3 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1542 SqFt
Lot Dimensions: 29x88x35x82
Acreage: 0.06 acs.
Community: Useppa Island
Subdivision: Useppa Island
Captiva, 33924

Save This Listing | More Info


$599,000
Single Family

3 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1666 SqFt
Lot Dimensions: 0x0x0x0
Acreage: 0.32 acs.
Community: Sanibel Bayous
Subdivision: Sanibel Bayous
Sanibel, 33957

Save This Listing | More Info


$695,000
Single Family

3 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1627 SqFt
Lot Dimensions: 43x80x47x108
Acreage: 0.09 acs.
Community: Cottage Sites Of Useppa
Subdivision: Cottage Sites Of Useppa
Captiva, 33924

Save This Listing | More Info


$795,000
Single Family

3 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 2652 SqFt
Lot Dimensions: 115x117x103x150
Acreage: 0.23 acs.
Community: Useppa Island
Subdivision: Useppa Island
Captiva, 33924

Save This Listing | More Info


$625,000
Single Family

3 Bedroom(s) /3 Full Bath(s); 0 Half Bath(s)
Size: 1796 SqFt
Lot Dimensions: 30x83x29x84
Acreage: 0.05 acs.
Community: Useppa Island
Subdivision: Cottage Sites
Captiva, 33924

Save This Listing | More Info


$999,000
Single Family

3 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1752 SqFt
Lot Dimensions: 140x239x140x239
Acreage: 0.53 acs.
Community: Chateaux Sur Mer Unrec
Subdivision: Chateaux Sur Mer Unrec
Sanibel, 33957

Save This Listing | More Info


$569,000
Single Family

2 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 982 SqFt
Lot Dimensions: 100x125x100x125
Acreage: 0.26 acs.
Community: Sanibel Estates
Subdivision: Sanibel Estates
Sanibel, 33957

Save This Listing | More Info


$924,900
Single Family

3 Bedroom(s) /3 Full Bath(s); 0 Half Bath(s)
Size: 2700 SqFt
Lot Dimensions: 93x149x93x161
Acreage: 0.32 acs.
Community: Caloosa Shores
Subdivision: Caloosa Shores
Sanibel, 33957

Save This Listing | More Info


1 2 3 4 5 6 7 8 9 10 next > |>>>
Displaying items 1-12 of 120

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