Listing Courtesy of: 6154063067 - Lisa Mays - Keller Williams Realty 615-302-4242
$1,145,257 affordable loan icon Calculate Payment

1506 Frye Rd Columbia, TN 38401

Down payment assistance icon
Single Family Residence
4 Beds
5 Baths
3,834 Sq. Ft.
1.8 Acre Lot
Save
Share

Open House Schedule

  • Sat, 1/04, 11:00 AM-04:00 PM
  • Sun, 1/05, 12:00 PM-04:00 PM

Property Activity

Time on Site
days
Days on Market
Views
Saves
Last updated on 1/3/2025 12:43 PM

Listing Details

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-acre 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 Butler's pantry 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. Continue reading
MLS#
2771406
Property Type
Single Family
Bedrooms
4
Bathrooms
4 Full/1 Half
Year Built
2024
Square Feet
3,834 sq. ft
Lot Size
1.8
Stories
2.0
Sewer
Holding Tank
See more listing details   See less listing details  

Receive an email as soon as the price changes

Receive an email

as soon as the price changes
Get Price Alerts
price alerts icon

Get Price Alerts

Don't miss your chance. Receive an email as soon as the price changes.

Notify Me

Get email alerts when
a home price changes

Sign up
view of kitchen

My Drive Time

Enter your work address to view actual drive times with traffic for this property.

Calculate & Save
 

Calculating ...
Here is the weekday INRIX Drive Time from this property to . Change Address

Walk Score

Walk Score measures the walkability of any address, Transit Score measures access to public transit on a scale of 1-100.

View More   View Less  
Source: Walk Score®

Mortgage Calculator

How much home can I afford?

Get prequalified today and learn more.

Get Started

Rental Valuation Estimate

rental value icon
Per Month
See More Trends
Listing Courtesy of: 6154063067 - Lisa Mays - Keller Williams Realty 615-302-4242

Andrea D. Conner, License 344441, Xome Inc., License 262361, [email protected], 844-400-XOME (9663), 751 Highway 121 Bypass, Suite 100, Lewisville, Texas 75067

Listings courtesy of RealTracs MLS as distributed by MLS GRID, based on information submitted to the MLS GRID as of 1/3/2025.. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the “DMCA”) provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to [email protected]. The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner’s behalf. Failure t

This content last refreshed on 1/3/2025 12:43 PM. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Information is deemed reliable but is not guaranteed.
Prequalify