Custom-built home! Spanning over 2,900 sq. ft. on nearly 2 acres, this property offers exceptional privacy with a serene treelined view. Introducing The Madison, a masterpiece featuring 3 bedrooms, 3.5 baths, a spacious bonus room, and a separate flex room perfect for a home office or home school room! Designed with timeless elegance, stunning engineered hardwood floors, and an oversized 8.5 ft custom island. The primary suite is conveniently located on the main floor with separate shower and tub and spacious walk in closet. Enjoy the sunrise and a cup of coffee on the 14x16 covered deck. This home has premium features such as Jeld-Wen Energy-Star tilt-in windows, a tankless gas water heater, TECHSHIELD radiant barrier for energy efficiency, encapsulated crawlspace and so much more! Rest easy knowing your investment is backed by a 1-year builder warranty and a 5-year warranty through a third party company. Located less than 3 miles from Saturn Parkway/I-65 and just 4 miles from Spring Hill Crossings, you'll enjoy easy access to restaurants, shopping, and more. Schedule a tour of our model home today and envision your dream home come to life! Taxes are on the land only. Screened-in deck is an optional upgrade. ****PERMANENT 30-YR FIXED CONVENTIONAL LOAN at 4.990% (5.159% APR). Rates, terms & eligibility vary; not all qualify. OneTrust Home Loans is an EQUAL HOUSING LENDER, NMLS# 46375. Please see uploaded financing flyer for full financing details.
Active
$975,000
1584 Frye Rd LOT CS001, Columbia, TN 38401
3beds
2,905sqft
Est.:
Single Family Residence, Residential
Built in 2025
1.99 Acres Lot
$-- Zestimate®
$336/sqft
$-- HOA
What's special
Serene treelined viewCovered deckEngineered hardwood floorsSeparate shower and tub
- 109 days |
- 98 |
- 6 |
Zillow last checked: 8 hours ago
Listing updated: December 29, 2025 at 12:33pm
Listing Provided by:
Lisa Mays - The Mays Group 615-406-3067,
Keller Williams Realty 615-302-4242
Source: RealTracs MLS as distributed by MLS GRID,MLS#: 2993943
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
- Main level bedrooms: 1
Bedroom 1
- Features: Suite
- Level: Suite
- Area: 266 Square Feet
- Dimensions: 19x14
Bedroom 2
- Features: Bath
- Level: Bath
- Area: 255 Square Feet
- Dimensions: 17x15
Bedroom 3
- Features: Walk-In Closet(s)
- Level: Walk-In Closet(s)
- Area: 208 Square Feet
- Dimensions: 16x13
Primary bathroom
- Features: Double Vanity
- Level: Double Vanity
Kitchen
- Area: 357 Square Feet
- Dimensions: 21x17
Living room
- Features: Great Room
- Level: Great Room
- Area: 272 Square Feet
- Dimensions: 17x16
Other
- Features: Office
- Level: Office
- Area: 256 Square Feet
- Dimensions: 16x16
Other
- Features: Utility Room
- Level: Utility Room
- Area: 56 Square Feet
- Dimensions: 8x7
Recreation room
- Features: Second Floor
- Level: Second Floor
- Area: 323 Square Feet
- Dimensions: 19x17
Heating
- Central, Natural Gas
Cooling
- Central Air, Electric
Appliances
- Included: Electric Oven, Cooktop, Gas Range, Dishwasher, Disposal, ENERGY STAR Qualified Appliances, Microwave, Stainless Steel Appliance(s)
- Laundry: Electric Dryer Hookup, Washer Hookup
Features
- Open Floorplan, Pantry, Walk-In Closet(s), High Speed Internet, Kitchen Island
- Flooring: Carpet, Wood, Tile
- Basement: None,Crawl Space
- Number of fireplaces: 1
- Fireplace features: Family Room, Gas
Interior area
- Total structure area: 2,905
- Total interior livable area: 2,905 sqft
- Finished area above ground: 2,905
Property
Parking
- Total spaces: 2
- Parking features: Garage Door Opener, Attached
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Covered, Porch
- Exterior features: Smart Lock(s)
Lot
- Size: 1.99 Acres
Details
- Parcel number: 052 01400 000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence, Residential
Materials
- Fiber Cement, Brick
- Roof: Shingle
Condition
- New construction: Yes
- Year built: 2025
Utilities & green energy
- Sewer: Septic Tank
- Water: Public
- Utilities for property: Electricity Available, Natural Gas Available, Water Available
Green energy
- Energy efficient items: Water Heater, Windows, Thermostat
Community & HOA
Community
- Security: Smoke Detector(s)
- Subdivision: Estates Of Carter's Station
HOA
- Has HOA: No
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $336/sqft
- Annual tax amount: $329
- Date on market: 9/13/2025
- Date available: 09/30/2025
- Electric utility on property: Yes
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 9/13/2025 | Listed for sale | $975,000+9.9%$336/sqft |
Source:  RealTracs MLS as distributed by MLS GRID #2993943 Report a problem | ||
| 9/4/2025 | Listing removed | $887,385$305/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2772393 Report a problem | ||
| 4/25/2025 | Price change | $887,385+4.4%$305/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2772393 Report a problem | ||
| 12/28/2024 | Listed for sale | $850,000$293/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2772393 Report a problem | ||
| 12/8/2024 | Listing removed | $850,000$293/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2680245 Report a problem | ||
Public tax history
Public tax history
Tax history is unavailable.BuyAbility℠ payment
Est. payment
$5,319/mo
Principal & interest
$4645
Home insurance
$341
Property taxes
$333
Climate risks
Neighborhood: 38401
Nearby schools
GreatSchools rating
- 6/10Spring Hill Middle SchoolGrades: 5-8Distance: 3.1 mi
- 4/10Spring Hill High SchoolGrades: 9-12Distance: 1.6 mi
- 6/10Spring Hill Elementary SchoolGrades: PK-4Distance: 4.8 mi
Schools provided by the listing agent
- Elementary: Spring Hill Elementary
- Middle: Spring Hill Middle School
- High: Spring Hill High School
Source: RealTracs MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- Loading
- Loading
