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

412 East Main Street
Fayetteville, TX 78940

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $336,000
Beds: 3
Baths: 3
Status: Active
SqFt: 1924
Agency: J Hill Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: OPEN HOUSE WEDNESDAY, APRIL 24TH, 11:00-1:00. JOIN US FOR LUNCH AND PREVIEW THIS CUTE, MONEY-MAKING PROPERTY!<br /> 2/1.5 cottage with 1+/1 apartment on a large corner lot next to the Fayetteville Park. You'll only have one neighbor! And it just a few blocks from historic Fayetteville town square where you'll find art exhibits, great restaurants, a historic hotel, and lovely shops. Plus, you're only 14 miles from Round Top--famous for the twice-yearly Antique Show as well as the high-end shops and eateries. The Century Live Oak that graces the front yard is said to be 500-700 years old and the oldest tree in Fayetteville! The main home has a lovely covered porch on two sides, with a side door entry through the mud room and the front door into the living area. The cozy living area is open to the dining area for a spacious feel with 9' ceilings and light wood floors. The large country kitchen has room for an island, plenty of counter space, a walk-in pantry, custom backsplash, and tile floors. You will delight in all the custom touches in this home: Roman window shades throughout, leaded glass windows above double-paned windows in living and dining area, custom trim above some doors, beadboard wainscoting, and crown molding. The apartment could be used for extended family, a mother-in-law space or for guests (including as a short-term rental for income). It has a completely separate front and back entrance, an ensuite bathroom, a combined living/kitchen/dining room, and another room that could be used as a bedroom, office, or whatever. Plus, there is a wooded deck off the back for outdoor dining or entertaining. You really must see this gem to appreciate it! Plus, just across the open wood deck on the back of the house, there are two separate workshop areas and a storage area for all your lawn equipment.
MlsNumber: 146078


Listing Provided By: J Hill Properties, original listing
Name: J Hill Properties
Phone: (979) 525-6630
Office Name: J Hill Properties
Office Phone: (979) 525-6630
Agent Name: Jane Hill
Disclaimer: Copyright © 2024 South Central Texas Board 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