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

1145 Castle Bluff Circle
Woodway, TX 76712

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,900
Beds: 4
Baths: 4
Status: Pending
SqFt: 3191
Agency: eXp Realty, LLC Waco

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2017
Notes: Welcome to this stunning 4-bedroom, 3.5-bathroom home nestled within the prestigious Midway ISD area, coveted for its acclaimed South Bosque Elementary School. Situated in a master-planned community, this meticulously crafted residence spans nearly 3200 square feet, boasting a plethora of amenities and custom features for unparalleled comfort and luxury living.<br /> <br /> As you step inside, you're greeted by a seamless blend of elegance and functionality. The home, in like-new condition and meticulously maintained, offers a welcoming ambiance throughout. Designed for modern living, the layout features both open-concept spaces and dedicated enclosed areas, providing versatility and convenience for every lifestyle need.<br /> <br /> The heart of the home is the gourmet kitchen, adorned with granite countertops and complemented by custom lighting features. Adjacent to the kitchen is the spacious living area, enhanced by an integrated surround sound system, perfect for entertaining or relaxing by the gas log fireplace.<br /> <br /> Retreat to the luxurious master suite, conveniently located on the back patio for a quick escape. Pamper yourself in the spa-like ensuite bathroom, complete with granite countertops and custom lighting. Three additional bedrooms offer ample space for family or guests, while the home's functional layout includes designated spaces for dining, office work, and recreation.<br /> <br /> Step outside to discover your own private oasis, with a heated pool, spa, fire pit, and water features, all overlooking the scenic golf course. The pool controls are fully automated for effortless operation, and weekly maintenance by licensed professionals ensures pristine conditions year-round.<br /> <br /> Additional features of this exceptional property include a fully landscaped yard, video monitoring for added security, spray foam attic insulation for energy efficiency, and custom floor coatings in the garage and patio. The home is thoughtfully designed to be carpet-free, ideal for allergy sufferers.<br /> <br /> Beyond the amenities within the home, residents of this community enjoy access to a wealth of recreational facilities, including a clubhouse, fitness center, walking trails, and a fishing pond. Community events foster a sense of belonging and camaraderie among neighbors.<br /> <br /> With a western view for beautiful sunsets and looking out on the 11th Hole, this residence epitomizes luxury living in a sought-after neighborhood that is thee cream of the crop! Don't miss the opportunity to make this exquisite property your new home sweet home. Schedule your private tour today and experience the epitome of Texas living at its finest.
MlsNumber: 222246


Listing Provided By: eXp Realty, LLC Waco, original listing
Name: eXp Realty, LLC Waco
Phone: (888) 519-7431
Office Name: eXp Realty, LLC Waco
Office Phone: (888) 519-7431
Agent Name: Andrew Fraijo
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.


Local Real Estate Expert

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 = 2682 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;
Real Estate Expert Photo for Glenda Hall
Glenda Hall
ASCIIUCRE Heart of Texas Land&Home
Call Today!: (254) 749-6307

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App