Brickell Listings

Features
: Community , Above Ground
: Restrictions Or Possible Restrictions , No
: Unfurnished
0
0
Property Description

FOR SHOWINGS PLEASE CALL MY ASSISTANT AKAENA…AT THE 786-NUMBER
AVAILABLE FOR MOVE IN AFTER MAY 20TH. Beautiful & remodeled 3-bedroom 2-bath apartment all tiled except bedrooms (laminate in the with oversized bedrooms) located in the desirable Fontainebleau area on a corner on the second floor. Huge balcony with washer & dryer. Excellent location with easy access to highways, shopping centers, public transportation, schools. Tenant occupied until May 15.

Condo For Rent at VISIONS AT FOUNTAINBLEAU

8517 NW 7th St #203, Miami, Florida 33126

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,208 Sqft
$2,850
Listing ID#A11560194
QR Code
Basic Details
Subdivision : 8517 NW 7th
Building Name : VISIONS AT FOUNTAINBLEAU
Property Type : Condo
Listing Type : For Rent
Listing ID : A11560194
Price : $2,850
Original Price : $2,850
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,208 Sqft
Year Built : 1984
Property Sub Type : Condominium
DOM : 12
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 `user_id` = '10' AND `googlemap_ln` <= -80.17419366840001 AND `googlemap_lt` <= 25.776113912074816 AND `googlemap_ln` >= -80.2012987316 AND `googlemap_lt` >= 25.755950235611895 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