Showcasehomegroup.com Search Results

1 listings

Refine Search

Sort by

Unique multi-generational estate situated on ~5 private acres in Columbia Station, featuring three separate living spaces: a main residence, attached living quarters, and a detached 1-bedroom guest house. Originally constructed as a single-family home, the main residence was later expanded with a substantial side-by-side addition. Connections on both the main and upper levels allow the attached quarters to function independently or seamlessly as part of one large residence. The detached guest house provides additional flexibility for extended family, caregivers, adult children, guests, a private office, studio space, or potential rental use. The property also features a private pond and an impressive 4,500+ sq. ft. pole barn, offering exceptional space for vehicles, equipment, hobbies, storage, or workshop needs. Perfect for multi-generational living or anyone seeking privacy, flexibility, and room to spread out, this one-of-a-kind property offers a combination of living space, acreage, and utility that is exceptionally difficult to find.

7 Beds ⋅ 4 Baths ⋅ 5200082 MLS

Unique multi-generational estate situated on ~5 private acres in Columbia Station, featuring three separate living spaces: a main residence, attached living quarters, and a detached 1-bedroom guest house. Originally constructed as a single-family home, the main residence was later expanded with a substantial side-by-side addition. Connections on both the main and upper levels allow the attached quarters to function independently or seamlessly as part of one large residence. The detached guest house provides additional flexibility for extended family, caregivers, adult children, guests, a private office, studio space, or potential rental use. The property also features a private pond and an impressive 4,500+ sq. ft. pole barn, offering exceptional space for vehicles, equipment, hobbies, storage, or workshop needs. Perfect for multi-generational living or anyone seeking privacy, flexibility, and room to spread out, this one-of-a-kind property offers a combination of living space, acreage, and utility that is exceptionally difficult to find.

15064 W River Road, Columbia Station

The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of MLS Now and updated as of . Real estate listings held by brokerage firms other than Real Estate Company are marked with the Internet Data Exchange logo and detailed information about them includes the name of the listing broker(s).
IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
All information provided is deemed reliable but is not guaranteed and should be independently verified. © 2026 MLS Now. All Rights Reserved.