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 = 3363 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 = 3363 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 = 3363 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;

1289 Bourland Road
Keller, TX 76248
Dan Harker with Keller Williams Realty DPR, original listing - (972) 732-6000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,200,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 6346 Square Feet
Agency: Keller Williams Realty DPR
Agency Phone: (972) 732-6000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Spectacular gated estate on 1.6+ ACRES features an attached guest quarters, a private pond & backyard oasis, a charming courtyard, and a 4-car garage! Established neighborhood, mature trees, & outstanding location -- minutes to 377, 114, I35, with quick access to downtown Fort Worth, DFW Airport, local shops & dining. Designed for family living & entertaining, this stunning estate combines elegance and functionality with soaring ceilings, hand-scraped hardwood floors, plantation shutters, exposed beams, striking stone fireplace, music system throughout the estate, custom cabinetry with built-ins, moldings & millwork throughout. The formal dining showcases travertine and hand scraped hardwood floors, wrought iron and crystal chandelier, and French doors leading to the outside courtyard. A well-appointed kitchen features two islands, stainless steel appliances, and modern updates that opens to an adjacent breakfast nook. Retreat to the exquisite primary suite that includes a cozy turret seating area, while the luxurious en-suite bath offers a steam shower, dual toilets, a jetted tub, and a massive closet with a washer-dryer hookup.<br /> <br /> The main floor also includes a large office, a secondary office, and three bedrooms with 3.5 baths, providing ample space for comfort and storage. Upstairs, you'll find a theatre room, a workout room or flex space, an additional bedroom, and a full bath. The backyard oasis begins with a covered outdoor patio and fully equipped kitchen with a fabulous brick & stone fireplace that opens to an extended patio with a sparkling pool, a relaxing hot tub and water features. Crisp flower beds & landscaping for all seasons with an extensive, fully-fenced backyard, mini golf course, and space for pets and play. In addition, the attached guest quarters feature a kitchenette, a full guest bath & walk-in closet, with access to the courtyard -- the perfect space for in-law visits! Full house generator. Jellyfish Lighting for all seasons. NO HOA!
MlsNumber: --
ListingId: 20781688


Listing Provided By: Keller Williams Realty DPR, original listing
Phone: (972) 732-6000
Office Phone: (972) 732-6000
Agent Name: Dan Harker
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 = 3363 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;
Monique Jackson
ASCIIRealty of America LLC
Call Today!: (682) 231-1159

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App