Brickell Listings

Features
: Unfurnished
1
1
Property Description

Townhouse for rent 3 bedrooms, 2 and a half bathrooms, 1-car garage, two more spaces available in front, internet and direct TV included, section 8 Welcome

Condo For Rent at KEYS GARDEN

1471 SE 24th Ave #1471, Homestead, Florida 33035

  • Bedrooms : 3
  • Bathrooms : 3
  • Square Footage: 1,731 Sqft
$3,200
Listing ID#A11573320
QR Code
Basic Details
Subdivision : 1471 SE 24th
Building Name : KEYS GARDEN
Property Type : Condo
Listing Type : For Rent
Listing ID : A11573320
Price : $3,200
Original Price : $3,200
Bedrooms : 3
Bathrooms : 3
Half Bathrooms : 1
Square Footage : 1,731 Sqft
Year Built : 2018
Property Sub Type : Townhouse
DOM : 1
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 `googlemap_lt` >= 25.745089529790793 AND `googlemap_lt` <= 25.79020144252666 AND `googlemap_ln` >= -80.22284423068542 AND `googlemap_ln` <= -80.15317116931458 AND `price_si` <= '999999999999' AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY FIELD(p.zip_name, 33131) DESC, p.price_si ASC , p.id ASC LIMIT , 1

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