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;

1025 Rs County Road 4261
Emory, TX 75440
Julie Henderson with Coldwell Banker Apex, REALTORS, original listing - (972) 783-1919

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $844,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3590 Square Feet
Agency: Coldwell Banker Apex, REALTORS
Agency Phone: (972) 783-1919

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: One of a kind custom luxury Lodge design home, Surrounded by 5 wooded acres. High-end appliances, Pella windows, 11-foot granite island, travertine backsplash, solid hickory hardwood floors, 2 fireplaces, and the best metal roof you can buy. On demand hot water heaters and cozy highly efficient fire places are just the beginning of the attention-to-detail you’ll find and enjoy throughout this lovely home. Wonderful kitchen with spacious  pantry and massive custom wood cabinets, overlooking the expansive living and dining areas with vaulted beamed ceilings. and towering windows with the most beautiful views. Master suite with large walkin his and hers closet, and master bath has cast iron claw foot tub and separate shower. you have a separate wing with 2 spacious guest bedrooms  that share a jack and jill bathroom. Laundry with built ins and laundry shoot. Pella doors open to a breathtaking view of your land watch the deer drink from the bass stocked pond, while listening to music from your custom  surround sound system. What a beautiful place for entertaining while cooking in your out door kitchen. The upstairs bonus room makes a great game room or gym area, and down the hall is your very own wonderful wine room that stays 61 degrees at all times along with sitting area while you and the girls are having a glass of wine. This place has so many amenities there was nothing spared in this home. You owe it to yourself to experience the serenity this place offers. You also have a oversized garage with work area and a shop or guest house with bathroom. and covered storage for RV, Motorhome and toys, and an additional covered area for what ever you need, or finish it out for another guest cottage.<br /> this place offers so many possibilities. <br />  Information Deemed Reliable, but not Guaranteed. Buyer and buyers agent do your due diligence.
MlsNumber: --
ListingId: 20788316


Listing Provided By: Coldwell Banker Apex, REALTORS, original listing
Phone: (972) 896-0092
Office Phone: (972) 783-1919
Agent Name: Julie Henderson
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