Brickell Listings

Features
: Ocean View , Canal , River
: Restrictions Or Possible Restrictions
: Unfurnished
4
2
Property Description

JUST REDUCED FOR A QUICK SALE!!! PRICED TO SALE!!! SPECTACULAR AND UNIQUE PH ON THE MIAMI RIVER WITH VIEWS OF BISCAYNE BAY, OCEAN, RIVER, CITY. SMART BUILDING TOUCH SCREEN PANELS FOR LUXURY AND CONVENIENCE. 3 BEDS/3.5 BATHS. FLOOR-TO-CEILING WINDOWS GLASS IMPACT WINDOWS/GLASS RAILING BALCONIES. JUST PAINTED ALL WHITE. EUROPEAN CABINETRY S/S APPLIANCES, CUTTING EDGE FINISHING. RICH WOOD STAIRCASE. 3 LEVELS. 3RD LEVEL IS A PRIVATE ROOFTOP W/A JACUZZI THE BEST PANORAMIC VIEWS. RIVER FRONT CLUB FEATURES A RESTAURANT, EXPANSIVE OUTDOOR SPORTS AREA, FACILITIES FOR CHILDREN, PLAYGROUND, SPA, AND HEALTH CLUB. 2 COVERED PARKING SPACES ON THE FIRST FLOOR. BRAND NEW FRIDGE & MICROWAVE. TOO GOOD TO BE TRUE. 2456sq. ft. Living area Plus more than 800 sq. ft on the 3rd. level. TOTAL 3,256 sq. ft.

Condo For Sale at THE IVY RIVERFRONT,The Ivy Riverfront

90 SW 3rd St #PH-17, Miami, Florida 33130

  • Bedrooms : 3
  • Bathrooms : 4
  • Square Footage: 2,456 Sqft
$1,899,000
Listing ID#A11489981
QR Code
Basic Details
Subdivision : 90 SW 3rd
Building Name : THE IVY RIVERFRONT,The Ivy Riverfront
Property Type : Condo
Listing Type : For Sale
Listing ID : A11489981
Price : $1,899,000
Original Price : $2,100,000
Bedrooms : 3
Bathrooms : 4
Half Bathrooms : 1
Square Footage : 2,456 Sqft
Year Built : 2008
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 2621
DOM : 147
Tax : $25,000
Search Results

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 1' at line 1]
SELECT `id` FROM `wp_wpl_properties` AS p WHERE 1 AND `listing` = '9' AND `property_type` = '36' AND ( MATCH( `textsearch` ) AGAINST ( '(+"LOC-33131") "Listing ID 33131"' IN BOOLEAN MODE ) ) AND `show_address`='1' AND `f_140`='1' AND (`f_140_options` LIKE '%,1,%' OR `f_140_options` LIKE '%,3,%' OR `f_140_options` LIKE '%,4,%' OR `f_140_options` LIKE '%,5,%' OR `f_140_options` LIKE '%,6,%' OR `f_140_options` LIKE '%,7,%' OR `f_140_options` LIKE '%,8,%' OR `f_140_options` LIKE '%,9,%' OR `f_140_options` LIKE '%,10,%') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY p.price_si DESC , p.id ASC LIMIT , 1

Agent info
Brickellmania LLC
3011 SW 24 ST. Miami Fl 33145
Contact Agent