= 875 AND mls.Sale_Price <= 4500000 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')) ">= 875 AND mls.Sale_Price <= 4500000 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
Sunrise Harbour
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
$2,995,000
6920 SUNRISE DR Coral Gables, FL 33133
6 Beds
Map Property
5 Baths
Property Details
6138 SF.
A1542601
Single Family
$2,299,000
6819 SUNRISE PL Coral Gables, FL 33133
6 Beds
Map Property
5 Baths
Property Details
5314 SF.
D1372618
Single Family
$475,000
34 SUNRISE AV Coral Gables, FL 33133
2 Beds
Map Property
1 Baths
Property Details
1967 SF.
M1511936
Single Family
$1,800
125 EDGEWATER DRIVE #7 Coral Gables, FL 33133
2 Beds
Map Property
2 Baths
Property Details
N/A SF.
A1602096
Rental
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: Thursday, February 23, 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