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='R' ) AND l.CITY IN ('Y22337','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%') RSS

Rentals in Naples & Marco Island with Pool



Displaying items 1-12 of 13

$3,000
Rental

3 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 2155 SqFt
Community: Andalucia
Subdivision: Andalucia
Naples, 34105

Save This Listing | More Info


$1,600
Rental

1 Full Bath(s); 0 Half Bath(s)
Size: 493 SqFt
Community: Vanderbilt Beach
Subdivision: Vanderbilt Towers
Naples, 34108

Save This Listing | More Info


$3,800
Rental

3 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 2041 SqFt
Community: Victoria Park
Subdivision: Victoria Park
Naples, 34109

Save This Listing | More Info


$2,600
Rental

3 Bedroom(s) /3 Full Bath(s); 1 Half Bath(s)
Size: 1909 SqFt
Community: Marco Island
Subdivision: Marco Island
Marco Island, 34145

Save This Listing | More Info


$3,100
Rental

3 Bedroom(s) /3 Full Bath(s); 1 Half Bath(s)
Size: 2497 SqFt
Community: Brynwood Preserve
Subdivision: Brynwood Preserve
Naples, 34105

Save This Listing | More Info


$8,900
Rental

5 Bedroom(s) /5 Full Bath(s); 0 Half Bath(s)
Size: 4100 SqFt
Community: Oyster Bay
Subdivision: Royal Harbor
Naples, 34102

Save This Listing | More Info


$3,000
Rental

3 Bedroom(s) /4 Full Bath(s); 1 Half Bath(s)
Size: 2489 SqFt
Community: Brynwood Preserve
Subdivision: Brynwood Preserve
Naples, 34105

Save This Listing | More Info


$3,200
Rental

3 Bedroom(s) /3 Full Bath(s); 0 Half Bath(s)
Size: 2244 SqFt
Community: Marbella Lakes
Subdivision: Marbella Lakes
Naples, 34105

Save This Listing | More Info


$3,200
Rental

4 Bedroom(s) /3 Full Bath(s); 0 Half Bath(s)
Size: 2869 SqFt
Community: Indigo Lakes
Subdivision: Indigo Lakes
Naples, 34119

Save This Listing | More Info


$3,000
Rental

4 Bedroom(s) /3 Full Bath(s); 1 Half Bath(s)
Size: 2719 SqFt
Community: Saturnia Lakes
Subdivision: Saturnia Lakes
Naples, 34119

Save This Listing | More Info


$2,500
Rental

4 Bedroom(s) /2 Full Bath(s); 0 Half Bath(s)
Size: 1905 SqFt
Community: Lakewood
Subdivision: Lakewood
Naples, 34112

Save This Listing | More Info


$2,975
Rental

4 Bedroom(s) /3 Full Bath(s); 0 Half Bath(s)
Size: 2140 SqFt
Community: Pinewoods
Subdivision: Pinewoods
Naples, 34105

Save This Listing | More Info


Displaying items 1-12 of 13

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