x
Showing 1 of 0
Save

404 Saint Andrews Drive
New Ulm TX 78950 US

$930,000

Active Listing ID 80551374
bed icon
3 bed
bath icon
2.00 Bath (2 Full)
lot icon
Lot: 0.53 Acres
home icon
Single Family Residence

$930,000

Active Listing ID 80551374
Save

404 Saint Andrews Drive Discover luxury in this 2, 540 sq. ft. limestone masterpiece, fully remodeled in 2021-2022, in "The Falls, " a gated community with a Championship Golf Course & Resort, 45 minutes from Katy. This 3 bed, 2 bath, 3 car garage home blends comfort & refined entertaining. The open concept living flows from the elegant living room into the gourmet island kitchen, featuring custom cabinetry, quartz counters & top-of-the-line KitchenAid appliances. The extraordinary primary suite offers a spa-like bathroom with a jetted hydro spa tub, multiple showerheads, and a custom walk-in closet. Two guest bedrooms feature crown molding, plantation shutters & wood-look tile floors. Outside, a screened patio leads to a heated gunite pool with iAquaLink automation, sun deck & stools, plus an outdoor kitchen with professional-grade appliances. Other features include a gas firepit, climate controlled attic room, epoxy garage floors & a full security system. See attached write up & 2 pics are digitally staged!

Collapse all

Property Features

  • Facts
  • Lot Size: 0.53 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 2
  • Cooling System: Zoned A/C
  • Exterior Finish: Covered Patio, Deck, Fence, Sprinkler Irrigation, Outdoor Kitchen, Porch, Patio, Storage
  • Floor Covering: Tile
  • Roof Type: Metal
  • Heating Fuels: Central Furnace, Zoned
  • Additional Features
  • Patio

School Information

  • School
  • COLUMBUS ELEMENTARY SCHOOL(Elementary)
  • COLUMBUS JUNIOR HIGH SCHOOL(MiddleSchool)
  • COLUMBUS HIGH SCHOOL(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 930000
  • unparsedaddress: 404 Saint Andrews Drive
  • postalcity: New Ulm
  • stateorprovince: TX
  • country: US
  • postalcode: 78950
  • bathroomsfull: 2
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.53
  • lotsizeunits: Acres
  • lotsizearea: 0.53
  • livingarea: 2540
  • livingareaunits: Square Feet
  • latitude: 29.853472
  • longitude: -96.506292
  • listagentfullname: Nicola Hammett
  • listagentemail: nicolahammett1@gmail.com
  • listagentkey: 3yd-HARMLSTX-HAMMETTN
  • listagentmlsid: HAMMETTN
  • listagentpreferredphone: 9797334594
  • listagentofficephone: 9797338200
  • listofficekey: 3yd-HARMLSTX-LSLR01
  • listagentstatelicense: 0407363
  • listofficemlsid: LSLR01
  • disclaimer: Copyright © 2025 Houston Realtors Information Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: HARMLSTX
  • yearbuilt: 2009
  • listingcontractdate: 2024-10-15
  • countyorparish: Colorado
  • parcelnumber: 18943
  • elementaryschool: COLUMBUS ELEMENTARY SCHOOL
  • highschool: COLUMBUS HIGH SCHOOL
  • elementaryschooldistrict: 188 - Columbus
  • middleorjuniorschooldistrict: 188 - Columbus
  • highschooldistrict: 188 - Columbus
  • appliances: Dishwasher, Garbage Disposer, Ice Maker, Microwave, Oven, Range, Washer
  • cooling: Zoned A/C
  • constructionmaterials: Cement Siding, Stone
  • flooring: Tile
  • heating: Central Furnace, Zoned
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • parkingfeatures: Driveway, Garage
  • roof: Metal
  • waterfrontyn: False
  • interiorfeatures: Breakfast Bar, Crown Molding, Double Vanity, Entrance Foyer, High Ceilings, Jetted Tub, Kitchen Island, Kitchen Family Room Combo, Pantry, Quartz Counters, Self Closing Cabinet Doors, Self Closing Drawers, Soaking Tub, Separate Shower, Walk In Pantry, Ceiling Fans, Kitchen Dining Combo, Living Dining Room, Programmable Thermostat
  • exteriorfeatures: Covered Patio, Deck, Fence, Sprinkler Irrigation, Outdoor Kitchen, Porch, Patio, Storage
  • architecturalstyle: New Traditional
  • rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Bonus Room, Dining Room, Kitchen, Living Room, Utility Room
  • otherstructures: Outdoor Kitchen, Storage
  • patioandporchfeatures: Patio, Porch, Deck
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • fencing: Fenced
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -96.506294, 29.853472
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Lone Star Luxe Real Estate, LLC", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[{"ExpenseCategory":"Home Owner Assessments Fee", "ExpenseFrequency":"Annually", "ExpenseValue":100}], "GeocodeOptions":null, "LeadRoutingEmail":"nicolahammett1@gmail.com", "ListBrokerageCity":"Columbus", "ListBrokerageCountry":"US", "ListBrokerageEmail":"lonestarluxerealestate@gmail.com", "ListBrokerageLogoUrl":null, "ListBrokerageName":"Lone Star Luxe Real Estate, LLC", "ListBrokeragePhone":"979-733-8200", "ListBrokeragePostalCode":null, "ListBrokerageStateOrProvince":"TX", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"930 Walnut Street", "ListBrokerageWebsiteUrl":null, "ListOfficeAddress1":"930 Walnut Street", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":null, "ListOfficeCity":"Columbus", "ListOfficeCountry":"US", "ListOfficeEmail":"lonestarluxerealestate@gmail.com", "ListOfficePostalCode":"78934", "ListOfficeStateOrProvince":"TX", "ListPriceCurrencyType":"USD", "ListingTitle":"Traditional, Detached - New Ulm, TX", "ListingURL":"https://listings.listhub.net/pages/HARMLSTX/80551374/?channel=rexren", "MLSModificationTimestamp":"2024-10-16T03:04:03Z", "Neighborhoods":[], "PostalCode":null, "RawPropertySubType":"Detached", "RawPropertyType":"Residential", "RoomCount":10, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":9115, "TaxDescription":null, "TaxYear":"2024"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 1/15/2025 12:23:31 AM GMT
Source Updated Date: 2/25/2025 6:44:45 AM GMT

Courtesy of: Nicola Hammett, Lone Star Luxe Real Estate, LLC, nicolahammett1@gmail.com

Copyright © 2025 Houston Realtors Information Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.