Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3291 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3291 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3291 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

2009 E Highland Street
Southlake, TX 76092
Sharon Hodnett with Keller Williams Realty, original listing - (817) 329-8850

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,499,000
Beds: 5
Baths: Full: 5, ½: 3
Status: Active
SqFt: 10264 Square Feet
Agency: Keller Williams Realty
Agency Phone: (817) 329-8850

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: ABSOLUTELY STUNNING! LOCATED ON 1.89 ACRES IN THE HEART OF SOUTHLAKE*MEDITERRANEAN DESIGN*PRIVACY ABOUNDS! PEACEFUL & SERENE*NO EXPENSE SPARED*TOP OF THE LINE EVERYTHING*AUSTIN STONE EXTERIOR WITH CAST STONE ACCENTS*POOL, SPA, SPORT COURT AND OUTDOOR LIVING WITH GRILL, GREEN EGG, BAR & FRIDGE*PATIO SHADES, ALUMINUM SHUTTERS THAT PROVIDE PROTECTION FROM ANY STORM*THIS WONDERFUL SPACE ALSO OFFERS FIREPLACE, SLIDING DOORS, HIBACHI BAR & AMPLE STORAGE CABINETS*ELEVATOR* CUSTOM CHRYSTAL LIGHT FIXTURES THROUGHOUT, ESPECIALLY IN ENTRY HALL WITH FLORAL CRYSTAL DESIGN*MUSIC ROOM*BILLIARDS ROOM,MEDIA ROOM, CURVED CUSTOM BAR W SPECIAL LIGHTING*2 FIREPLACES*WELL FOR IRRIGATION*SEPTIC*ALL BEDROOMS HAVE EN-SUITES*2ND LEVEL OFFER 2 BEDROOMS W EN-SUITES,GAME ROOM & 2ND STORY LIBRARY* PRIMARY SUITE IS SECOND TO NONE WITH HIS & HER BATHS, DRESSING AREA, SITTING AREA, CUSTOM CLOSETS WITH ALL BELLS AND WHISTLES*STORAGE FOR THE BEST WARDROBES AND SHOE COLLECTIONS IMAGINABLE*HIS AND HER STUDY’S*KITCHEN FEATURES PANTRY WITH PULL OUT SPICE DRAWERS,TOP OF THE LINE THERMADOR APPLIANCES, CATERING KITCHEN, SUB ZERO, 3 OVENS, STEAMER, CUSTOM PULLOUTS, WHITE PEARL MARBLE COUNTERS, BUILT IN CHINA CABINET, WINE FRIDGE, 2 DISHWASHERS & MORE*EXQUISITE MILL AND TRIM WORK*5 BEDROOMS*5 FULL BATHS*3 HALF BATHS*16 TOTAL ROOMS*BORAL CONCRETE TILE ROOF, QUALIFIES FOR INSURANCE DISCOUNT*MOROCCAN THEMED BEDROOM ON 1ST LEVEL*ELABORATE SECURITY SYSTEMS & CAMERAS CONVEY*IRON SECURITY GATE*FOAM ENCAPSULATED*HOMES HAS AMAZING STORAGE FOR EVERY SEASON*SECURITY GATE & AUTO COURT, NEW EPOXY FINISHED FLOORS*CIRLCE DRIVE*FRONT FOUNTAIN*4 CAR GARAGE, DIVIDED WITH 2 CAR GARAGES ON EACH SIDE OF HOME*6 PARKING SPACES*CARROLL ISD*NO HOA* SEE DRONE VIDEO, 360 TOUR AND COMPLETE AMENITIES & UPGRADES LIST ON NTREIS TRANSACTION DESK*BUYER IS REQUIRED TO PROVIDE PROOF OF FUNDS OR LENDER LETTER SHOWING THEY QUALIFY FOR THE SALES PRICE BEFORE SHOWINGS CAN BE SCHEDULED, SELLER TO REVIEW ALL DOCUMENTS*
MlsNumber: --
ListingId: 20775662


Listing Provided By: Keller Williams Realty, original listing
Phone: (817) 994-7152
Office Phone: (817) 329-8850
Agent Name: Sharon Hodnett
Disclaimer: Copyright © 2024 North Texas Real Estate Information Systems, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3291 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Leigh Ann Boyce
ASCIIChandler Crouch Realty
Call Today!: (817) 689-4264

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App