Brickell Listings

Features
: Other
: Restrictions Or Possible Restrictions
: Unfurnished
1
1
Property Description

Don’t miss the chance of renting this 2022 Newly Build Townhome! This well distributed two-story townhome located in Marbella by DR Horton offers 3 Bedrooms, 2.5 Bathrooms, and 1 Car Garage partially converted into a Playroom. Everything is Like New! Modern Tile and Carpet Floors, High Quality Cabinetry, Quartz Counter Tops, Stainless Steel Kitchen Appliances, Washer, Dryer, and Blinds throughout. Small Pets Welcomed! Just few minutes away from Florida Turnpike and Shopping Centers.

Condo For Rent at CEDAR AT KEYS GATE

839 SE 17th Ct, Homestead, Florida 33034

  • Bedrooms : 3
  • Bathrooms : 3
  • Square Footage: 1,712 Sqft
$2,950
Listing ID#A11554995
QR Code
Basic Details
Subdivision : 839 SE 17th
Building Name : CEDAR AT KEYS GATE
Property Type : Condo
Listing Type : For Rent
Listing ID : A11554995
Price : $2,950
Original Price : $3,000
Bedrooms : 3
Bathrooms : 3
Half Bathrooms : 1
Square Footage : 1,712 Sqft
Year Built : 2022
Property Sub Type : Townhouse
DOM : 40
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