Brickell Listings

Features
: In Ground , Community , Fenced , Private
: Canal
: Maximum 20 Lbs
: Unfurnished
0
0
Property Description

Beautiful Completely remodeled 3-story townhouse with canal view. Central ac, washer & dryer in unit, master located on the third floor with walking closet and balcony and canal view. In Desirable Aqua Vista Community. Stainless steel appliances, White cabinets, laminated wood flooring, white painted, WASHER AND DRYER IN UNIT. IT’S FACING THE WATER CANAL AND HAS A BREATH TAKING VIEW FROM THE BACK PORCH AND THE BALCONY ON THE Master bed ..Minutes from Aventura Mall, Costco, beaches, restaurants, and parks. $200 water deposit. Water remain in owners name. Tenants pays all utilities (including water). Easy to show. Vacant. Fast Approval.

Condo For Rent at AQUA VISTA TOWNHOMES COND

2054 NE 167th St #3-122, North Miami Beach, Florida 33162

  • Bedrooms : 3
  • Bathrooms : 3
  • Square Footage: 1,182 Sqft
$3,000
Listing ID#A11571983
QR Code
Basic Details
Subdivision : 2054 NE 167th
Building Name : AQUA VISTA TOWNHOMES COND
Property Type : Condo
Listing Type : For Rent
Listing ID : A11571983
Price : $3,000
Original Price : $3,200
Bedrooms : 3
Bathrooms : 3
Half Bathrooms : 1
Square Footage : 1,182 Sqft
Year Built : 2006
Property Sub Type : Townhouse
DOM : 11
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