Brickell Listings

Features
: Community
: Partially
0
0
Property Description

This spacious and quiet lake front 1bed/1.5bath unit is located in the heart of Aventura. It is very close to grocery stiores and pharmacy as well as to the Aventura Mall. The unit comes with one assigned parking spot and guest parking is available Fantastic amenities include Gym, large pool and party room for any events.

Condo For Rent at BISC LAKE GARDENS NO 2 BL

2825 NE 201st Ter #M216, Aventura, Florida 33180

  • Bedrooms : 1
  • Bathrooms : 2
  • Square Footage: 800 Sqft
$1,850
Listing ID#A11569147
QR Code
Basic Details
Subdivision : 2825 NE 201st
Building Name : BISC LAKE GARDENS NO 2 BL
Property Type : Condo
Listing Type : For Rent
Listing ID : A11569147
Price : $1,850
Original Price : $1,850
Bedrooms : 1
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 800 Sqft
Year Built : 1968
Property Sub Type : Condominium
DOM : 0
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