Stunning new home 1.62 acres! The custom-designed HOLLIS plan is ready for you, offering the epitome of TRUE SOUTHERN LIVING. Nestled on a 1.62 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. 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 an expansive amount of cabinets and quartz countertops, beautifully complemented by gorgeous engineered hardwood floors.The main-floor primary suite is a luxurious retreat with a spacious layout, a trey ceiling, and windows offering serene views of the treelined back yard. The spa-like ensuite bath includes an oversized 6x6 tiled shower, 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 covered back porch and treelined backyard create an idyllic setting for all gatherings. Don’t miss the incredible utility room! 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.
Active
$1,200,000
1576 Frye Rd LOT CS0003, Columbia, TN 38401
4beds
3,834sqft
Est.:
Single Family Residence, Residential
Built in 2025
1.62 Acres Lot
$-- Zestimate®
$313/sqft
$-- HOA
What's special
- 254 days |
- 144 |
- 6 |
Zillow last checked: 8 hours ago
Listing updated: December 17, 2025 at 09:02am
Listing Provided by:
Lisa Mays - The Mays Group 615-406-3067,
Keller Williams Realty 615-302-4242
Source: RealTracs MLS as distributed by MLS GRID,MLS#: 2820183
Tour with a local agent
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
Primary bathroom
- Features: Suite
- Level: Suite
Dining room
- Features: Combination
- Level: Combination
- Area: 195 Square Feet
- Dimensions: 15x13
Kitchen
- Area: 195 Square Feet
- Dimensions: 13x15
Living room
- Features: Great Room
- Level: Great Room
- Area: 418 Square Feet
- Dimensions: 19x22
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, Electric, Natural Gas
Cooling
- Central Air, Electric
Appliances
- Included: Built-In Electric Oven, Cooktop, Gas Range, Dishwasher, Disposal, ENERGY STAR Qualified Appliances, Microwave
- Laundry: Electric Dryer Hookup, Washer Hookup
Features
- Built-in Features, Ceiling Fan(s), Entrance Foyer, Extra Closets, High Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), High Speed Internet, Kitchen Island
- Flooring: Carpet, Wood, Tile
- Basement: None,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
Lot
- Size: 1.62 Acres
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
- Brick
- Roof: Shingle
Condition
- New construction: Yes
- Year built: 2025
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
- Security: Smoke Detector(s)
- Subdivision: Estates Of Carter’s Station
HOA
- Has HOA: No
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $313/sqft
- Annual tax amount: $4,400
- Date on market: 4/19/2025
- Date available: 11/25/2025
- Electric utility on property: Yes
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 10/30/2025 | Listed for sale | $1,200,000$313/sqft |
Source:  RealTracs MLS as distributed by MLS GRID #2820183 Report a problem | ||
| 9/12/2025 | Pending sale | $1,200,000$313/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2820183 Report a problem | ||
| 9/5/2025 | Price change | $1,200,000+9.1%$313/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2820183 Report a problem | ||
| 4/19/2025 | Pending sale | $1,100,310$287/sqft |
Source: RealTracs MLS as distributed by MLS GRID #2820183 Report a problem | ||
Public tax history
Public tax history
Tax history is unavailable.BuyAbility℠ payment
Est. payment
$5,483/mo
Principal & interest
$4653
Home insurance
$420
Property taxes
$410
Climate risks
Neighborhood: 38401
Nearby schools
GreatSchools rating
- 6/10Spring Hill Middle SchoolGrades: 5-8Distance: 3.1 mi
- 4/10Spring Hill High SchoolGrades: 9-12Distance: 1.6 mi
- 6/10Spring Hill Elementary SchoolGrades: PK-4Distance: 4.8 mi
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.
- Loading
- Loading
