Brickell Listings

Features
: Garden
: Unfurnished
0
0
Property Description

Professionally Maintained and Managed 4 bedroom 2 bathroom. home. Features updated exterior paint as well as an updated interior throughout. Kitchen is updated and features newer appliances. Incredible investment opportunity or perfect for first time homes buyer. Ready to show priced to sell.

Single Family Home Sold MYRA DELLS SUB1,150 Sqft

15651 NE 15th Ave, North Miami Beach, Florida 33162

  • Bedrooms : 4
  • Bathrooms : 2
  • Square Footage: 1,150 Sqft
$412,000
Listing ID#A11351485
QR Code
Basic Details
Building Name : MYRA DELLS SUB
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11351485
Price : $399,900
Original Price : $399,900
Bedrooms : 4
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,150 Sqft
Year Built : 1953
Property Sub Type : Single Family Residence
DOM : 23
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