Brickell Listings

Features
: Other
: More Than 20 Lbs
: Unfurnished
1
0
Property Description

Charming Single Family Home with 3 bedrooms , 2 bathrooms and patio. Stainless steel kitchen appliances. The property is close to major highways, minutes away from the Miami International Airport, Downtown Miami and some Shopping Centers. Please, Call listing Agent for details

Single Family Home Sold MAYLAND1,080 Sqft

1621 NW 29th Ave, Miami, Florida 33125

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,080 Sqft
$470,000
Listing ID#A11307923
QR Code
Basic Details
Building Name : MAYLAND
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11307923
Price : $485,000
Original Price : $480,000
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,080 Sqft
Year Built : 1955
Property Sub Type : Single Family Residence
Assoc Fee Frequency : Annually
Association Fee : 0
DOM : 85
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