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.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<=20000000000000 RSS

Naples Florida Pool Homes



Displaying items 1-12 of 1727

$1,849,000
Single Family

3 Bedroom(s) /5 Full Bath(s); 0 Half Bath(s)
Size: 3486 SqFt
Lot Dimensions: 0x0x0x0
Acreage: 0.19 acs.
Community: Tiburon
Subdivision: Serafina At Tiburon
Naples, 34109

Save This Listing | More Info


$2,850,000
Single Family

4 Bedroom(s) /5 Full Bath(s); 1 Half Bath(s)
Size: 3867 SqFt
Lot Dimensions: 0x0x0x0
Acreage: 0.32 acs.
Community: Moorings
Subdivision: Moorings
Naples, 34103

Save This Listing | More Info


$3,995,000
Single Family

4 Bedroom(s) /5 Full Bath(s); 1 Half Bath(s)
Size: 4306 SqFt
Lot Dimensions: 150x95x97x152
Acreage: 0.41 acs.
Community: Moorings
Subdivision: Moorings
Naples, 34102

Save This Listing | More Info


$449,900
Single Family

2 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 2026 SqFt
Lot Dimensions: 0x0x0x0
Community: Glen Eagle
Subdivision: Addison Reserve
Naples, 34104

Save This Listing | More Info


$5,499,000
Single Family

6 Bedroom(s) /10 Full Bath(s); 1 Half Bath(s)
Size: 13516 SqFt
Lot Dimensions: 170x274x175x310
Acreage: 1.17 acs.
Community: Pine Ridge
Subdivision: Pine Ridge
Naples, 34108

Save This Listing | More Info


$485,000
Single Family

2 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 2023 SqFt
Lot Dimensions: 50x120x50x120
Acreage: 0.14 acs.
Community: Kensington
Subdivision: Sheffield Villas
Naples, 34105

Save This Listing | More Info


$1,399,000
Single Family

3 Bedroom(s) /4 Full Bath(s); 0 Half Bath(s)
Size: 4075 SqFt
Lot Dimensions: 0x0x0x0
Community: Twin Eagles
Subdivision: Hedgestone
Naples, 34120

Save This Listing | More Info


$469,000
Single Family

3 Bedroom(s) /3 Full Bath(s); 1 Half Bath(s)
Size: 2000 SqFt
Lot Dimensions: 0x0x0x0
Community: Verona Walk
Subdivision: Verona Walk
Naples, 34114

Save This Listing | More Info


$469,900
Single Family

3 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 2482 SqFt
Lot Dimensions: 84x130x84x130
Acreage: 0.25 acs.
Community: Willoughby Acres
Subdivision: Willow West
Naples, 34110

Save This Listing | More Info


$449,900
Single Family

3 Bedroom(s) /3 Full Bath(s); 1 Half Bath(s)
Size: 1983 SqFt
Lot Dimensions: 133x47x48x129
Acreage: 0.16 acs.
Community: Verona Walk
Subdivision: Verona Walk
Naples, 34114

Save This Listing | More Info


$749,900
Single Family

3 Bedroom(s) /4 Full Bath(s); 1 Half Bath(s)
Size: 3039 SqFt
Lot Dimensions: 80x130x88x130
Acreage: 0.24 acs.
Community: Cedar Hammock
Subdivision: Cedar Hammock
Naples, 34112

Save This Listing | More Info


$505,000
Single Family

3 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 2244 SqFt
Lot Dimensions: 130x90x90x130
Acreage: 0.27 acs.
Community: Lely Resort
Subdivision: Lely Island Estates
Naples, 34113

Save This Listing | More Info


Displaying items 1-12 of 1727

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