Brickell Listings

Features
: Garden
: Unfurnished
0
0
Property Description

COMPLETELY REMODELED, inside and out. LIVE WORRY FREE in this turn-key, spacious 3 bedroom, 2 bathroom home that has ROOM FOR A POOL, BOAT, RV OR FUTURE EXPANSION! NEW roof, NEW impact windows and Doors, NEW kitchen with quartz countertop, TWO NEW bathrooms, NEW electrical and plumbing, NEW AC system and ductwork, NEW flooring, interior doors, moldings and LED light fixtures. CENTRALLY LOCATED and close to Aventura Mall, the Beaches, Oleta Park, Greynolds Park and so much more. See broker instructions.

Single Family Home Sold ARCH CREEKS ESTATES

1390 NE 150th St, Miami, Florida 33161

  • Bedrooms : 3
  • Bathrooms : 2
$440,000
Listing ID#A11353707
QR Code
Basic Details
Building Name : ARCH CREEKS ESTATES
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11353707
Price : $439,800
Original Price : $419,800
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Year Built : 1946
Property Sub Type : Single Family Residence
DOM : 41
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