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 = 2765 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 2765 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 2765 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;

2009 Indian Street
Vernon, TX 76384

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $165,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1381
Agency: DAVIS VERNON AGENCY, INC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1950
Notes: Welcome to 2009 Indian St., a charming and completely remodeled home in the heart of Vernon, Texas. This 1,381 square foot property offers the perfect blend of modern amenities and classic craftsmanship. As you step inside, you'll be greeted by beautifully restored original hardwood floors that exude timeless elegance and warmth. Stay comfortable year-round with the brand-new central heating and air conditioning system that ensures your comfort in any season. Enjoy energy efficiency and plenty of natural light with all-new windows that not only enhance the aesthetics of the home but also help you save on energy bills. The entire home boasts all-new lighting fixtures, creating a bright and inviting atmosphere in every room. Stay cool during the summer and improve air circulation with new ceiling fans installed throughout the house. The spacious master bedroom comes with an ensuite bathroom and his and her walk-in closets, providing a private sanctuary for relaxation. The kitchen and bathrooms feature new shower tiling, adding a touch of modern luxury to these essential spaces. The interior has been tastefully painted with beautiful and modern colors that complement the hardwood floors and natural light. All doors have been replaced with brand new ones, and modern hardware enhances the overall aesthetics. This meticulously remodeled home combines classic charm with modern convenience, making it the perfect place to call your own. Outside, enjoy a brand-new privacy fence with concrete footer and a concrete sidewalk that leads from the street to the front porch. All appliances are brand new and will be included with the home! Don't miss the opportunity to make 2009 Indian St. your new home in Vernon, Texas.
MlsNumber: 11255580


Listing Provided By: DAVIS VERNON AGENCY, INC, original listing
Name: DAVIS VERNON AGENCY, INC
Office Name: DAVIS VERNON AGENCY, INC
Office Phone: (940) 552-0500
Agent Name: Sally Curtis
Disclaimer: Copyright © 2024 My State MLS. 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