Brickell Listings

Features
: Community , Above Ground
: Canal
: Furnished
2
2
Property Description

Beautiful and updated 3/2.5 Townhouse villa in Aventura. Full of natural light, renovated kitchen area with stainless steel appliances with granite countertops, double sink. Located in Mariner Village, this property belongs to family friendly community, at walking distance from Don Soffer Highschool, Target, Wholefoods, Aventura mall, and Waterways Marina. Available right away. Easy to show, text listing agent. Second floor with laminate floors and beautiful closets.

Condo For Rent at MARINER VILLAGE GARDEN CO

3535 Magellan Cir #524, Aventura, Florida 33180

  • Bedrooms : 3
  • Bathrooms : 3
  • Square Footage: 1,723 Sqft
$6,500
Listing ID#A11545249
QR Code
Basic Details
Subdivision : 3535 Magellan
Building Name : MARINER VILLAGE GARDEN CO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11545249
Price : $6,500
Original Price : $6,500
Bedrooms : 3
Bathrooms : 3
Half Bathrooms : 1
Square Footage : 1,723 Sqft
Year Built : 1986
Property Sub Type : Townhouse
DOM : 1
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