Brickell Listings

Features
: Community
: Garden
: Unfurnished
0
0
Property Description

Don’t miss an excellent opportunity to live in a beautiful updated townhouse. The unit has 3 spacious bedrooms, 2 1/2 bathrooms, new laminate floors throughout the house, 5 months old appliances, new LED light fixtures, new garbage disposal, new blinds. It is freshly painted and professionally cleaned. Quiet and family oriented neighborhood. 24H security guard at the gate for your security. Located close to good schools, parks, shopping centers, and the Florida Keys. The community pool is available to you to relax in the hot summers. With its great location and updates features, this townhouse won’t stay on the market for long. Schedule a viewing today!

Condo For Rent at SHOMA TOWNHOMES AT KEYSCO,Keys Cove

1457 SE 24th Ct #252, Homestead, Florida 33035

  • Bedrooms : 3
  • Bathrooms : 3
  • Square Footage: 1,302 Sqft
$2,300
Listing ID#A11541613
QR Code
Basic Details
Subdivision : 1457 SE 24th
Building Name : SHOMA TOWNHOMES AT KEYSCO,Keys Cove
Property Type : Condo
Listing Type : For Rent
Listing ID : A11541613
Price : $2,300
Original Price : $2,450
Bedrooms : 3
Bathrooms : 3
Half Bathrooms : 1
Square Footage : 1,302 Sqft
Year Built : 2005
Property Sub Type : Townhouse
DOM : 41
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