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;

827 S Penn Street
Flatonia, TX 78941

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,500
Beds: 5
Baths: 4
Status: Active
SqFt: 4664
Agency: Holub Real Estate LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1984
Notes: Located on a beautiful one acre corner lot in Flatonia is this CUSTOM very spacious, 4,664 SF home with a dream of a floor plan and pristine landscaping boasting mature live oaks. Elevate your lifestyle in this meticulously maintained custom home while enjoying the small town life and still conveniently located halfway between Houston, San Antonio and Austin for all your city amenities.<br /> Designed by an architect, the floor plan showcases; 4 BRS, 4 BHs, study, office or 5th BR, a stunning foyer, large family great rm with soaring beamed vaulted ceilings, fireplace/built-ins and floor plugs, separate enormous game rm, wet bar ( wine rack, ref, glass shelving, sit down bar)accessible to great rm, dinning rm and game rm wall of built -ins in library nook. Kitchen has pass through window to great rm, island, walk in panty, breakfast area plus bar, double oven, hot water at sink. Wrapped red tile patio area has built in pit and smoker. Massive amount of custom storage, exterior lighting on timers, sprinkler system ( 2023 new control panel), 3 car garage and workshop adjourning the 3 bay garage. New interior plumbing 2023, 3 CA/CH units with 3 zones, 2 Hot water heaters, water softener, floored attic. Additional there is a workshop off the 3 garage bay.<br /> Perfect floor plan for home office work, large family or in-law space. Great value! No need to build, come see and bring your own decorating ideas to this impressive property.
MlsNumber: 530586


Listing Provided By: Holub Real Estate LLC, original listing
Name: Holub Real Estate LLC
Phone: (830) 221-5550
Office Name: Holub Real Estate, LLC
Office Phone: (830) 221-5550
Agent Name: Gary Holub
Disclaimer: Copyright © 2024 Central Texas Multiple Listing Service. 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