Brickell Listings

Features
: Garden
: Unfurnished
1
1
Property Description

Everything that South Florida paradise living has to offer! Live among the most beautiful Redlands farms, weekend boating in The Keys, great schools, hospitals, shops and local fruits and vegetables picking! You are going to love your life style in this 1 story Single-family home with 4 spacious bedrooms, 2 baths, 1 full car garage in a quiet non-traffic street. It’s gorgeous huge backyard has the potential to create your own pool, plant diverse tropical fruit trees or space to store your boat. Easy to show, No HOA, come quickly, this house won’t last!

Single Family Home Sold MILYA SUB1,904 Sqft

18930 SW 307th St, Homestead, Florida 33030

  • Bedrooms : 4
  • Bathrooms : 2
  • Square Footage: 1,904 Sqft
$600,000
Listing ID#A11392267
QR Code
Basic Details
Building Name : MILYA SUB
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11392267
Price : $599,999
Original Price : $575,000
Bedrooms : 4
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,904 Sqft
Year Built : 2005
Property Sub Type : Single Family Residence
DOM : 25
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