Buyer 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.