Brickell Listings

Features
: Restrictions Or Possible Restrictions
2
2
Property Description

Bright and spacious 3 Bed/ 2.5 bath townhome. Tastefully remodeled with open and inviting kitchen featuring quartz countertops, gas stove and wine cooler. Lots of natural light and nice layout. Private backyard is great to entertain. This cozy home is ready for a new family or investor. Community includes a clubhouse with a relaxing lake view, pool, 2 tennis courts, gym and event room. Location is great close to main highways, Dolphin mall, International mall, restaurants and more.

Condo For Sale at MARINA REAL CONDO NO 5

1187 NW 123rd Pl #204, Miami, Florida 33182

  • Bedrooms : 3
  • Bathrooms : 3
  • Square Footage: 1,240 Sqft
$484,999
Listing ID#A11570417
QR Code
Basic Details
Subdivision : 1187 NW 123rd
Building Name : MARINA REAL CONDO NO 5
Property Type : Condo
Listing Type : For Sale
Listing ID : A11570417
Price : $484,999
Original Price : $484,999
Bedrooms : 3
Bathrooms : 3
Half Bathrooms : 1
Square Footage : 1,240 Sqft
Year Built : 1995
Property Sub Type : Townhouse
Assoc Fee Frequency : Monthly
Association Fee : 373
DOM : 9
Tax : $2,607
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