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

1847 N Hwy 19
Emory, TX 75440
Laura Hooker with Leslie Cain Realty, LLC, original listing - (903) 594-8721

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,795,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2819 Square Feet
Agency: Leslie Cain Realty, LLC
Agency Phone: (903) 594-8721

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 14 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Welcome to this unique, one of kind cabin full of history, charm and exceptional craftsmanship nestled on 14.5 acres in Emory, Texas. The history of this home goes back to the 1890’s when it was first built. In the 1970’s it was moved to this property and remodeled. In 2017 the current owners bought it and completely rebuilt it it from the foundation up. The shiplap is original as well as some studs but everything else has been rebuilt to bring it back to life while keeping an historical 1800s feel. With over 2800sqft in the main home, there is plenty of room for all. The primary bedroom is downstairs, along with the second bedroom (or office). The third bedroom, reading area + a loft is upstairs and there are a total of two and half bathrooms, two living areas and a formal dining. This estate is being sold fully furnished with exquisite pieces of art, furniture and antiques. With intricately handpainted metal ceilings, vintage metal crown molding, original shiplap, antique lighting, vintage stain glass windows and incredibly detailed tile work you will simply never find another home like this. A limestone pathway will bring you around the home to the stunning landscaping and porches. The Carriage House sits just a ways from the main home and while it’s the most gorgeous parking or covered area you’ve ever seen, it also has an amazing game room. This property is a perfect mix of pasture land and timber with a fully stocked pond. There is so much more to tell you about this property so we will just have to show you. Schedule your private tour today to come see how this historic home meets modern luxury and blends in the most beautiful way.
MlsNumber: --
ListingId: 24015621


Listing Provided By: Leslie Cain Realty, LLC, original listing
Phone: (214) 454-6998
Office Phone: (903) 594-8721
Agent Name: Laura Hooker
Disclaimer: Copyright © 2024 Greater Tyler 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