Brickell Listings

Features
: Garden
: Restrictions Or Possible Restrictions
: Furnished
5
5
Property Description

TURNKEY! AVAILABLE FOR LONG AND SHORT TERMS. Beautiful 4/2 bath Pool table home is ready for you to move in. This home is tastefully furnished, with a fully stocked kitchen, hurricane accordion shutter windows, a bright open layout, a patio with a BBQ grill, a laundry room, a many parking space with an Outside Outlet to charge EV, and much more. Internet, and landscaping maintenance are included in the price. The tenant pays for extra electricity, and extra top water please text number listing agent.

Single Family Home For Rent ESSEX VILLAGE 6TH ADDN1,079 Sqft

612 Hialeah Dr, Hialeah, Florida 33010

  • Bedrooms : 4
  • Bathrooms : 2
  • Square Footage: 1,079 Sqft
$4,500
Listing ID#A11480859
QR Code
Basic Details
Building Name : ESSEX VILLAGE 6TH ADDN
Property Type : Single Family Home
Listing Type : For Rent
Listing ID : A11480859
Price : $4,500
Original Price : $5,500
Bedrooms : 4
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,079 Sqft
Year Built : 1950
Property Sub Type : Single Family Residence
DOM : 28
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