1506 Frye Rd, Columbia, Tennessee 38401

TN, Columbia
$1,145,257 ↓ $1,145,990
  • Canceled Status
  • 347 Days Off Market Sorry Charlie 🙁
  • Residential Property Type
  • 4 Beds Total Bedrooms
  • 5 Baths Full + Half Bathrooms
  • 3834 Total Sqft $299/sqft
  • 2024 Year Built
  • Mortgage Wizard 3000 Advanced Breakdown

Questions? Connect With Us!

Ask the Cribz folks! No account? Sign up here.
Property Description

What a way to start the new year right! 1.8! Acres of prime seclusion! Come visit as the Custom designed HOLLIS is almost ready for you! It’s TRUE SOUTHERN LIVING at it’s finest! Secluded on 1.8 Acres & conveniently located less than 4 mi to SH Crossings for restaurants & retail! Your Front Veranda will be the hot spot while hosting as French Doors open to Formal DR! Fabulous OPEN 1st FLOOR DESIGN & the 9.5′ Island draws in the crowd! Chef’s Kitchen boasts Gas Cooktop, Wall-Oven/Microwave & 2 PANTRIES! One of them an Ole-South SCULLERY! Gorgeous Hardwoods, Stained Kit Cabs w/ brush-gold hardware w/ QUARTZ through-out the house! Main-Floor Primary is a retreat in itself with it’s massive size, gorgeous trey ceiling and the Wall-2-Wall Windows offering a peaceful & private view. The show-stopping Bath boasts a 6×6 Tiled Shower, FREESTANDING TUB, Separate Vanities & W-I-C w/ Custom Built-Ins covering your storage needs! Upstairs find a HUGE PRINCESS ENSUITE, BR 3 Ensuite is perfect for guests, and BR 4 is just off the Oversized Bonus Rm! Secluded Covered Back Porch & Treed backyard view begs for fall gatherings! Oh.. can’t forget about the DOG WASHING STATION in the incredible Utility Room that has upper/Lower cabinets as well as quartz!

Property Details
  • Property Type: Residential
  • Listing Type: For Sale
  • MLS #: 2665108
  • Price: $1,145,257
  • View: Valley
  • Half Bathrooms: 1
  • Full Bathrooms: 4
  • Square Footage: 3,834 Sqft
  • Year Built: 2024
  • Lot Area: 1.80 Acre
  • Office Name: Parks Compass
  • Agent Name: Jackie Moye
  • New Construction: Yes
  • Property Sub Type: Single Family Residence
  • Roof: Shingle
  • Listing Status: Canceled
Location Info
  • Street Number: 1506
  • Street: Frye Rd
  • City Columbia
  • State TN
  • Zipcode 38401
  • County Maury County, TN
  • Subdivision The Estates of Carter's Station
  • Longitude: W87° 0' 10.6''
  • Latitude: N35° 42' 3.9''
  • Directions: From Franklin - I-65 South to Saturn / GM Parkway to HWY 31 SOUTH. Exit towards Columbia, Frye Road will be on your right!
Features
  • Heating System Central, Natural Gas, Forced Air, Zoned
  • Cooling System Central Air, Electric
  • Basement Crawl Space
  • Fireplace Gas, Family Room
  • Patio Porch, Covered Porch
  • Parking Driveway, Concrete, Gravel, Attached - Side
  • Utilities Electricity Available, Water Available
  • Architectural Style Traditional
  • Exterior Features Garage Door Opener, Smart Lock(s)
  • Fireplaces Total 1
  • Flooring Carpet, Tile, Finished Wood
  • Interior Features Open Floorplan, Walk-In Closet(s), Primary Bedroom Main Floor, High Ceilings, Built-in Features, Kitchen Island, Pantry, Ceiling Fan(s), Extra Closets, Entry Foyer
  • Laundry Features Electric Dryer Hookup, Washer Hookup
  • Sewer Private Sewer
Appliances
  • Dishwasher
  • Microwave
  • Disposal
  • ENERGY STAR Qualified Appliances
Schools
  • Elementary School: Spring Hill Elementary
  • Middle School: Spring Hill Middle School
  • High School: Spring Hill High School
Additional Info
  • Water Source: Public
  • Building Size: 3,834 Sqft
  • Construction Materials: Brick, Fiber Cement
  • Garage: 3 Spaces
  • Levels: Two
  • Lot Features: Level, Private
  • On Market Date: June 8th, 2024
  • Previous Price: $1,145,990
  • Stories: 2
Financial
  • Annual Tax Amount: $4,400
Listing Data
  • Mls Status: Canceled
  • Originating System Name: RealTracs
  • Special Listing Conditions: Standard
  • Modification Timestamp: Dec 9th, 2024 @ 11:31pm
  • Status Change Timestamp: Dec 9th, 2024 @ 11:29pm

Questions? Connect With Us!

Ask the Cribz folks! No account? Sign up here.
mls grid

MLS Source Origin Disclaimer

The data relating to real estate for sale on this website appears in part through an MLS API system, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms in which Cribz participates, and is provided by local multiple listing services through a licensing agreement. The originating system name of the MLS provider is shown in the listing information on each listing page. Real estate listings held by brokerage firms other than Cribz contain detailed information about them, including the name of the listing brokers. All information is deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change, or withdrawal. Neither listing broker(s) nor Cribz shall be responsible for any typographical errors, misinformation, or misprints and shall be held totally harmless.

IDX information is provided exclusively for consumers’ personal non-commercial use, may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed by MLS GRID, and the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS, if any, and as amended from time to time.

Based on information submitted to the MLS GRID. 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 the contact page of this website.

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 to include all of the above information may result in the delay of the processing of your complaint.

Back to top