Brickell Listings

Features
: Heated , In Ground
: Maximum 20 Lbs
: Unfurnished
1
1
Property Description

Large 1 Bedroom Apartment 1100’sq. with amazing light. Quiet Neighborhood. Gated community. Top floor with view of lake and Aventura skyline. Very close to all international airports. Large screened in balcony. Moments away from dinning, shopping and entertainment. Very well kept with new water heater and washer combo machine. Tennant has lease till April. Must make appointment with time to show.

Condo For Rent at LAKEVIEW OF THE CALF CLUB

20860 San Simeon Way #403-6, Miami, Florida 33179

  • Bedrooms : 1
  • Bathrooms : 2
  • Square Footage: 1,100 Sqft
$1,900
Listing ID#A11539089
QR Code
Basic Details
Subdivision : 20860 San Simeon
Building Name : LAKEVIEW OF THE CALF CLUB
Property Type : Condo
Listing Type : For Rent
Listing ID : A11539089
Price : $1,900
Original Price : $1,800
Bedrooms : 1
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 1,100 Sqft
Year Built : 1981
Property Sub Type : Condominium
DOM : 15
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