Generous room sizesFunctional floor planPlenty of natural lightComfortable living spaces
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.
33 days
|
974
|
67
|
Zillow last checked:
Listing updated:
Listed by:
Candice M. Van Bibber-Jefferson615-727-4777,
Epique Realty888-893-3537
Source: RealTracs MLS as distributed by MLS GRID,MLS#: 3260824
Facts & features
Interior
Bedrooms & bathrooms
Bedrooms: 3
Bathrooms: 2
Full bathrooms: 2
Main level bedrooms: 3
Bedroom 1
Features: Walk-In Closet(s)
Level: Walk-In Closet(s)
Area: 308 Square Feet
Dimensions: 22x14
Bedroom 2
Features: Walk-In Closet(s)
Level: Walk-In Closet(s)
Area: 195 Square Feet
Dimensions: 15x13
Bedroom 3
Features: Walk-In Closet(s)
Level: Walk-In Closet(s)
Area: 156 Square Feet
Dimensions: 13x12
Primary bathroom
Features: Double Vanity
Level: Double Vanity
Dining room
Features: Formal
Level: Formal
Area: 108 Square Feet
Dimensions: 12x9
Kitchen
Area: 221 Square Feet
Dimensions: 17x13
Living room
Features: Combination
Level: Combination
Area: 374 Square Feet
Dimensions: 22x17
Other
Features: Utility Room
Level: Utility Room
Area: 117 Square Feet
Dimensions: 13x9
Recreation room
Features: Main Level
Level: Main Level
Heating
Central
Cooling
Central Air
Appliances
Included: Oven, Cooktop, Electric Range, Dishwasher, Disposal, Ice Maker, Microwave
Laundry: Electric Dryer Hookup, Washer Hookup
Features
Air Filter, Ceiling Fan(s), Entrance Foyer, Extra Closets, High Speed Internet, Kitchen Island
Flooring: Laminate, Tile
Basement: None
Interior area
Total structure area: 2,268
Total interior livable area: 2,268 sqft
Finished area above ground: 2,268
Property
Parking
Total spaces: 8
Parking features: Detached, Gravel
Garage spaces: 2
Uncovered spaces: 6
Features
Levels: One
Stories: 1
Patio & porch: Porch, Covered, Deck
Fencing: Full
Lot
Size: 9.6 Acres
Features: Level
Topography: Level
Details
Additional structures: Guest House, Storage
Parcel number: 094 03505 000
Special conditions: Standard
Other equipment: Air Purifier
Construction
Type & style
Home type: MobileManufactured
Architectural style: Ranch
Property subtype: Manufactured On Land, Residential
Materials
Aluminum Siding
Roof: Metal
Condition
New construction: No
Year built: 1995
Utilities & green energy
Sewer: Septic Tank
Water: Public
Utilities for property: Water Available, Cable Connected
Community & HOA
Community
Subdivision: None
HOA
Has HOA: No
Location
Region: Columbia
Financial & listing details
Price per square foot: $295/sqft
Tax assessed value: $336,100
Annual tax amount: $1,605
Date on market: 7/6/2026
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
Date
Event
Price
7/31/2026
Contingent
$669,900$295/sqft
Source: RealTracs MLS as distributed by MLS GRID #3260824Report a problem
7/6/2026
Listed for sale
$669,900+100%$295/sqft
Source: RealTracs MLS as distributed by MLS GRID #3260824Report a problem
12/13/2019
Sold
$335,000-9.2%$148/sqft
Source: RealTracs MLS as distributed by MLS GRID #2073012Report a problem
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
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.