Brickell Listings

Features
: Other View , Garden View
: Restrictions Or Possible Restrictions
1
1
Property Description

LIKE A SINGLE FAMILY. Very spacious 4-bedroom 3 full bath, CORNER LOT townhome! Year built in 2018 and features over 1952 sq. ft. of living space, one bedroom and full bath downstairs, walk-in closet in the 3 upstairs bedrooms, 1-car garage, fully fenced in a beautiful backyard and it has no neighbor next to or behind, tile floors NO CARPET. It has been many days in the market because it was rented. NOW Easy to show.

Condo For Sale at KEYS GARDEN

2592 SE 15th Ct #2592, Homestead, Florida 33035

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 1,952 Sqft
$440,000
Listing ID#A11411237
QR Code
Basic Details
Subdivision : 2592 SE 15th
Building Name : KEYS GARDEN
Property Type : Condo
Listing Type : For Sale
Listing ID : A11411237
Price : $440,000
Original Price : $459,900
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 1,952 Sqft
Year Built : 2018
Property Sub Type : Townhouse
Assoc Fee Frequency : Monthly
Association Fee : 232
DOM : 279
Tax : $5,988
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