Brickell Listings

Features
: Lake , Lagoon
2
2
Property Description

Welcome Home to Casa Serena | In the heart of Palm Springs North, this family home perfectly combines modern amenities & waterfront lifestyle. Custom Built in 2012 with 4 BED & 2.5 BA & features tall ceilings, large windows with incredible water views. The kitchen is perfect for entertaining and the Family Room opens up directly to a covered terrace with barbecue. Imagine family gatherings on your large deck over looking the lake on a breezy day. Nearby great schools, restaurants, shops & More. Picture a life where every evening is an invitation for beautiful sunsets from the comfort of your lakefront home. Weekends are filled with fun as the backyard leads to your private ramp for your boat/jetski. This is TRULY the BEST in Waterfront Living– Take Advantage of Credit for Closing Costs!

Single Family Home For Sale PALM SPRINGS NORTH SEC T2,214 Sqft

17205 NW 87th Ave, Hialeah, Florida 33015

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 2,214 Sqft
$1,125,000
Listing ID#A11565216
QR Code
Basic Details
Building Name : PALM SPRINGS NORTH SEC T
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11565216
Price : $1,125,000
Original Price : $1,150,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 1
Square Footage : 2,214 Sqft
Year Built : 2012
Property Sub Type : Single Family Residence
Assoc Fee Frequency : Annually
Association Fee : 350
DOM : 20
Tax : $8,302
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 `googlemap_ln` <= -80.14808508830147 AND `googlemap_lt` <= 25.816874338565697 AND `googlemap_ln` >= -80.29542151169854 AND `googlemap_lt` >= 25.658807783326214 AND `zip_name` IN ('33131','33130','33129','33135','33133','33145','33132','33137') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY p.price_si ASC , p.id ASC LIMIT , 1

Agent info
Brickellmania LLC
3011 SW 24 ST. Miami Fl 33145
Contact Agent