Brickell Listings

Features
: In Ground
: Pool
: Yes
: Unfurnished
2
2
Property Description

….IMPRESSIVE 4 BEDROOMS 2.5 BATHROOMS ONE STORY HOME LOCATED IN THE PRESTIGIOUS NORTH LINKS COUNTRY CLUB ESTATES. THIS HOME SHOWS OFF AN OPEN FLOOR PLAN WITH A TRANQUILL POOL VIEW FROM THE FAMILY ROOM AND UPDATED KITCHEN. INDULGE IN THE SPACIOUS MASTER SUITE WITH WALK-IN CLOSET, BATHROOM WITH TUB AND SHOWER ALONG WITH HIS AND HER SINKS. THIS HOME IS VERY CLOSE TO THE GOLF COURSE AND SHOPPING AREAS. BRING YOUR FUSSIEST BUYERS TO SEE THIS GEM.

Single Family Home Sold NORTH LINKS COUNTRY CLUB,NORTH LINKS COUNTRY2,

7260 N Augusta Dr, Hialeah, Florida 33015

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 2,627 Sqft
$846,000
Listing ID#A11371685
QR Code
Basic Details
Building Name : NORTH LINKS COUNTRY CLUB,NORTH LINKS COUNTRY
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11371685
Price : $895,000
Original Price : $999,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 1
Square Footage : 2,627 Sqft
Year Built : 1987
Property Sub Type : Single Family Residence
DOM : 30
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