Brickell Listings

Features
: In Ground , Community
: Unfurnished
0
0
Property Description

Comfortable apartment with 2 bedrooms and 2 full bathrooms. Remodeled and well maintained. Kitchen equipped with major appliances. Laundry room equipped with Washer and Dryer. Laminate and ceramic floors, blinds and ceiling fan. Gated complex. Excellent location.

Condo For Rent at MIRASSOU CONDO

6175 NW 186th St #209, Hialeah, Florida 33015

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,004 Sqft
$2,500
Listing ID#A11515054
QR Code
Basic Details
Subdivision : 6175 NW 186th
Building Name : MIRASSOU CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11515054
Price : $2,500
Original Price : $2,500
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,004 Sqft
Year Built : 1991
Property Sub Type : Condominium
DOM : 37
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 `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY FIELD(p.zip_name, 33131) DESC, p.price_si ASC , p.id ASC LIMIT , 1

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