Water Views - Eco Friendly
2203 Freedom Trail, Ingram, TX
$ 5,995,000
Property Attributes
  • MLS#1671554
  • TypeSingle Family
  • CountyKERR
  • CityIngram
  • Area3100
  • Zip78025
  • StyleTwo Story,Texas Hill Country
  • Year Built1997
  • Taxes$ 14555
  • Price$ 5,995,000
  • Bedrooms7
  • Full Bathrooms7
  • Half Bathrooms2
  • Sqr Footage6787
  • Lot Size124.44 Acres
Data Source:
© San Antonio Board of REALTORS®. ® All Rights Reserved
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.

Elementary School Middle School High School
Ingram Elementary School Ingram Middle School Ingram High School
Price History
3/6/2023 Listed $6,497,700
8/24/2023 8% - $5,995,000

General Features

Energy Efficiency Tankless Water Heater,Programmable Thermostat,Double Pane Windows,High Efficiency Water Heater,Storm Windows,Ceiling Fans
Construction Pre-Owned
Heating Central,Heat Pump,Panel,Zoned
Cooling Three+ Central,Zoned
Half Baths 2
Bathrooms 9
Subdivision None
Builder Ronnie Gesell
Class Single Residential
Type Single Family Detached
Green Features Rain Water Catchment
Style Two Story,Texas Hill Country
Roof Metal
HOA Mandatory None
Status Active
Neighborhood Amenities None
Home Faces North
Area 3100
Year Built 1997
High School Ingram
School District Ingram
Accessibility 2+ Access Exits,Int Door Opening 32 +,Ext Door Opening 36 +,36 inch or more wide halls,Flooring Modifications,Kitchen Modifications,No Carpet,Other Main Level Modifications,Level Drive,First Floor Ba
Proposed Terms Cash
Elementary School Ingram
Middle School Ingram
Legal Description See Documents
Taxes 14555.3

Interior Features

Kitchen Length 18
Kitchen Width 17
Total Bedrooms 7
Full Baths 7
Interior Features One Living Area,Separate Dining Room,Island Kitchen,Walk-In Pantry,Study/Library,Sauna,Utility Room Inside,1st Floor Lvl/No Steps,High Ceilings,Open Floor Plan,Skylights,Laundry Main Level,Laundry Ro
Stories 2
Dining Room Length 15
Dining Room Width 12
Flooring Ceramic Tile,Wood
Living Room Width 24
Heating Fuel Electric,Propane Owned
# of Fireplaces 2
Bedroom2 Width 14
Bedroom3 Length 14
Bedroom3 Width 14
Bedroom4 Length 15
Bedroom4 Width 14
Bedroom5 Length 15
Bedroom5 Width 13
Family Room Length 19
Living Room Length 33
Study/Office Length 13
Study/Office Width 10

Exterior Features

Exterior Stone/Rock,Siding
Foundation Slab
Pool (Y/N) Yes
Exterior Features Patio Slab,Covered Patio,Bar-B-Que Pit/Grill,Gas Grill,Deck/Balcony,Partial Sprinkler System,Storm Windows,Double Pane Windows,Storage Building/Shed,Has Gutters,Special Yard Lighting,Mature Trees,Hor
Pool In Ground Pool,Hot Tub,Pool is Heated
Lot Size 124.44
Water/Sewer Private Well,Septic
Lot Description County VIew,Water View,Horses Allowed,15 Acres Plus,Ag Exempt,Hunting Permitted,Partially Wooded,Mature Trees (ext feat),Secluded,Creek,Pond /Stock Tank
Inclusions Ceiling Fans,Chandelier,Washer Connection,Dryer Connection,Washer,Dryer,Built-In Oven,Microwave Oven,Stove/Range,Gas Cooking,Gas Grill,Refrigerator,Disposal,Dishwasher,Ice Maker Connection,Water Soft
Lot Improvements Asphalt,Private Road
Garage Parking Four or More Car Garage,Attached,Rear Entry,Side Entry,Oversized


  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Primary On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Property vs Single Family Average in 78025

AVG $1.45M
AVG $10,674
AVG 279
Data Provided by Inside Real Estate®
Year Built
AVG 1992

Looking for a more comfortable experience?

Download our mobile app for a personalized browsing experience.