Brickell Listings

Features
: Canal , Lake
: Unfurnished
0
0
Property Description

Remarkable property in a quiet and desirable location with an outstanding view to the lake. Enjoy your evenings and weekends in your beautiful backyard, bring your boat and spend some time fishing or cruising around the lake.rnFeatures a bonus room, shed, room for a pool, etc. It’s close to main roads, schools, super markets and much more.rnThis residence offers a cozy and luxurious atmosphere.rnHurry!! This property won’t last long!!rnrnSellers require 30 days after the sale to vacate.

Single Family Home Sold SALMA LAKE PH 11,425 Sqft

14225 SW 296th St, Homestead, Florida 33033

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,425 Sqft
$490,000
Listing ID#A11403897
QR Code
Basic Details
Building Name : SALMA LAKE PH 1
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11403897
Price : $475,000
Original Price : $475,000
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,425 Sqft
Year Built : 1999
Property Sub Type : Single Family Residence
DOM : 9
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