Entertain in style. Unwind in luxury. From the dramatic foyer to the vaulted family room, this custom 5 bed, 4.5 bath stuns at every turn. The gourmet kitchen with walk-in pantry makes hosting effortless, while the covered patio with gas fireplace extends the party outside year-round. Retreat to the main-level primary suite with spa bath plus custom closet. Upstairs: four bedrooms, two en-suites and a huge bonus room for movie nights. This is one everyone will be talking about. Built by Black Sheep Custom Homes. Blacksheepcustomhomes@gmail.com
Under contract - showing
Price cut: $59.9K (7/29)
$1,140,000
1526 Frye Rd, Columbia, TN 38401
5beds
3,768sqft
Single Family Residence, Residential
Built in 2026
1.04 Acres Lot
$-- Zestimate®
$303/sqft
$-- HOA
What's special
Walk-in pantryVaulted family roomGourmet kitchenDramatic foyerCustom closet
- 42 days
- 104
- 3
Zillow last checked:
Listing updated:
Listed by:
Diane Wilhoit 615-587-1023,
Benchmark Realty, LLC 615-371-1544
Source: RealTracs MLS as distributed by MLS GRID,MLS#: 3223194
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
- Main level bedrooms: 1
Bedroom 1
- Features: Suite
- Level: Suite
- Area: 225 Square Feet
- Dimensions: 15x15
Bedroom 2
- Features: Bath
- Level: Bath
- Area: 168 Square Feet
- Dimensions: 14x12
Bedroom 3
- Features: Bath
- Level: Bath
- Area: 144 Square Feet
- Dimensions: 12x12
Bedroom 4
- Features: Extra Large Closet
- Level: Extra Large Closet
- Area: 132 Square Feet
- Dimensions: 12x11
Primary bathroom
- Features: Double Vanity
- Level: Double Vanity
Dining room
- Features: Combination
- Level: Combination
- Area: 140 Square Feet
- Dimensions: 14x10
Other
- Features: Other
- Level: Other
Kitchen
- Area: 304 Square Feet
- Dimensions: 19x16
Living room
- Features: Combination
- Level: Combination
- Area: 360 Square Feet
- Dimensions: 20x18
Other
- Features: Bedroom 5
- Level: Bedroom 5
- Area: 156 Square Feet
- Dimensions: 13x12
Other
- Features: Office
- Level: Office
- Area: 121 Square Feet
- Dimensions: 11x11
Recreation room
- Features: Second Floor
- Level: Second Floor
- Area: 285 Square Feet
- Dimensions: 19x15
Heating
- Central
Cooling
- Central Air
Appliances
- Included: Electric Oven, Gas Range, Dishwasher, Dryer, Ice Maker, Microwave, Refrigerator, Stainless Steel Appliance(s), Washer, Smart Appliance(s)
- Laundry: Electric Dryer Hookup, Washer Hookup
Features
- Bookcases, Built-in Features, Ceiling Fan(s), Entrance Foyer, Extra Closets, High Ceilings, Open Floorplan, Pantry, Kitchen Island
- Flooring: Wood, Luxury Vinyl, Tile
- Basement: Crawl Space
- Number of fireplaces: 2
- Fireplace features: Gas
Interior area
- Total structure area: 3,768
- Total interior livable area: 3,768 sqft
- Finished area above ground: 3,768
Property
Parking
- Total spaces: 2
- Parking features: Garage Faces Front
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
Lot
- Size: 1.04 Acres
Details
- Parcel number: 052 01411 000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence, Residential
Materials
- Brick
Condition
- New construction: Yes
- Year built: 2026
Utilities & green energy
- Sewer: Septic Tank
- Water: Public
- Utilities for property: Water Available
Community & HOA
Community
- Subdivision: Frye Road Subd
HOA
- Has HOA: No
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $303/sqft
- Tax assessed value: $50,800
- Annual tax amount: $243
- Date on market: 7/25/2026
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 8/5/2026 | Contingent | $1,140,000$303/sqft |
Source:  RealTracs MLS as distributed by MLS GRID #3223194 Report a problem | ||
| 7/29/2026 | Price change | $1,140,000-5%$303/sqft |
Source: RealTracs MLS as distributed by MLS GRID #3223194 Report a problem | ||
| 7/25/2026 | Listed for sale | $1,199,900$318/sqft |
Source: RealTracs MLS as distributed by MLS GRID #3223194 Report a problem | ||
| 7/19/2026 | Contingent | $1,199,900$318/sqft |
Source: RealTracs MLS as distributed by MLS GRID #3223194 Report a problem | ||
| 7/19/2026 | Pending sale | $1,199,900$318/sqft |
Source: RealTracs MLS as distributed by MLS GRID #3223194 Report a problem | ||
| 6/5/2026 | Listed for sale | $1,199,900+363.3%$318/sqft |
Source: RealTracs MLS as distributed by MLS GRID #3223194 Report a problem | ||
| 1/6/2025 | Sold | $259,000$69/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $243 | $12,700 |
| 2024 | $243 | $12,700 |
| 2023 | $243 | $12,700 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 38401
Nearby schools
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.
Similar homes
- $799,9994 bd3 ba3.2k sqft670 Northridge Rd, Columbia, TN 38401For Sale
MLS ID #3542428, Olivia Shaffer. RealTracs MLS as distributed by MLS GRID - $1,130,0004 bd5 ba3.7k sqft3000 Ora Ln, Spring Hill, TN 37174For Sale
MLS ID #3512990, Heidi Renee Waltz. RealTracs MLS as distributed by MLS GRID - $1,350,0004 bd4 ba3.4k sqft1495 Jacobs Rd, Columbia, TN 38401For Sale
MLS ID #3248682, Jenny Fann. RealTracs MLS as distributed by MLS GRID - $695,0003 bd3 ba2.5k sqft1412 Iron Bridge Rd, Columbia, TN 38401For Sale
MLS ID #3541455, Karen B. Thompson, REALTOR. RealTracs MLS as distributed by MLS GRID - $1,249,9004 bd5 ba3.5k sqft784 Mount Olivet Rd Lot 5A, Columbia, TN 38401New ConstructionMLS ID #3069667, Brandee Webster Ransom. RealTracs MLS as distributed by MLS GRID
- $1,197,9005 bd5 ba3.6k sqft6223 Cedar Brooke Ln Lot 12, Spring Hill, TN 37174New ConstructionMLS ID #3527423, Leigh Gillig. RealTracs MLS as distributed by MLS GRID
- $1,199,9994 bd4 ba3.7k sqft6220 Cedar Brooke Ln Lot 23, Spring Hill, TN 37174New ConstructionMLS ID #3515149, Leigh Gillig. RealTracs MLS as distributed by MLS GRID
- $1,125,0004 bd4 ba4.2k sqft6083 Kidman Ln, Spring Hill, TN 37174For SaleMLS ID #3509942, Pam Ford. RealTracs MLS as distributed by MLS GRID
- $1,089,9004 bd3 ba3.4k sqft6033 Cypress Creek Rd Lot 41, Spring Hill, TN 37174New ConstructionMLS ID #3499827, Leigh Gillig. RealTracs MLS as distributed by MLS GRID
- $587,9904 bd3 ba2.8k sqft3222 Gravity Dr Lot 49, Columbia, TN 38401New ConstructionRealTracs MLS as distributed by MLS GRID
- $599,9904 bd3 ba2.8k sqft835 Drivers Cir, Columbia, TN 38401New ConstructionRealTracs MLS as distributed by MLS GRID
- $1,350,0004 bd5 ba4.1k sqft1234 Polk Ln Lot 3, Columbia, TN 38401New ConstructionMLS ID #3278611, Ethan Lanagan. RealTracs MLS as distributed by MLS GRID
- $849,9004 bd4 ba3.6k sqft2114 Alpine Dr, Columbia, TN 38401For SaleMLS ID #3134001, Stephen Brown. RealTracs MLS as distributed by MLS GRID
- $1,499,9004 bd5 ba3.5k sqft780 Mount Olivet Rd Lot 4B, Columbia, TN 38401New ConstructionMLS ID #3186286, Brandee Webster Ransom. RealTracs MLS as distributed by MLS GRID
- $1,098,7504 bd4 ba3.1k sqft6227 Cedar Brooke Ln Lot 11, Spring Hill, TN 37174New ConstructionMLS ID #3180119, Leigh Gillig. RealTracs MLS as distributed by MLS GRID
- $594,7584 bd3 ba2.5k sqft1040 Bluestem Rd Lot 1042, Columbia, TN 38401New ConstructionRealTracs MLS as distributed by MLS GRID
- $1,299,9004 bd4 ba3.4k sqft1561 John Sharp Rd Lot 243, Spring Hill, TN 37174New ConstructionMLS ID #3133031, Sonya Sparkman. RealTracs MLS as distributed by MLS GRID
- $1,275,0003 bd3 ba2.9k sqft1779 Cayce Springs Rd, Thompsons Station, TN 37179For SaleMLS ID #3320401, Naomi Bannister. RealTracs MLS as distributed by MLS GRID
- $719,9004 bd4 ba3k sqft2744 Morrow Ln, Columbia, TN 38401For SaleMLS ID #3261174, Melissa Thomas Pyron. RealTracs MLS as distributed by MLS GRID
