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

1024 Spanish Trail
New Braunfels, TX 78132
Derrik Hammer with Hammer Real Estate Company, original listing - (817) 229-3405

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,495,000
Beds: 6
Baths: Full: 4, ½: 4
Status: Active
SqFt: 9220 Square Feet
Agency: Hammer Real Estate Company
Agency Phone: (817) 229-3405

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2010
Notes: A Slice of Hill Country Heaven in New Braunfels!<br /> <br /> Welcome to over 9,200 sq. ft. of pure Hill Country charm, nestled on 2+ acres of prime Texas land. From the moment you step through the Mediterranean-style courtyard, past the beautiful fountain, you’ll be blown away by this home's grand entrance and warm, inviting feel.<br /> <br /> Custom-built with Texas craftsmanship in mind, this home boasts mesquite wood floors, soaring cathedral ceilings, stunning marble mosaics, and rich wood accents. Huge Nanawalls seamlessly bring the outdoors in, and the Venetian plaster finishes add a touch of timeless elegance.<br /> <br /> Inside, you’ll find 3 spacious bedrooms on the main floor, a Jack-and-Jill setup upstairs, 4 full bathrooms, and 3 half baths. The owner’s suite feels like a luxury retreat, and the chef’s kitchen is built for gathering, featuring high-end finishes and plenty of space to cook up something special. Love to entertain? You’ll adore the custom wine room, home theater with Italian leather seating, and the full bar upstairs—complete with its own fridge and ice maker. There are also multiple offices, a safe room, a library, a craft room, and an oversized 4-car garage with A/C.<br /> <br /> But the real showstopper? Your very own backyard paradise. Whether you’re grilling in the outdoor kitchen, relaxing under the oversized covered patio, or unwinding in the heated pool and hot tub next to the waterfall and fire pit, there’s no better place to kick back. You even have your own putting green!<br /> <br /> And don’t forget the casita—designed with the same attention to detail as the main house. With 2 bedrooms, a full kitchen, living space, laundry room, and an attached 3-car garage, it’s perfect for guests or extended family.<br /> <br /> If you’re looking for a one-of-a-kind Texas estate that offers luxury, comfort, and plenty of space to enjoy the good life, you’ve just found it. Come on out and see for yourself—you won’t want to leave!
MlsNumber: --
ListingId: 569235


Listing Provided By: Hammer Real Estate Company, original listing
Phone: (817) 229-3405
Office Phone: (817) 229-3405
Agent Name: Derrik Hammer
Disclaimer: Copyright © 2025 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.


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 = 2567 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;
Melanie Esqueda
ASCIIAnders Pierce Realty
Call Today!: (830) 221-5688

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App