2388 Bear Creek PikeColumbia, TN 38401
Mortgage Calculator
Monthly Payment (Est.)
$3,056Buyer and Buyers agent to verify all pertinent information. Endless Possibilities Await on This Incredible home and apartment Property!Welcome to a truly one-of-a-kind property offering the perfect blend of privacy, versatility, and investment potential. Situated on beautiful Bear Creek Pike just minutes from downtown Columbia, this unique estate features three separate residences on one property, making it ideal for multi-generational living, rental income, guest accommodations, or a private family compound.The centerpiece of the property is a spacious home featuring 3 bedrooms and 2 full bathrooms. Thoughtfully designed with comfortable living spaces, this home offers plenty of natural light, generous room sizes, and a functional floor plan perfect for everyday living or entertaining. The kitchen provides ample cabinet and countertop space, while the adjoining dining and living areas create a warm, inviting atmosphere. The primary suite offers privacy and comfort with an en-suite bath, and the additional bedrooms provide flexibility for family, guests, or a home office.Adding tremendous value is a charming 2-bedroom, 1-bath apartment complete with a full kitchen and appliances. Whether you're looking to generate consistent rental income, provide independent living space for extended family, or create a comfortable guest retreat, this residence offers exceptional flexibility.Also included is a well-appointed studio apartment featuring a kitchen, full bath, and appliances. Perfect for short-term rentals, long-term tenants, an in-law suite, home business, artist's studio, or private office, this additional living space creates even more opportunities for income and lifestyle.Properties offering three independent residences are exceptionally rare, making this an outstanding opportunity for investors, owner-occupants, or anyone seeking multiple streams of income. Live comfortably in the primary home while offsetting your mortgage by renting the other apartments.
| 5 days ago | Status changed to Active | |
| 5 days ago | Listing updated with changes from the MLS® | |
| 2 months ago | Listing first seen on site |
Listings courtesy of Realtracs as distributed by MLS GRID
Based on information submitted to the MLS GRID as of 2026-09-08 06:04 AM UTC. 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 DMCAnotice@MLSGrid.com.
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.
Each Keller Williams Realty office is independently owned and operated.