Brickell Listings

Features
: Canal , Garden
: Unfurnished
3
3
Property Description

TOTALLY RENOVATED AND BRAND-NEW APPLIANCES, A/C AND GAS HEATER! GREAT PROPERTY AT RIVERBEND NEIGHBORHOOD. 5 BEDROOMS/3 BATHROOMS/1 HALF BATHROOM. THE 5TH BEDROOM GOT FULL BATHROOM, KITCHENET AND OTHER ENTRANCE, THAT CAN BE USED AS INCOME PROPERTY OR FAMILY MEMBER LIVING QUARTER SEPARATED FROM THE HOUSE. LARGE PATIO WITH COZY CABANNA WITH GREAT SPACE FOR CONSTRUCT YOUR DREAM POOL. BACKYARD ACCESS TO LARGE AREA BETWEEN THE PROPERTY AND THE CANAL.
MUST SEE!

Single Family Home Sold RIVER BEND SEC 31,788 Sqft

14911 SW 150th St, Miami, Florida 33196

  • Bedrooms : 5
  • Bathrooms : 4
  • Square Footage: 1,788 Sqft
$680,000
Listing ID#A11390238
QR Code
Basic Details
Building Name : RIVER BEND SEC 3
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11390238
Price : $699,900
Original Price : $730,000
Bedrooms : 5
Bathrooms : 4
Half Bathrooms : 1
Square Footage : 1,788 Sqft
Year Built : 1993
Property Sub Type : Single Family Residence
DOM : 133
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