Brickell Listings

Features
: In Ground , Community
: Other
: Restrictions Or Possible Restrictions
: Unfurnished
0
0
Property Description

Gorgeous Condo Available for Rent! Situated in the Water View Condominiums, this unit offers all the essentials. Recently renovated to perfection. Generously-sized bedroom flooded with natural light. Modern stainless steel appliances included. Convenient in-unit washer and dryer. Step out onto the open balcony to enjoy the surroundings. Prime location for your convenience. Simply move in and indulge in the comfort!

Condo For Rent at WATERVIEW CONDO

14951 SW 82nd Ln #17-501, Miami, Florida 33193

  • Bedrooms : 1
  • Bathrooms : 1
  • Square Footage: 848 Sqft
$2,000
Listing ID#A11573890
QR Code
Basic Details
Subdivision : 14951 SW 82nd
Building Name : WATERVIEW CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11573890
Price : $2,000
Original Price : $2,000
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 848 Sqft
Year Built : 1991
Property Sub Type : Condominium
DOM : 2
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