Brickell Listings

Features
: Other
: Yes
: Unfurnished
0
0
Property Description

Great starter home! This 3 bedroom 2 bath home offers granate counter tops, stainless steel appliances, tile throughout, new roof in 2017, new a/c 2021, fenced back yard and NO HOA. Close to shopping, dining with easy access to FL Turnpike. Call today for your private showing.

Single Family Home Sold GEM HOMES NO THREE1,150 Sqft

14501 SW 300th St, Homestead, Florida 33033

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,150 Sqft
$405,000
Listing ID#A11362522
QR Code
Basic Details
Building Name : GEM HOMES NO THREE
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11362522
Price : $399,999
Original Price : $399,999
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,150 Sqft
Year Built : 1974
Property Sub Type : Single Family Residence
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 `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