Brickell Listings

Features
: In Ground
2
2
Property Description

Gated Private Home, 5/4 , 3400sq ft, 2 story pool home with cozy fireplace on Huge Corner Lot. Circular Paved driveway frame this beautiful home with high vaulted ceilings as you enter the living room, it has a family room and dining room, Large Eatin Kitchen as been totally remodeled, with Viking gas stove. Also Large Master Bedroom has two walkin closets and small balcony. Master bath has large modern tub,all rooms are large, with a 2 car garage, one side converted into Music studio or home office with a private entrance. Outsided covered terrace frames beautiful tropical pool area, great for entertaining. Pool size is 15 x 25. This home is surrounded by milllion dollar homes, and has wonderful schools and universities nearby.

Single Family Home For Sale BASA SUB2,923 Sqft

6195 SW 97th Ave, Miami, Florida 33173

  • Bedrooms : 5
  • Bathrooms : 3
  • Square Footage: 2,923 Sqft
$1,599,000
Listing ID#A11509255
QR Code
Basic Details
Building Name : BASA SUB
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11509255
Price : $1,599,000
Original Price : $1,599,000
Bedrooms : 5
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 2,923 Sqft
Year Built : 1989
Property Sub Type : Single Family Residence
DOM : 37
Tax : $12,367
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