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 = 2637 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 = 2637 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 = 2637 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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;

6510 County Road 3409
Lone Oak, TX 75453
Brian S. Curry with RE/MAX DFW Associates, original listing - (972) 426-2241

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,750,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4594 Square Feet
Agency: RE/MAX DFW Associates
Agency Phone: (972) 426-2241

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 41 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: **ONE OF A KIND CUSTOM COUNTRY HOME ON OVER 40 ACRES** **COUNTRY LIVING AT ITS FINEST** **OVER 4,500 SQ.FT** **MASTERFULLY DESIGNED FROM TOP TO BOTTOM** **AG EXEMPT** **HARD TO FIND LEASED ACCESS & USE TO SABINE RIVER AUTHORITY LAND – ADDITONAL 30 ACRES THAT ABUTS THIS PROPERTY** The gorgeous home is set back and down a long driveway giving you all the privacy you need. Stunning & grand covered porch boasting 20 feet high ceiling at its peak. Impressive wraparound porch on 3 sides. Equally grand is your foyer entrance with first sight of the floor to ceiling stone fireplace with hand-built log mantle. This great room is approximately 48’ x 22’ which features wood flooring and two French styled doors to your covered back porch. An abundance of windows were added to maximize natural light and the view. The Chef’s kitchen awaits you! A perfect combination of commercial grade appliances, including a Thermador side by side double oven nestled within a stone accented arch, and many other features! The oversized quartz island with prep sink has countless benefits. Other features include a built-in ice maker, microwave drawer, warming drawers and let’s not forget the Thermador column refrigerator & freezer. Added extensions include the butler’s pantry and WIP. The beautiful long dining room is ready for hosting holidays and parties. Custom crafted hutch sets the tone. Also, it includes window seats with storage. The flexible, multi-purpose room is a dream! Outfitted with plenty custom craft cabinetry including a built-in desk. The study has built-in book shelving, fireplace and a hidden room. Lovely guest bedrooms offer ensuite bathrooms with pocket doors plus access to wraparound porch. Stunning primary bedroom with fireplace and access to a huge deck and hot tub! Ensuite offers a double walk-in shower, dual sinks & WIC. This property has full perimeter fencing with gated keypad access. The land features two ponds, goat and horse pasture, RV building & barn.
MlsNumber: --
ListingId: 20926812


Listing Provided By: RE/MAX DFW Associates, original listing
Phone: (972) 426-2241
Office Phone: (972) 426-2241
Agent Name: Brian S. Curry
Disclaimer: Copyright © 2025 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 = 2637 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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;
Real Estate Expert Photo for Sarah Helm
Sarah Helm
ASCIICross Power Real Estate, LLC
Call Today!: (903) 408-0557

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App