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!
Why Columbia Tennessee?? Columbia, Tennessee is one of Middle Tennessee's true hidden gems—a thriving small town with rich history, rolling countryside, and a warm sense of community. Just south of Nashville, it offers the perfect blend of convenience and quiet living, where historic downtown streets, local restaurants, boutiques, and community events give it authentic charm. Outdoor lovers enjoy easy access to the Duck River, scenic parks, and acres of open farmland, while families appreciate strong schools, welcoming neighborhoods, and a slower, more intentional pace of life. Known as the “Mule Capital of the World,†Columbia embraces tradition while still experiencing vibrant growth, making it a place where heritage, opportunity, and lifestyle all come together. Whether you're drawn to its historic character, its beautiful rural landscapes, or its friendly people, Columbia truly feels like home.
Pending
$825,000
1510 Frye Rd Lot 10, Columbia, TN 38401
4beds
3,098sqft
Est.:
Single Family Residence
Built in ----
1.04 Acres Lot
$808,300 Zestimate®
$266/sqft
$-- HOA
What's special
- 114 days |
- 44 |
- 1 |
Zillow last checked: 7 hours ago
Listed by:
Lisa Mays,
Keller Williams Nashville - Spring Hill 615-302-4242
Source: REALSTACK,MLS#: 2993177
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Features
- Has basement: No
Interior area
- Total structure area: 3,098
- Total interior livable area: 3,098 sqft
Video & virtual tour
Property
Lot
- Size: 1.04 Acres
Details
- Parcel number: 052 01415 000
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Community & HOA
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $266/sqft
- Date on market: 11/25/2025
- Lease term: Contact For Details
Estimated market value
$808,300
$768,000 - $849,000
$3,404/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 3/19/2026 | Sold | $825,000$266/sqft |
Source: | ||
| 2/12/2026 | Pending sale | $825,000$266/sqft |
Source: | ||
| 2/2/2026 | Price change | $825,000-2.9%$266/sqft |
Source: | ||
| 12/31/2025 | Price change | $850,000-5.5%$274/sqft |
Source: | ||
| 10/28/2025 | Price change | $899,900-5.3%$290/sqft |
Source: | ||
| 9/11/2025 | Listed for sale | $950,000+8%$307/sqft |
Source: | ||
| 8/19/2025 | Listing removed | $879,900$284/sqft |
Source: | ||
| 8/5/2025 | Price change | $879,900-2.2%$284/sqft |
Source: | ||
| 3/20/2025 | Price change | $899,900-2.1%$290/sqft |
Source: | ||
| 2/21/2025 | Price change | $919,000-3.3%$297/sqft |
Source: | ||
| 12/17/2024 | Listed for sale | $949,900$307/sqft |
Source: | ||
| 12/8/2024 | Listing removed | $949,900$307/sqft |
Source: | ||
| 11/19/2024 | Price change | $949,900-4.8%$307/sqft |
Source: | ||
| 8/5/2024 | Price change | $997,785-0.2%$322/sqft |
Source: | ||
| 6/3/2024 | Listed for sale | $1,000,000$323/sqft |
Source: | ||
| 3/30/2024 | Listing removed | -- |
Source: | ||
| 3/1/2024 | Price change | $1,000,000+0%$323/sqft |
Source: | ||
| 2/28/2024 | Listed for sale | $999,990$323/sqft |
Source: | ||
Public tax history
Public tax history
Tax history is unavailable.BuyAbility℠ payment
Est. payment
$4,317/mo
Principal & interest
$4021
Property taxes
$296
More affordability tools
Climate risks
Neighborhood: 38401
Nearby schools
GreatSchools rating
- 6/10Spring Hill Middle SchoolGrades: 5-8Distance: 3.2 mi
- 4/10Spring Hill High SchoolGrades: 9-12Distance: 1.6 mi
- 6/10Spring Hill Elementary SchoolGrades: PK-4Distance: 4.8 mi
Local experts in 38401
- Tennessee
- Maury County
- Columbia
- 38401
- 1510 Frye Rd Lot 10





