Skip main navigation
Closed
  • $1,095,000

    1506 Frye Rd LOT 11, Columbia, TN 38401

    4beds
    3,834sqft
    Single Family Residence, Residential
    Built in 2024
    1.8 Acres Lot
    $1,096,700 Zestimate®
    $286/sqft
    $3,742 Estimated rent

    Owner options

    List your home for rent

    $3,742/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

    $3,742/mo

    Rent Zestimate®

    Refinance and save

    $6,173/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,173/mo

    Est. payment

    What's special

    BUILDER OFFERING 2% OF SALES PRICE AS A BUYER CONCESSION! (Use towards cc/rate buy down!)Stunning new home 1.8 acres of prime seclusion! The custom-designed HOLLIS is ready for you, offering the epitome of TRUE SOUTHERN LIVING. Nestled on a private 1.8 AC lot, this home is conveniently located less than 4 miles from dining, groceries and shopping as well as an easy commute access to I-840 and I-65. Step onto the charming front veranda, perfect for entertaining, as French doors open into the formal dining room. The first-floor open concept design is stunning, anchored by a massive 9.5' island that will be the daily gathering place. The chef's kitchen features a gas cooktop, wall oven/microwave, and TWO pantries, one of the pantries being a scullery for extra storage and prep space. The kitchen is one to envy with stained cabinets, brushed-gold hardware, and quartz countertops, beautifully complemented by gorgeous hardwood floors throughout.The main-floor primary suite is a luxurious retreat with a spacious layout, a trey ceiling, and windows offering serene, private views. The spa-like ensuite bath includes an oversized 6x6 tiled shower, a freestanding tub, dual vanities, and a walk-in closet with custom built-ins.Upstairs, you’ll find a generous sized suite, a second ensuite bedroom perfect for guests, and a third bedroom conveniently located near the oversized bonus room. Outside, the secluded covered back porch and treed backyard create an idyllic setting for all gatherings. Don’t miss the incredible utility room! It boasts upper and lower cabinets, quartz countertops, and even a DOG washing station! Every detail has been meticulously planned and thoughtfully crafted. 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.

    Zillow last checked: 8 hours ago

    Listing updated: May 06, 2025 at 04:15pm

    Listing Provided by:

    Lisa Mays - The Mays Group 615-406-3067,

    Keller Williams Realty

    Bought with:

    Lisa Mays - The Mays Group, 325688

    Keller Williams Realty

    Source: RealTracs MLS as distributed by MLS GRID,MLS#: 2771406MLS 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: 12x13
    Bedroom 3
    • Features: Bath
    • Level: Bath
    • Area: 156 Square Feet
    • Dimensions: 12x13
    Bedroom 4
    • Features: Bath
    • Level: Bath
    • Area: 280 Square Feet
    • Dimensions: 20x14
    Bonus room
    • Features: Second Floor
    • Level: Second Floor
    • Area: 304 Square Feet
    • Dimensions: 19x16
    Dining room
    • Features: Combination
    • Level: Combination
    • Area: 195 Square Feet
    • Dimensions: 15x13
    Kitchen
    • Area: 195 Square Feet
    • Dimensions: 13x15
    Living room
    • Area: 418 Square Feet
    • Dimensions: 19x22
    Heating
    • Central, Electric
    Cooling
    • Central Air, Electric
    Appliances
    • Included: Dishwasher, Disposal, ENERGY STAR Qualified Appliances, Microwave, Built-In Gas Oven, Cooktop
    • Laundry: Electric Dryer Hookup, Washer Hookup
    Features
    • Built-in Features, Ceiling Fan(s), Entrance Foyer, Extra Closets, Open Floorplan, Pantry, Walk-In Closet(s), High Speed Internet, Kitchen Island
    • Flooring: Carpet, Wood, Tile
    • Basement: Crawl Space
    • Number of fireplaces: 1
    • Fireplace features: Family Room, Gas
    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
    • Patio & porch: Deck, Covered, Porch
    • Has view: Yes
    • View description: Valley
    Lot
    • Size: 1.80 Acres
    • Features: Level, Private
    Details
    • Parcel number: 052 01416 000
    • Special conditions: Standard

    Construction

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

    Utilities & green energy

    • Sewer: Septic Tank
    • Water: Public
    • Utilities for property: Water Available
    Green energy
    • Energy efficient items: Water Heater

    Community & neighborhood

    Security
    • Security features: Smoke Detector(s)
    Location
    • Region: Columbia
    • Subdivision: Estates Of Carter’s Station
    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,096,700