Skip main navigation
Closed
  • $1,115,000

    1576 Frye Rd Lot 3, Columbia, TN 38401

    4beds
    3,834sqft
    Single Family Residence, Residential
    Built in 2026
    1.62 Acres Lot
    $1,115,000 Zestimate®
    $291/sqft
    $4,248 Estimated rent

    Home value

    $1,115,000

    $1.06M - $1.17M

    $4,248/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,248/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,248/mo

    Rent Zestimate®

    Refinance and save

    $6,473/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $6,473/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 started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Dedicated scullery pantryGreat roomOpen-concept layoutVersatile bonus roomGenerously appointed guest suitesQuartz surfacesSpacious custom closet
    Crafted by award-winning Locke & Headley Homes, The Hollis at Estates of Carter's Station seamlessly blends refined design, exceptional craftsmanship, and the tranquility of Tennessee countryside living. Set on 1.62 private acres, this thoughtfully designed residence offers 3,834 square feet with 4 bedrooms, 4.5 baths, and a 3-car side-entry garage. Designed for both everyday comfort and effortless entertaining, the heart of the home is a beautifully appointed chef's kitchen featuring a striking 9.5-foot island, premium appliances, quartz surfaces, abundant custom cabinetry, and a dedicated scullery pantry. The open-concept layout flows seamlessly into the great room and covered outdoor living area, creating inviting spaces for gathering while enjoying peaceful views of the surrounding landscape. The main-level owner's retreat provides a luxurious escape, complete with a spa-inspired bath, oversized walk-in shower, dual vanities, and a spacious custom closet. Upstairs, generously appointed guest suites and a versatile bonus room offer flexibility for hosting family and friends, working from home, or creating the lifestyle spaces that matter most. Every detail reflects Locke & Headley's commitment to enduring quality and thoughtful execution. Ideally situated within Estates of Carter's Station, this exceptional property offers the rare opportunity to enjoy estate-style living with the convenience of Columbia, Franklin, and Nashville just beyond your doorstep. Welcome home to The Hollis.

    Zillow last checked:

    Listing updated:

    Listed by:

    Jessica Harrison 714-815-0078,

    Zeitlin Sotheby's International Realty

    Bought with:

    Kitt Pupel, 273238

    LuxSmart Realty

    Source: RealTracs MLS as distributed by MLS GRID,MLS#: 3243721MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    • Main level bedrooms: 1
    Bedroom 1
    • Features: Suite
    • Level: Suite
    • Area: 300 Square Feet
    • Dimensions: 20x15
    Bedroom 2
    • Features: Walk-In Closet(s)
    • Level: Walk-In Closet(s)
    • Area: 156 Square Feet
    • Dimensions: 13x12
    Bedroom 3
    • Features: Bath
    • Level: Bath
    • Area: 156 Square Feet
    • Dimensions: 13x12
    Bedroom 4
    • Features: Bath
    • Level: Bath
    • Area: 280 Square Feet
    • Dimensions: 20x14
    Primary bathroom
    • Features: Suite
    • Level: Suite
    Dining room
    • Features: Combination
    • Level: Combination
    • Area: 195 Square Feet
    • Dimensions: 15x13
    Kitchen
    • Area: 195 Square Feet
    • Dimensions: 15x13
    Living room
    • Features: Great Room
    • Level: Great Room
    • Area: 418 Square Feet
    • Dimensions: 22x19
    Other
    • Features: Breakfast Room
    • Level: Breakfast Room
    • Area: 169 Square Feet
    • Dimensions: 13x13
    Other
    • Features: Utility Room
    • Level: Utility Room
    • Area: 160 Square Feet
    • Dimensions: 16x10
    Recreation room
    • Features: Second Floor
    • Level: Second Floor
    • Area: 304 Square Feet
    • Dimensions: 19x16
    Heating
    • Central, Natural Gas
    Cooling
    • Central Air, Electric
    Appliances
    • Included: Built-In Electric Oven, Gas Range, Dishwasher, Disposal, ENERGY STAR Qualified Appliances, Microwave
    Features
    • Built-in Features, Ceiling Fan(s), Entrance Foyer, Extra Closets, High Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island
    • Flooring: Wood, Tile
    • Basement: None
    Interior area
    • Total structure area: 3,834
    • Total interior livable area: 3,834 sqft
    • Finished area above ground: 3,834

    Property

    Parking
    • Total spaces: 3
    • Parking features: Garage Door Opener, Garage Faces Side
    • Garage spaces: 3
    Features
    • Levels: Two
    • Stories: 2
    Lot
    • Size: 1.62 Acres
    Details
    • Parcel number: 052 01408 000
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence, Residential
    Materials
    • Brick, Fiber Cement
    Condition
    • New construction: Yes
    • Year built: 2026

    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

    Community & HOA

    Community
    • Subdivision: Frye Road Subd
    HOA
    • Has HOA: No
    Location
    • Region: Columbia

    Financial & listing details

    • Price per square foot: $291/sqft
    • Annual tax amount: $295
    • Date on market: 6/16/2026
    • Electric utility on property: Yes

    Price history

    DateEventPrice
    8/7/2026Sold$1,115,000-1.3%$291/sqft
    Source: RealTracs MLS as distributed by MLS GRID #3243721 Report a problem
    7/21/2026Contingent$1,129,999$295/sqft
    Source: RealTracs MLS as distributed by MLS GRID #3243721 Report a problem
    7/7/2026Price change$1,129,999-1.7%$295/sqft
    Source: RealTracs MLS as distributed by MLS GRID #3243721 Report a problem
    6/16/2026Listed for sale$1,150,000$300/sqft
    Source: RealTracs MLS as distributed by MLS GRID #3243721 Report a problem

    Public tax history

    Tax history is unavailable.

    Neighborhood: 38401

    Nearby schools

    GreatSchools rating
    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
    $1,115,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
    $1,115,000