Brickell Listings

Features
: In Ground
: Pool , Garden
: Dogs Ok
: Unfurnished
1
0
Property Description

Award winning meticulous mansion, truly the grand dame of Shenandoah! Sellers were honored with the prestigious 2018 Key Keeper Award from the Dade Heritage Trust! Home is restored to perfection to satisfy the most discerning buyer. Lush gardens with wood-burning outdoor fireplace on one side, and a heated pool with water feature and gazebo on the other. Large, inviting terrace off the main bedroom, surrounded by mature trees. New kitchen with sitting area, new baths, laundry room, custom closet cabinetry, 2-zone A/C, impact windows throughout. Home is located in a quiet residential area, yet close to restaurants, theaters, and Brickell Ave. This is a truly exceptional home!

Single Family Home Sold SHENANDOAH2,612 Sqft

1004 SW 16th Ave, Miami, Florida 33135

  • Bedrooms : 3
  • Bathrooms : 4
  • Square Footage: 2,612 Sqft
$1,980,000
Listing ID#A11398246
QR Code
Basic Details
Building Name : SHENANDOAH
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11398246
Price : $1,980,000
Original Price : $1,980,000
Bedrooms : 3
Bathrooms : 4
Half Bathrooms : 1
Square Footage : 2,612 Sqft
Year Built : 1923
Property Sub Type : Single Family Residence
DOM : 7
Search Results

WordPress database error: [Unknown column 'http' in 'order clause']
SELECT x.position FROM (SELECT p.id, @rownum := @rownum + 1 AS position FROM `wp_wpl_properties` AS p JOIN (SELECT @rownum := 0) r WHERE 1 AND `googlemap_lt` >= 25.71317568519327 AND `googlemap_lt` <= 25.84498654272508 AND `googlemap_ln` >= -80.30280917716796 AND `googlemap_ln` <= -80.14144748283202 AND `listing` = '9' AND `zip_name` IN ('33131','33130','33129','33135','33133','33145','33132','33137') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY http DESC , p.id ASC ) AS x WHERE x.`id`='572550'

WordPress database error: [Unknown column 'http' in 'order clause']
SELECT `id` FROM `wp_wpl_properties` AS p WHERE 1 AND `googlemap_lt` >= 25.71317568519327 AND `googlemap_lt` <= 25.84498654272508 AND `googlemap_ln` >= -80.30280917716796 AND `googlemap_ln` <= -80.14144748283202 AND `listing` = '9' AND `zip_name` IN ('33131','33130','33129','33135','33133','33145','33132','33137') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY http DESC , p.id ASC LIMIT 0, 1

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 `googlemap_lt` >= 25.71317568519327 AND `googlemap_lt` <= 25.84498654272508 AND `googlemap_ln` >= -80.30280917716796 AND `googlemap_ln` <= -80.14144748283202 AND `listing` = '9' AND `zip_name` IN ('33131','33130','33129','33135','33133','33145','33132','33137') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY http DESC , p.id ASC LIMIT , 1

Agent info
Brickellmania LLC
3011 SW 24 ST. Miami Fl 33145
Contact Agent