Brickell Listings

Features
: In Ground
: Other
: Restrictions Or Possible Restrictions
0
0
Property Description

Awesome fully furnished home with jacuzzi and pool. Excellent opportunity to have an extra income, perfect for a big family or investor. One of the best areas of South Florida in Miami. Close to everything, beaches, Southland Mall, Turnpike and much more. Owner motivated. Won’t last long. Call listing agent today.

Single Family Home For Sale BEL-AIRE SEC 12,231 Sqft

18780 Lenaire Dr, Cutler Bay, Florida 33157

  • Bedrooms : 3
  • Bathrooms : 3
  • Square Footage: 2,231 Sqft
$1,199,900
Listing ID#A11510744
QR Code
Basic Details
Building Name : BEL-AIRE SEC 1
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11510744
Price : $1,199,900
Original Price : $1,199,900
Bedrooms : 3
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 2,231 Sqft
Year Built : 1958
Property Sub Type : Single Family Residence
DOM : 22
Tax : $3,194
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