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

12836 N Fm 450
Harleton, TX 75651

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $574,900
Beds: 3
Baths: 3
Status: Active
SqFt: 2934
Agency: Coldwell Banker Lenhart

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 1987
Notes: This unique home (named Maple Hill by its former owners) is located on a beautiful, historic farm property, acquired by the owners' ancestors by Land Grant from the State of Texas in the 1800’s. On a tree-lined hill with rolling pastures just south of the community of Harleton, this lovely custom farmhouse with wrap-around porch and amazing sunset views is ready for its next chapter. The house is conveniently located just 25 minutes to lively, downtown Longview, and 20 minutes to downtown historic attractions in Marshall and Jefferson. It’s also situated just 10 minutes from lovely Lake O’ the Pines, and only 5 minutes to the scenic Enoch's Stomp Winery and the Bear Creek Smokehouse. The picturesque 3.77 acre lot carved from the original family farm, has a 2-acre charmingly landscaped yard, and is the setting for this custom 2,934 sq. ft. farmhouse with attached garage. The spacious floor plan begins with spectacular views from the 60 foot wide front porch, perfect for morning coffee or an evening enjoying the breeze and sunset views. As you enter the glass front door, a soaring entrance hall showcases an oak staircase and upstairs balcony landing, and opens to a cozy living room with wood-burning fireplace and surrounding built-in bookshelves. The oak-floored great-room includes an open concept kitchen with granite countertops, a large island, a wall of windows with views to the back garden, and plenty of space for both dining and casual living, as well as a built-in granite-top desk area. Off the kitchen and dining area is an enclosed, sunny, tile-floored flex room with large windows overlooking the gardens, perfect for hobbies or overflow dining. The mudroom and laundry has a utility sink and plenty of pantry storage, connecting to a spacious 2-bay garage with built-in storage. The floor plan includes 3 generous bedrooms, 2 full baths and a downstairs half bath powder room. The downstair primary bedroom includes an en-suite bathroom with 2 vanity sinks, a large soaker tub, and a glass-walled shower, plus a walk-in closet and a bonus bathroom closet. Upstairs are 2 large sunny bedrooms, each with huge walk-in closets and built-in storage. The bathroom connecting these two bedrooms has 2 sinks and a separate enclosed space for the tub/shower combo. There is also a flex room/office adjacent to a crafting closet in the upstairs hallway. Every detail of Maple Hill was thoughtfully and lovingly planned by the owners when they retired from careers in Houston to enjoy country life.
MlsNumber: 20241763


Listing Provided By: Coldwell Banker Lenhart, original listing
Name: Coldwell Banker Lenhart
Phone: (903) 753-0447
Office Name: Coldwell Banker Lenhart
Office Phone: (903) 753-0447
Agent Name: Suzanne Nutt
Disclaimer: Copyright © 2024 Longview Area Association of Realtors. 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