Brickell Listings

Features
0
0
Property Description

Welcome to this unique home in a desirable Hialeah neighborhood. This charming residence boast 3 bedrooms and 2.5 appointed bathrooms, including and ensuite in the primary bedroom. As you step on the main floor you will flow from the cozy living room to the adjacent dining area, kitchen and half bathroom. Upstairs you will find the bedrooms with ample closets space. This home is a must see for anyone in search of their forever home or perhaps an investment property. Showings by appointments only. Call listing agent!

Single Family Home For Sale ANDREWS PARK1,890 Sqft

380 W 45th St, Hialeah, Florida 33012

  • Bedrooms : 3
  • Bathrooms : 3
  • Square Footage: 1,890 Sqft
$550,000
Listing ID#A11571170
QR Code
Basic Details
Building Name : ANDREWS PARK
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11571170
Price : $550,000
Original Price : $575,000
Bedrooms : 3
Bathrooms : 3
Half Bathrooms : 1
Square Footage : 1,890 Sqft
Year Built : 1972
Property Sub Type : Single Family Residence
DOM : 13
Tax : $5,724
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