Brickell Listings

Features
: Yes
: Unfurnished
6
6
Property Description

This corner and spacious yard home with kitchen, bathroom and floor remodeled recently perfect for first time home buyers and investors. Fully new appliances, new A/C. Prime location with easy access to Krome ave, US1 and the Florida Turnpike, as well as close proximity to the entrance of captivating Florida Keys. NO HOA!!!

Single Family Home For Sale NEWTON HEIGHTS1,140 Sqft

30360 SW 158th Ave, Homestead, Florida 33033

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,140 Sqft
$459,000
Listing ID#A11477214
QR Code
Basic Details
Building Name : NEWTON HEIGHTS
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11477214
Price : $459,000
Original Price : $459,000
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,140 Sqft
Year Built : 1972
Property Sub Type : Single Family Residence
DOM : 13
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