Brickell Listings

Features
2
Property Description

Recently built duplex unit in Little Havana. Each unit has 3-BR 2.5 BTH, with a dedicated parking space (and street parking) and a small yard. Tiled throughout. Central AC. Both units currently tenant-occupied with leases and deposits. All utilities are paid by tenants. Landlord only covers yard maintenance. Financials provided upon request.

Residential Income For Sale at 235 Miami

235 SW 19th Ave, Miami, Florida 33135

  • Square Footage: 2,994 Sqft
$1,200,000
Listing ID#A11546952
QR Code
Basic Details
Building Name : IDLEWILD PARK
Property Type : Residential Income
Listing Type : For Sale
Listing ID : A11546952
Price : $1,200,000
Original Price : $1,200,000
Half Bathrooms : 0
Square Footage : 2,994 Sqft
Year Built : 2012
Property Sub Type : Duplex
DOM : 0
Tax : $5,903
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