Custom model home is for SALE! Locke & Headley Homes featuring this stunning new build nestled on just over 1 acre. The Slaton floor plan embodies true Southern Charm with its blend of modern farmhouse design and premium features. The welcoming wrap-around porch sets the tone, inviting family and friends to relax and enjoy. Inside, an open floor plan showcases elegant quartz countertops and a striking cabinet color combination, perfectly complementing the rich main-floor engineered hardwood floors. A private flex room/home office or formal dining room with barn doors is perfect for those that work from home, while the spacious primary suite offers a relaxing space with a luxurious bath, elegant tile shower and dual walk-in closet. The main-level utility room is easy access from the primary bedroom, featuring custom cabinetry for ample storage. Upstairs, three generous sized bedrooms and a bonus room provide flexible living space. The rear covered porch with a brick wood-burning fireplace is perfect for entertaining, offering scenic country views ideal for cozy fall evenings. Additional features include tankless water heater, TECHSHIELD radiant barrier to keep your energy costs down and finished off with an encapsulated crawlspace! Backed with a 1- yr warranty from the builder and a 5-yr outside warranty, you are sure to feel confident in the purchase of your new home. Conveniently located less than 3 miles to Saturn Parkway/I-65 and just 4 miles from Spring Hill Crossings, this property provides quick access to restaurants, retail, and groceries. Taxes are an estimate only. No HOA! Schedule your tour today! ***Ask about our current builder incentives!
Closed
$825,000
1510 Frye Rd Lot 10, Columbia, TN 38401
4beds
3,096sqft
Single Family Residence, Residential
Built in 2024
1.04 Acres Lot
$819,000 Zestimate®
$266/sqft
$3,573 Estimated rent
Home value
$819,000
$762,000 - $876,000
$3,573/mo
Zestimate® history
Owner options
List your home for rent
$3,573/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,573/mo
Rent Zestimate®
Refinance and save
$4,681/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$4,681/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Wrap-around porchWelcoming wrap-around porchLuxurious bathOpen floor planScenic country viewsStriking cabinet color combinationElegant tile shower
Zillow last checked:
Listing updated:
Listing Provided by:
Lisa Mays - The Mays Group 615-406-3067,
Keller Williams Realty
Bought with:
Greg Fritz, 338048
Onward Real Estate
Source: RealTracs MLS as distributed by MLS GRID,MLS#: 2993177
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
- Main level bedrooms: 1
Bedroom 4
- Area: 192 Square Feet
- Dimensions: 16x12
Primary bathroom
- Features: Double Vanity
- Level: Double Vanity
Dining room
- Features: Combination
- Level: Combination
Other
- Features: Office
- Level: Office
- Area: 156 Square Feet
- Dimensions: 12x13
Other
- Features: Utility Room
- Level: Utility Room
Recreation room
- Features: Other
- Level: Other
- Area: 506 Square Feet
- Dimensions: 22x23
Heating
- Heat Pump, Natural Gas
Cooling
- Central Air, Electric, Gas
Appliances
- Included: Dishwasher, Disposal, Dryer, ENERGY STAR Qualified Appliances, Microwave, Washer, Built-In Gas Oven, Cooktop
- Laundry: Electric Dryer Hookup, Washer Hookup
Features
- Ceiling Fan(s), Entrance Foyer, Open Floorplan, Pantry, Smart Thermostat, Walk-In Closet(s), High Speed Internet
- Flooring: Carpet, Wood, Tile
- Basement: None,Crawl Space
- Number of fireplaces: 1
- Fireplace features: Wood Burning
Interior area
- Total structure area: 3,096
- Total interior livable area: 3,096 sqft
- Finished area above ground: 3,096
Property
Parking
- Total spaces: 2
- Parking features: Garage Door Opener, Garage Faces Side, Concrete
- Garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio, Covered, Porch
- Exterior features: Smart Lock(s)
Lot
- Size: 1.04 Acres
- Features: Level
- Topography: Level
Details
- Parcel number: 052 01415 000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence, Residential
Materials
- Brick
- Roof: Shingle
Condition
- New construction: Yes
- Year built: 2024
Utilities & green energy
- Sewer: Septic Tank
- Water: Public
- Utilities for property: Electricity Available, Natural Gas Available, Water Available
Community & neighborhood
Location
- Region: Columbia
- Subdivision: Estates At Carter’s Station
Other
Other facts
- Available date: 12/15/2024
Price history
| Date | Event | Price |
|---|---|---|
| 3/19/2026 | Sold | $825,000$266/sqft |
Source:  RealTracs MLS as distributed by MLS GRID #2993177 Report a problem | ||
| 2/12/2026 | Pending sale | $825,000$266/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2993177 Report a problem | ||
| 2/2/2026 | Price change | $825,000-2.9%$266/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2993177 Report a problem | ||
| 12/31/2025 | Price change | $850,000-5.5%$275/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2993177 Report a problem | ||
| 10/28/2025 | Price change | $899,900-5.3%$291/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2993177 Report a problem | ||
| 9/11/2025 | Listed for sale | $950,000+8%$307/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2993177 Report a problem | ||
| 8/19/2025 | Listing removed | $879,900$284/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2769989 Report a problem | ||
| 8/5/2025 | Price change | $879,900-2.2%$284/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2769989 Report a problem | ||
| 3/20/2025 | Price change | $899,900-2.1%$291/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2769989 Report a problem | ||
| 2/21/2025 | Price change | $919,000-3.3%$297/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2769989 Report a problem | ||
| 12/17/2024 | Listed for sale | $949,900$307/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2769989 Report a problem | ||
| 12/8/2024 | Listing removed | $949,900$307/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2662767 Report a problem | ||
| 11/19/2024 | Price change | $949,900-4.8%$307/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2662767 Report a problem | ||
| 8/5/2024 | Price change | $997,785-0.2%$322/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2662767 Report a problem | ||
| 6/3/2024 | Listed for sale | $1,000,000$323/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2662767 Report a problem | ||
| 3/30/2024 | Listing removed | -- |
Source: RealTracs MLS as distributed by MLS GRID #2624063 Report a problem | ||
| 3/1/2024 | Price change | $1,000,000+0%$323/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2624063 Report a problem | ||
| 2/28/2024 | Listed for sale | $999,990$323/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2624063 Report a problem | ||
Public tax history
Tax history is unavailable.
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.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$819,000
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$819,000
- Tennessee
- Maury County
- Columbia
- 38401
- 1510 Frye Rd Lot 10
Nearby cities
Nearby zip codes
Other Columbia Topics
