Brickell Listings

Features
2
Property Description

Amazing Opportunity!! Zoned T4-R Income Producing Duplex in the Heart of Little Havana. A few blocks from the famed Calle Ocho and a short ride to Brickell. Great opportunity as the rental market continues to grow in this high demand area. Property cash flows with low maintenance and minimal expenses. Sit back and collect rent, headache free! Great neighborhood; close to schools and entertainment. Hurry, this one is a Steal!!

Residential Income For Sale at 154 Miami

154 SW 18th Ct, Miami, Florida 33135

  • Square Footage: 1,602 Sqft
$1,000,000
Listing ID#A11203084
QR Code
Basic Details
Building Name : IDLEWILD PARK
Property Type : Residential Income
Listing Type : For Sale
Listing ID : A11203084
Price : $1,000,000
Original Price : $1,100,000
Half Bathrooms : 0
Square Footage : 1,602 Sqft
Year Built : 1926
Property Sub Type : Duplex
DOM : 539
Tax : $5,708
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