Brickell Listings

Features
: Heated , Concrete , Equipment Stays , In Ground , Pool/spa Combo
1
1
Property Description

Location, location, location! This home is nestled in the heart of Miami and the historic Little Havana/Shenandoah neighborhood. This property is in prime walking distance to great restaurants, bars, and local hotspots in Miami. Beautifully renovated, this home offers four bedrooms & three bathrooms with pool and exotic landscaping throughout. This house is perfect for investment and/or families. Comes fully furnished with high end security system and electric gate. Other great additional features are putt putt/mini golf, pool plus jacuzzi, outdoor kitchen, and grill. House was fully renovate. All appliances are brand new.

Single Family Home For Sale SHENANDOAH

980 SW 15th Ave, Miami, Florida 33135

  • Bedrooms : 4
  • Bathrooms : 3
$2,435,000
Listing ID#A11531254
QR Code
Basic Details
Building Name : SHENANDOAH
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11531254
Price : $2,435,000
Original Price : $2,435,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Year Built : 1949
Property Sub Type : Single Family Residence
DOM : 1
Tax : $9,384
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