= 29000 AND mls.Sale_Price <= 6700000 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = '0596187' AND USERS_REMOVED_CITIES.CITY_ID = City.CITY_ID)) AND city.regionTypeID IN ('7') AND mls.MLS_ID IN (SELECT DISTINCT regionTable FROM REGION WHERE regionTypeID IN ('7')) ">= 29000 AND mls.Sale_Price <= 6700000 AND (NOT EXISTS (SELECT CITY_ID FROM USERS_REMOVED_CITIES (NOLOCK) WHERE USER_NAME = '0596187' AND USERS_REMOVED_CITIES.CITY_ID = City.CITY_ID)) AND city.regionTypeID IN ('7') AND mls.MLS_ID IN (SELECT DISTINCT regionTable FROM REGION WHERE regionTypeID IN ('7')) ORDER BY SortOrder,propertyType.PROP_TYPE_ORDER asc, SALE_PRICE Desc">
< Back
English
Español
Français
Deutsch
Italiano
Português
Island Estates
Compare all listings
Filter by
AllSalesRentalsForeclosuresShort SalesWater FrontPool Sort Price LowHigh
Properties Per Page 51015202550100
Page 1 of 1
1
4 Properties Found
Compare Listings
Export To Excel
Hide Images
$5,490,000
3907 ISLAND ESTATES DR Aventura, FL 33160
6 Beds
Map Property
5 Baths
Property Details
1 Half Baths
7289 SF.
A1605233
Single Family
$4,975,000
3901 ISLAND ESTATES DR Aventura, FL 33160
6 Beds
Map Property
8 Baths
Property Details
1 Half Baths
7000 SF.
M1462610
Single Family
$4,750,000
4028 ISLAND ESTATES DR Aventura, FL 33160
5 Beds
Map Property
6 Baths
Property Details
1 Half Baths
6215 SF.
A1603807
Single Family
$4,499,000
3916 ISLAND ESTATES DR Aventura, FL 33160
6 Beds
Map Property
7 Baths
Property Details
6836 SF.
M1492190
Single Family
Page 1 of 1
1
4 Properties Found
Compare Listings
Export To Excel
Hide Images
< Back
Icon South Beach
Luxury Condo at a great price!!!
St Martin Luxury Villa
Caribbean St Martin Luxury Villa 6 bedrooms, 6 baths.
"One of the mos beautiful panoramic views of the Island"
Today's Real Estate News and Advice
Updated: Wednesday, February 22, 2012
Incentives for Going Green...
Are you thinking green this Spring“ Not only can energy efficient windows, doors and skyl...
Ask the HOA Expert...
Our governing documents describe allowable signs as either for sale or for rent. Since no other...
Pressure Proofing Your Busines...
We are all under the gun every day in real estate sales. Most of us get up every morning unempl...
>
More Real Estate News
Copyright ©2012
Realty Times
®. All Rights Reserved