Brickell Listings

Features
: Bay
: Restrictions Or Possible Restrictions
: Unfurnished
1
1
Property Description

EXPERIENCE BAY HOUSE IN EDGEWATER’S BEAUTIFUL CONDO. GREAT FLOOR PLAN, WHITE PORCELAIN FLOORS, ALL STAINLESS STEEL APPLIANCES WITH W/D IN UNIT, IMPACT RESISTANT FLOOR-TO-CEILING WINDOWS WITH UNOBSTRUCTED FABULOUS BAY VIEWS SURROUNDED BY AMAZING SCENERY. BUILDING AMENITIES INCLUDE INFINITY POOL, JACUZZI, BUSINESS CENTER, FITNESS CENTER, GAME ROOM, CONFERENCE ROOM, 24 HOUR SECURITY, AND MORE.

Condo Sold at BAY HOUSE CONDO

600 NE 27 ST. #1604, Miami, Florida 33137

  • Bedrooms : 3
  • Bathrooms : 3
  • Square Footage: 1,432 Sqft
$785,000
Listing ID#A11397306
QR Code
Basic Details
Building Name : BAY HOUSE CONDO
Property Type : Condo
Listing Type : Sold
Listing ID : A11397306
Price : $795,000
Original Price : $800,000
Bedrooms : 3
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 1,432 Sqft
Year Built : 2015
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 1182
DOM : 102
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