Refine Search
Map
Sort by
$193,900
46222 Zip Code
Pristine duplex near Hawthorn Park. Excellent opportunity to live in one side and let rents from the other side cover your mortgage. Or, use it for multi-generation living with grandma on one side and adult kids on the other side. Or, use both sides for investment income. One simple modification could convert this 1700+ sq ft duplex into a 3BR, 2 full bath single-family residence. Clean, dry basement with loads of storage and laundry area. Gas, forced air heat, central air. 2-car carport, storage shed. Large covered front porch with 2-person glider for morning coffee or evening relaxation. Single HVAC system supports both units, rented at $950/mo, including utilities.

22 N Tremont Street

Listing courtesy of Kenter Real Estate, LLC.

$3,100,000
3 Beds ⋅ 4 Baths ⋅ 46060 Zip Code
A one-of-a-kind 52acre private estate featuring a custom built log home set nearly a quarter mile off the main road for exceptional privacy. Brown county feel in Hamilton county. This chalet style residence offers a resort like outdoor retreat with a recently refinished inground Gunite pool, diving board, koi pond, and multiple entertaining areas. A covered deck with custom timber overlooks the pool and creek, creating a serene space to relax. Inside, the kitchen is designed for both culinary artistry and hosting, offering stainless steel appliances, double ovens, natural stone countertops, an integrated island, and a copper farmstyle sink. It opens to a massive great room with stunning timber vaulted ceilings. Three woodburning fireplaces feature stonework embedded with local artifacts and fossils, adding character throughout. The mainfloor primary suite includes a custom bed crafted from the home's own timbers. Its ensuite bath features a walkin shower, dual vanities, custom cabinetry, and a builtin closet. The lower level showcases a treated floor with a true north compass inlay and a spacious family room with a custom Colts countertop and steel ceilings. Each bedroom has its own log finish, with additional beds made from the home's timber. A bright workshop or rec room w/ closet sits adjacent. Every detail in this home is thoughtfully crafted including laundry on each floor. Systems include geothermal heating with heat pump backup, a hot water boiler, and three water heaters with heat piping throughout both levels. Beneath the log exterior, heavily insulated 2x6 construction ensures year round comfort. The oversized garage features epoxy floors and an EV charger. Of the 52 acres, 27 are tillable-ideal for farming or generating rental income. Wildlife is abundant, with large game frequently seen. This property must be experienced in person to appreciate its craftsmanship, detail, and luxury.

16610 E 186th

Listing courtesy of Myers Real Estate.

$695,000
4 Beds ⋅ 3 Baths ⋅ 46224 Zip Code
Remodeled farmhouse in the historic district known as Old Speedway. Dutch Colonial. Unique layout with two original staircases and archways. New farmhouse kitchen with open glass shelving on subway tile, quartzite countertops and custom cabinetry; Pantry. Hardwood floors throughout. Eight rooms; four bedrooms, two full and one 1/2 baths. Living area on 1st and 2nd floor is 2,456 SF. Brick patio with 12 x 14 cedar pergola. Fenced yard. Two car detached garage. Two blocks from Main Street.

5013 W 15th Street

Listing courtesy of Paradigm Realty Solutions.

$5,995,000
6 Beds ⋅ 10 Baths ⋅ 46060 Zip Code
Positioned on 13 private acres overlooking a stocked 7-acre pond within Canterbury Estates, this European-inspired waterfront estate offers more than 22,000 square feet designed for entertaining, recreation, and multigenerational living within Hamilton County's premier luxury corridor. Arched architectural windows and doorways introduce richly detailed interiors featuring dark hardwood flooring, extensive crown molding, custom millwork, coffered ceilings, tray ceilings, built-ins, and multiple fireplaces throughout. A dramatic two-story foyer opens to layered gathering spaces including a formal living room with French doors and stone fireplace, elegant dining room with arched windows and built-ins, executive office with fireplace and custom shelving, and a warm family room with paneled accents, brick fireplace, window bench seating, and wet bar access. The kitchen features a substantial center island, granite countertops, statement hood, pot filler, paneled appliances, custom cabinetry, and casual dining area with fireplace. The main-level primary suite offers fireplace seating space, dual-entry bath, soaking tub, walk-in tile shower, and his-and-hers closets. Elevator access extends across all three levels. The walkout lower level includes a full bar lounge, wine cellar, theater room with tiered recliner seating, indoor basketball court, sauna, gym, guest suite, and recreation spaces. Outdoor living includes expansive covered patios with fireplace, layered terraces, heated pool with natural stone waterfall, hot tub, firepit, dock access, and broad pond views. Additional highlights include dual geothermal HVAC systems and 8 garage spaces across two attached garages. Additional acreage available.

12304 E 196th Street

Listing courtesy of Encore Sotheby's International.

$99,499
4 Beds ⋅ 1 Baths ⋅ 47390 Zip Code
Unique opportunity in Union City! This spacious 4-bedroom home at 415 S Columbia Street sits on approximately three city lots and occupies an entire corner lot, offering an uncommon amount of space, privacy, and potential. The property features a pool, garden area, and multiple outbuildings that provide excellent storage, workshop space, hobby areas, or future improvement possibilities. The home offers generous living space and plenty of character, with room for someone to bring their vision and updates to life. While repairs and improvements are needed, the combination of the large home, oversized corner lot, pool, garden space, and additional structures creates strong upside potential for investors, renovators, or buyers looking to build equity. Enjoy the convenience of town living while still having room to spread out outdoors. Plenty of space for entertaining, gardening, recreation, pets, parking, or additional possibilities. Conveniently located near local amenities, schools, and downtown Union City.

415 S Columbia Street

Listing courtesy of FC Tucker Richmond.

$738,000
5 Beds ⋅ 5 Baths ⋅ 46060 Zip Code
Discover this Beautiful brick-front two-story home offering approximately 4,900 total square feet of living space. This spacious property features 5 bedrooms and 4.5 bathrooms with a thoughtfully designed layout and high ceilings that create an open and inviting atmosphere. The updated kitchen showcases a stylish new backsplash, dual built-in oven, and a convenient kitchen nook with built-in cabinetry providing additional storage and functionality. The fully finished walkout basement provides additional living space and includes a full bathroom, making it ideal for guests, recreation, or a private suite. Step outside to enjoy the backyard featuring stairs leading to the yard and a cozy outdoor fire pit-perfect for relaxing evenings or entertaining. Additional highlights include a 3-car garage and a convenient kitchenette located in the garage for added functionality. With generous living space, modern updates, and great indoor-outdoor flow, this home offers comfort, style, and versatility.

12338 French Cattle Way

Listing courtesy of URBAN DREAM REALTY LLC.

Information Deemed Reliable But Not Guaranteed. © 2026 MIBOR Broker Listing Cooperative