Brickell Listings

Features
: Garden View
: Restrictions Or Possible Restrictions
0
0
Property Description

Beautiful 2 story corner unit in 1st floor, 2 bed, 2.5 bath. Totally renovated, Open and modern concept, Quartz Counter Top, Stainless Steel appliances. Gated community with Great amenities to enjoy like kids play ground, pool, gym, club house, tennis court, pet friendly. Centrally located with easy access to the major expressways Turnpike and Palmetto, I-75 as well as shopping centers, restaurants, supermarkets and much more. NO RENTAL RESTRICTIONS

Condo For Sale at MIRASSOU CONDO,Mirassaou Condominiu

6045 NW 186th St #117, Hialeah, Florida 33015

  • Bedrooms : 2
  • Bathrooms : 3
  • Square Footage: 1,041 Sqft
$325,000
Listing ID#A11547511
QR Code
Basic Details
Subdivision : 6045 NW 186th
Building Name : MIRASSOU CONDO,Mirassaou Condominiu
Property Type : Condo
Listing Type : For Sale
Listing ID : A11547511
Price : $325,000
Original Price : $330,000
Bedrooms : 2
Bathrooms : 3
Half Bathrooms : 1
Square Footage : 1,041 Sqft
Year Built : 1991
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 505
DOM : 35
Tax : $2,505
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