1584 Frye Rd, Columbia, TN 38401

Local realty services provided by:CENTURY 21 Premier
1584 Frye Rd,Columbia, TN 38401
$950,000
  • 3 Beds
  • 4 Baths
  • 3,146 sq. ft.
  • Single family
  • Active
Listed by: jessica harrison
Office: zeitlin sotheby's international realty
MLS#:3224685
Source:NASHVILLE

Price summary

  • Price:$950,000
  • Price per sq. ft.:$301.97

About this home

CENTURY 21 Fine Homes & Estates
Custom-built by Locke and Headley Homes in The Estates of Carter’s Station, this thoughtfully designed home offers the kind of space, privacy, and flexibility that’s hard to find. Set on nearly two fully usable acres with peaceful treelined views, The Madison floor plan combines timeless finishes with everyday functionality, all just minutes from town. Spanning over 2,900 square feet, the home features 3 bedrooms, 3.5 baths, a spacious bonus room, and an additional flex space ideal for a home office, homeschool room, or guest space. Oversized bedrooms and multiple living areas make the layout comfortable for entertaining, working from home, or multigenerational living. Inside, you’ll find engineered hardwood floors, a gas fireplace, and an oversized 8.5-foot custom kitchen island designed to be the heart of the home. The main-level primary suite offers a peaceful retreat with a freestanding soaking tub, large tiled shower, and spacious walk-in closet. Step outside to the covered...

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an independent agent affiliated with the CENTURY 21®  brand to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an independent agent affiliated with the CENTURY 21®  brand is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , Coldwell Banker® , Corcoran® , ERA® , Sotheby's International Realty® ).
 I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:2025
  • Listing ID #:3224685
  • Added:1 day(s) ago
  • Updated:May 29, 2026 at 06:56 PM

Rooms and interior

  • Bedrooms:3
  • Total bathrooms:4
  • Full bathrooms:3
  • Half bathrooms:1
  • Flooring:Carpet, Tile
  • Kitchen Description:Dishwasher, Microwave, Oven
  • Basement:Yes
  • Basement Description:Crawl Space
  • Living area:3,146 sq. ft.

Heating and cooling

  • Cooling:Central Air, Electric
  • Heating:Central, Natural Gas
  • Central air:Yes

Structure and exterior

  • Year built:2025
  • Building area:3,146 sq. ft.
  • Lot area:1.99 Acres
  • Architectural Style:Traditional
  • Construction Materials:Brick, Fiber Cement
  • Exterior Features:Deck, Porch
  • Levels:2 Story

Schools

  • High school:Spring Hill High School
  • Middle school:Spring Hill Middle School
  • Elementary school:Spring Hill Elementary

Utilities

  • Water:Public, Water Available
  • Sewer:Septic Tank

Finances and disclosures

  • Price:$950,000
  • Price per sq. ft.:$301.97
  • Tax amount:$1,337

Features and amenities

  • Appliances:Dishwasher, Microwave
  • Amenities:ENERGY STAR Qualified Appliances, Walk-In Closet(s), appl_Oven

Parking

  • Total parking spaces:2
  • Garage:Yes
  • Garage spaces:2
MLS LogoCopyright 2026 Realtracs Mls. All rights reserved. Realtracs Mls provides content displayed here (“provided content”) on an “as is” basis and makes no representations or warranties regarding the provided content, including, but not limited to those of non-infringement, timeliness, accuracy, or completeness. Individuals and companies using information presented are responsible for verification and validation of information they utilize and present to their customers and clients. Realtracs Mls will not be liable for any damage or loss resulting from use of the provided content or the products available through Portals, IDX, VOW, and/or Syndication. Recipients of this information shall not resell, redistribute, reproduce, modify, or otherwise copy any portion thereof without the expressed written consent of Realtracs Mls. NASHVILLE Member Broker: Renee Hunter