Brickell Listings

Features
: Other , Garden
: Unfurnished
1
1
Property Description

Make this house your home! Well kept 4-bedroom, 2-bathroom, 1.5 car garage on a 31,329 sq. ft corner lot in the desirable Redlands area! Large circular drive way. The trees featured in the yard are avocado mango, lychee, cherry Barbados ,grapes, papaya, mac nut, bay rum tree, Miracle fruit, oak trees and palms. Completed fenced yard w/shed. Plenty of space to park your boat, RV, etc.. This property also features a sun room & screened in patio, great for entertaining. Roof was replaced in 2019. 45 Min drive to The Florida Keys!

Single Family Home Sold SILVER PALM ESTS PT 13,040 Sqft

23490 SW 152nd Ave, Homestead, Florida 33032

  • Bedrooms : 4
  • Bathrooms : 2
  • Square Footage: 3,040 Sqft
$735,000
Listing ID#A11345475
QR Code
Basic Details
Building Name : SILVER PALM ESTS PT 1
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11345475
Price : $759,900
Original Price : $774,900
Bedrooms : 4
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 3,040 Sqft
Year Built : 1976
Property Sub Type : Single Family Residence
DOM : 100
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