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;

317 North Market Street
Flatonia, TX 78941

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $455,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1568
Agency: Legacy Land Associates

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2018
Notes: Welcome to this charming 3-bedroom, 2-bathroom home built in 2018. As you enter through the solid wood front door, you'll be greeted by an inviting open floor plan that seamlessly connects the living room, dining area, and kitchen. The layout creates a spacious and welcoming atmosphere.<br /> The kitchen is a highlight of the home, featuring a range of great amenities. The large center island serves as a focal point, providing ample workspace and serving as a gathering spot for family and friends. You'll love the beautiful granite countertops and the window above the kitchen sink offers a view of the private backyard. Additionally, a nice sized pantry ensures plenty of storage space.<br /> The master suite includes a spacious bathroom with a double vanity, a luxurious garden tub, and a separate walk-in shower. The countertops in the bathroom are crafted from cultured marble, combining durability with a touch of elegance. Completing the master suite is a convenient walk-in closet, providing ample storage for your wardrobe and belongings.<br /> The home's design emphasizes outdoor enjoyment and entertainment. The outdoor space is perfect for gatherings and offers plenty of room for seating and activities, extending the living area outdoors. The backyard itself features lush carpet grass, creating a vibrant and inviting outdoor space.<br /> On the exterior, the house features Hardie Plank siding, adding durability and a classic aesthetic. The composition roof ensures protection from the elements. A 2-car garage, situated at the side of the house, provides convenient parking and additional storage options. The backyard is fully enclosed by a 6-foot treated wood privacy fence, offering peace and seclusion. You'll also find a practical storage shed with a roll-up door, providing space for gardening tools, outdoor equipment, or any other belongings you wish to store. Don?t miss out, make an appointment to view this fabulous home.
MlsNumber: 142103


Listing Provided By: Legacy Land Associates, original listing
Name: Legacy Land Associates
Phone: (512) 776-1398
Office Name: Legacy Land Associates
Office Phone: (512) 776-1398
Agent Name: Hannah Mica
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