Skip To Content

2203 Freedom Trail

Ingram, TX 78025
  • $5,995,000
  • STATUS: Active
  • MLS #: 1671554
$5,995,000
  • 7
    BEDS
  • 124.44
    ACRES
  • 7
    BATHS
  • 2
    1/2 BATHS
  • 6,787
    SQFT
  • $883
    $/SQFT
Neighborhood:
Type:
Single-Family Home
Built:
1997
County:
Area:

School Information

Elementary School:
Middle School:
High School:
School District:

Description

This stunning 124-acre live water Texas ranch is one-of-a-kind featuring a 6787 SF custom home with 7 bedrooms, 7 baths, and 2 half baths. The main house was fully renovated in 2019 and a large addition was completed in 2021. A new roof was installed in 2022 for the entire house. It's the perfect place for large family gatherings and entertaining sitting at 1,990' elevation, boasting breathtaking 20+ mile views through full opening glass doors in the living room and from every room. It is just 10 mins to Kerrville. The property is completely high and cross-fenced with multiple additional potential home building sites. The property has both sides of Indian Creek with 3 dams with 1,500 ft of frontage and a live-spring stocked pond. The house has a large covered back patio and pool deck with outdoor TVs. Enjoy stunning sunsets, fishing, hunting, hiking, and even a gun range. The kitchen and other areas feature all Subzero, Wolf, and Cove appliances throughout the house and tankless water heaters for instant on hot water. The 6-car garage includes a room that can be used as an extra bedroom. The new addition with four ensuite bedrooms and a second laundry room can be closed off from the main part of the house for added privacy giving the potential for a multiple-bedroom bed and breakfast or corporate retreat. Other features include a heated pool, hot tub, gas firepit, 12-person Finnish dry sauna, gameroom with wetbar, exercise room, electric heated floors in the main house, indoor and outdoor sound system and an outdoor kitchen with a bbq grill, custom built wood-fired pizza oven, sinks, fridge and icemaker. The property also has a large custom-built greenhouse, a 60k gallon water catchment system, a large barn, and three other outbuildings. The lower acreage has a high fenced, irrigated orchard with pecan and fruit trees and an irrigated field for hay production and possibly your own vineyard. The property currently has an Ag Exemption. This unique Texas ranch is an opportunity not to be missed.

Monthly Payment Calculator



© 2024 San Antonio Board of REALTORS® All rights reserved. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or Absolute Charm Real Estate Group brokered by eXp Realty. Last updated 2024-04-19T09:18:19.84.
www.absolutecharmrealestate.net/homes/137492885
Print Image

2203 Freedom Trail Ingram, TX 78025

  • Price: $5,995,000
  • Status: Active
  • On Site: Days
  • MLS #: 1671554
7
Beds
7
Baths
2
½ Baths
124.44
Acres
6,787
SQFT
$883
$/SQFT
1997
Built
Neighborhood:
None
County:
Kerr
Area:
Ingram
Elementary School:
Ingram
Middle School:
Ingram
High School:
Ingram
School District:
Ingram
Property Description
This stunning 124-acre live water Texas ranch is one-of-a-kind featuring a 6787 SF custom home with 7 bedrooms, 7 baths, and 2 half baths. The main house was fully renovated in 2019 and a large addition was completed in 2021. A new roof was installed in 2022 for the entire house. It's the perfect place for large family gatherings and entertaining sitting at 1,990' elevation, boasting breathtaking 20+ mile views through full opening glass doors in the living room and from every room. It is just 10 mins to Kerrville. The property is completely high and cross-fenced with multiple additional potential home building sites. The property has both sides of Indian Creek with 3 dams with 1,500 ft of frontage and a live-spring stocked pond. The house has a large covered back patio and pool deck with outdoor TVs. Enjoy stunning sunsets, fishing, hunting, hiking, and even a gun range. The kitchen and other areas feature all Subzero, Wolf, and Cove appliances throughout the house and tankless water heaters for instant on hot water. The 6-car garage includes a room that can be used as an extra bedroom. The new addition with four ensuite bedrooms and a second laundry room can be closed off from the main part of the house for added privacy giving the potential for a multiple-bedroom bed and breakfast or corporate retreat. Other features include a heated pool, hot tub, gas firepit, 12-person Finnish dry sauna, gameroom with wetbar, exercise room, electric heated floors in the main house, indoor and outdoor sound system and an outdoor kitchen with a bbq grill, custom built wood-fired pizza oven, sinks, fridge and icemaker. The property also has a large custom-built greenhouse, a 60k gallon water catchment system, a large barn, and three other outbuildings. The lower acreage has a high fenced, irrigated orchard with pecan and fruit trees and an irrigated field for hay production and possibly your own vineyard. The property currently has an Ag Exemption. This unique Texas ranch is an opportunity not to be missed.
Exterior Features

Exterior Stone/RockSiding Exterior Features Patio SlabCovered PatioBar-B-Que Pit/GrillGas GrillDeck/BalconyPartial Sprinkler SystemStorm WindowsDouble Pane WindowsStorage Building/ShedHas GuttersSpecial Yard LightingMature TreesHorse Stalls/BarnWire FenceOutdoor KitchenOther - See Remarks Home Faces North Lot Description County VIewWater ViewHorses Allowed15 Acres PlusAg ExemptHunting PermittedPartially WoodedMature Trees (ext feat)SecludedCreekPond /Stock Tank Lot Improvements AsphaltPrivate Road Parking Four or More Car GarageAttachedRear EntrySide EntryOversized Pool Spa In Ground PoolHot TubPool is Heated Pool YN Yes Roof Metal Stories 2 Style Two StoryTexas Hill Country

Interior Features

Accessibility 2+ Access ExitsInt Door Opening 32"+Ext Door Opening 36"+36 inch or more wide hallsFlooring ModificationsKitchen ModificationsNo CarpetOther Main Level ModificationsLevel DriveFirst Floor BathFull Bath/Bed on 1st FlrFirst Floor BedroomStall ShowerWheelchair AccessibleWheelchair AdaptableWheelchair Modifications Air Conditioning Three+ CentralZoned Bedroom2 Length 14 Bedroom2 Width 14 Bedroom3 Length 14 Bedroom3 Width 14 Bedroom4 Length 15 Bedroom4 Width 14 Bedroom5 Length 15 Bedroom5 Width 13 Dining Room Length 15 Dining Room Width 12 Energy Efficiency Tankless Water HeaterProgrammable ThermostatDouble Pane WindowsHigh Efficiency Water HeaterStorm WindowsCeiling Fans Family Room Length 19 Family Room Width 14 Fireplace TwoLiving RoomPrimary BedroomGas Logs IncludedGasStone/Rock/Brick Fireplaces 2 Floor Ceramic TileWood Foundation Slab Heating CentralHeat PumpPanelZoned Heating Fuel ElectricPropane Owned Inclusions Ceiling FansChandelierWasher ConnectionDryer ConnectionWasherDryerBuilt-In OvenMicrowave OvenStove/RangeGas CookingGas GrillRefrigeratorDisposalDishwasherIce Maker ConnectionWater Softener (owned)Smoke AlarmSecurity System (Owned)Pre-Wired for SecurityElectric Water HeaterGarage Door OpenerSolid Counter TopsCustom CabinetsCarbon Monoxide DetectorPrivate Garbage Service Interior One Living AreaSeparate Dining RoomIsland KitchenWalk-In PantryStudy/LibrarySaunaUtility Room Inside1st Floor Lvl/No StepsHigh CeilingsOpen Floor PlanSkylightsLaundry Main LevelLaundry RoomWalk in ClosetsAttic - Access only Kitchen Length 18 Kitchen Width 17 Living Room Length 33 Living Room Width 24 Master Bath Tub/Shower SeparateDouble Vanity Master Bath Length 15 Master Bath Width 23 Master Bedroom DownStairsOutside AccessWalk-In ClosetFull Bath Master Bedroom Length 19 Master Bedroom Width 16 Other Rooms Bedroom 6BedroomOtherGarageStorageOtherAdditional Dwelling Study Office Length 13 Study Office Width 10 Window Coverings All Remain

Property Features

Approx Age 27 Builder Name Ronnie Gesell Certified Tax Year 2022 Construction Pre-Owned Currently Being Leased No Green Features Rain Water Catchment Hoa Mandatory None Neighborhood Amenities None Possession Closing/Funding Proposed Terms Cash Recent Rehab Yes Source Sq Ft Bldr Plans Subdivision Legal Name NONE Taxed By Multiple Counties No Total Tax 14555.3 Water Sewer Private WellSeptic

Listing information © 2024 San Antonio Board of REALTORS®.
Listing provided courtesy of David Hughes of eXp Realty: frontdesk@brokenarrowrealtygroup.com, (830) 383-2027.


© 2024 San Antonio Board of REALTORS® All rights reserved. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or Absolute Charm Real Estate Group brokered by eXp Realty. Last updated 2024-04-19T09:18:19.84.
 
https://bt-photos.global.ssl.fastly.net/sabor/orig_boomver_4_1671554-2.jpg https://bt-photos.global.ssl.fastly.net/sabor/orig_boomver_4_1671554-2.jpg https://bt-photos.global.ssl.fastly.net/sabor/orig_boomver_4_1671554-2.jpg
Logo
Absolute Charm Real Estate Group brokered by eXp Realty
709 West Main Street
Fredericksburg TX, 78624