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

12632 Hiram Road
Wills Point, TX 75169
Frank Roberts with RE/MAX Landmark, original listing - (972) 524-2525

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,550,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3651 Square Feet
Agency: RE/MAX Landmark
Agency Phone: (972) 524-2525

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 48 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 2022
Notes: Stunning 2023 custom home on 48 acres, offering a perfect blend of luxury and functionality. Step into the inviting entryway with charming brick floors. To the left of the entry is the office, to the right a well-appointed wet bar. Ahead is the expansive great room. This space features hardwood floors, soaring beamed ceilings, a cozy fireplace flanked by built-ins, and breathtaking views of the pool, lush yard, and surrounding woods. The great room seamlessly transitions to outdoor living with a beautifully designed covered patio, complete with a wood plank ceiling, brick fireplace, built-ins, and retractable screens for year-round enjoyment. <br /> The open-concept kitchen is stylish and functional, boasting a large island, floor-to-ceiling cabinetry, a 6-burner Wolf range, SubZero fridge, double ovens, and a warming drawer. The north wing offers three bedrooms, 2.5 baths, a game room with patio access, and a versatile hobby room. The luxurious owner’s suite in the south wing features a spa-like bath with a freestanding tub, dual vanities, and an oversized dual-head shower. The expansive walk-in closet offers built-in storage, abundant hanging space, and a washer-dryer hookup for added convenience.<br /> The north wing includes a game room flooded with natural light from a wall of windows offering scenic views. Opposite the windows, charming barn doors open to a versatile hobby room, perfect for crafts or a home office. Each of the three bedrooms in this wing features a walk-in closet. Two share a Jack-and-Jill bath, while the third boasts an ensuite with a large walk-in shower.<br /> The mudroom, located off the garage, is thoughtfully designed with bench seating, ample cabinetry, and hanging space. Adjacent is a well-equipped laundry room with a sink, full-sized washer-dryer, hanging area, and abundant cabinetry. Outside, enjoy the heated pool, wrought-iron fencing, and a beautifully landscaped yard. Equine enthusiasts will appreciate the barn with 11 stalls and a tack room.
MlsNumber: --
ListingId: 20757831


Listing Provided By: RE/MAX Landmark, original listing
Phone: (972) 524-0689
Office Phone: (972) 524-2525
Agent Name: Frank Roberts
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App