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

395 Cr 470 Road
Chilton, TX 76632
Tiffanye Harrell with Coldwell Banker Apex, REALTORS, original listing - (254) 776-0000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 2
Baths: Full: 4
Status: Active
SqFt: 4869 Square Feet
Agency: Coldwell Banker Apex, REALTORS
Agency Phone: (254) 776-0000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Capture the beauty and tranquility of country living in this sculpted 2-bedroom, 4-bathroom luxury estate nestled on 10 lush acres in charming Chilton, TX. As an existing income-producing short-term rental during the summer months, it offers a unique investment opportunity. Each bedroom is genuinely a master suite. The first is nothing less than a personal retreat featuring a massive cedar walk-in closet, a sumptuous bathroom with a walk in tiled shower, a soaking tub with panoramic views, a convenient bidet, and a completed with a kitchenette. The second primary suite is equally comfortable, offering a sleek stand-up shower and a spacious double vanity. The upper level hosts a multifunctional loft featuring a personal bathroom and sleeping quarters setup for three – an ideal haven for additional guests. Both room compositions convey a chic aesthetic, easily adaptable to any purpose. The property gleams with add-ons, including two tankless hot water heaters, an indoor storm cellar, a hidden room, and a budding potential for a third floor construction. As a bonus, all kitchen appliances and mounted TVs convey, allowing you seamless transition into your new haven. Stepping outside, be prepared to have your breath taken away by the resort-style pool, complete with a fountain, soaking area and a separate bathroom for added convenience. The pool ranges from 3 feet to 5 feet in depth and also includes a heating function for those cooler days or nights. Adjacent to the pool, the outdoor kitchen creates an exceptional al fresco dining experience with its built-in fridge, sink, and storage. All pool furniture is included, allowing you to instantly enjoy this outdoor oasis. The surrounding acreage teems with vast potential and serene views. More land is available for purchase. A separate private driveway will soon complement this picturesque retreat, enhancing its private appeal. From its luxurious features to its investment potential, this unparalleled estate is where beauty and opportunity meet.
MlsNumber: --
ListingId: 225882


Listing Provided By: Coldwell Banker Apex, REALTORS, original listing
Phone: (254) 339-0865
Office Phone: (254) 776-0000
Agent Name: Tiffanye Harrell
Disclaimer: Copyright © 2024 Waco 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