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

712 Walnut Street
Omaha, TX 75571

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $215,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2300
Agency: eXp Realty, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1972
Notes: PRICED REDUCED ON this exquisite and opulent residence in the charming town of Omaha, TX. This stunning home boasts 4 bedrooms and 2.5 bathrooms, offering unmatched luxury and comfort. This beauty already has blinds adorning the windows, large, designed rooms. The bonus room showcases Bluetooth can lights, allowing you to create the perfect ambiance for any occasion. With three expansive living spaces, this home opens up endless possibilities for entertaining and gathering with loved ones. The sizable privacy fence ensures tranquility and seclusion, providing a peaceful sanctuary to unwind and create lasting memories. The rear attached three-car covered parking, along with front side parking, offers convenience and ample space for vehicles. The tile and new remodel, complemented by fresh paint and flooring, elevate the aesthetic appeal of this abode. A workshop and shed has utilities, tool workshop, and shelves cater to the needs of the most discerning craftsmen. A new roof and water heater provide peace of mind and the assurance of a worry-free home. Rest easy knowing this property is entirely electric, optimizing efficiency and sustainability. Surrounded by a wealth of attractions, including the legendary Morris Twin Movie Theater, Daingerfield State Park, and the Heritage Museum, this residence epitomizes the perfect location. Venture to Eford Orchards, peruse The Hidden Flea Market, tantalize your taste buds at the Sweet Shop USA, or seek spiritual solace at Witness Park and Prayer Tower. For outdoor enthusiasts, indulge in the serene beauty of Decks and Parks or embark on adventures at Lake Bob Sandlin. The large bonus room and two spacious living areas invite harmonious living and provide ample space for loved ones to gather. Whether you desire a cozy den or an exhilarating game room, this home accommodates your every need. With its move-in ready condition, this property is a testament to meticulous care and attention to detail. The motivated seller invites you to seize this incredible opportunity for a life of utmost luxury and refinement. Don't miss the chance to call this exceptional residence your own.
MlsNumber: 20240093


Listing Provided By: eXp Realty, LLC, original listing
Name: eXp Realty, LLC
Phone: (888) 519-7431
Office Name: eXp Realty LLC
Office Phone: (888) 519-7431
Agent Name: Tegra Chism
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