Brickell Listings

Features
: Unfurnished
0
0
Property Description

*Needs some TLC*4 Bedrooms 3 Bathroom located North Miami Beach near Oak Grove Park. This home features a Flex space with private bathroom. Minutes away from the Beach and all major highways. Owner Occupied. Great opportunity to become that perfect home. Several fruit trees with lots of yard space.

Single Family Home Sold PLEASANT VILLAGE1,733 Sqft

675 NE 159th St, Miami, Florida 33162

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 1,733 Sqft
$420,000
Listing ID#A11433623
QR Code
Basic Details
Building Name : PLEASANT VILLAGE
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11433623
Price : $449,999
Original Price : $449,999
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 1,733 Sqft
Year Built : 1952
Property Sub Type : Single Family Residence
DOM : 4
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