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;

2781 Fm 859
Edgewood, TX 75117
Rachel Craig with eXp Realty LLC, original listing - (888) 519-7431

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $665,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2656 Square Feet
Agency: eXp Realty LLC
Agency Phone: (888) 519-7431

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: The Edgewood ISD gem you've been waiting for! Soaring ceilings and expansive windows to view the deer that walk right up to your covered back porch. Luxury details include Blue Ponderosa Pine tongue and groove ceilings, gas fireplace, commercial grade stainless steel kitchen appliances that all stay, drawer microwave in the oversized island, impressive 8 burner, double oven gas range, separate upstairs HVAC, gas appliances including a tankless water heater. The home and shop are spray-foamed with an interior dehumidifier. BIG rooms, primary bedroom closet is 13x14! Primary suite is sequestered and has an ensuite bathroom which includes a separate glass enclosed walk in shower, clawfoot tub, and dimmable, fogless LED mirror on the double vanity. There is a separate toilet room. There are two bedrooms and a full bath upstairs and one more downstairs bedroom overlooking the wildlife out back on level 1. Separated by the large laundry room with ample storage, the downstairs office can be used as 5th bedroom and has it's own exterior door into the shop. Attached 2000 sq. ft. shop with three 14-ft doors on automatic openers, paved roads, insulated shop, additional covered parking outside the shop doors with hot water on outdoor water faucet, means your truck never has to be dirty again. Enjoy all of the benefits of peaceful country living without the mess. Efficient, stylish, and move-in ready! Furniture can be purchased. Additional land available from another seller not related to this sale.
MlsNumber: --
ListingId: 20795948


Listing Provided By: eXp Realty LLC, original listing
Phone: (214) 714-1704
Office Phone: (888) 519-7431
Agent Name: Rachel Craig
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