4111 Union Street

Beds
Baths
Sq. Ft.
/ Sq. Ft.
Sq. Ft.
per Sq. Ft.

Description

Riverfront Property consisting of a total of 4.64 acres! This property is being sold as a package deal along with 10147 Madison St at one price with over 300ft of river shoreline! Imagine living next to a public boat ramp with the ability to launch your boat into the Ohio River in just a few minutes. Houses have no value. The Post Office rents a corner of the property so you will receive monthly rental income. Build your dream home right along the river! Must schedule a showing to walk the property...Riverfront Property consisting of a total of 4.64 acres! This property is being sold as a package deal along with 10147 Madison St at one price with over 300ft of river shoreline! Imagine living next to a public boat ramp with the ability to launch your boat into the Ohio River in just a few minutes. Houses have no value. The Post Office rents a corner of the property so you will receive monthly rental income. Build your dream home right along the river! Must schedule a showing to walk the property and see the spectacular views. Sold AS-IS!
  1. Listed by Sherry Steffen • Horan Rosenhagen Real Estate
    P: (859)-750-2059 C: (859)-750-2059 sherry@horanrosenhagen.com

Property Details for 4111 Union Street

Has View
Yes
Architectural Style
Other, Traditional
View
River
Zoning Description
Residential
LISTING UPDATED: 05/14/2026 08:39 AM

Property Details for 4111 Union Street

StatusActive
MLS #641814
Days on Market9735
Taxes-
HOA Fees-
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built-
Lot Size4.64 AC / 202,118 SF
CountyCampbell County

Location

Listing Courtesy of Horan Rosenhagen Real Estate
Add your commute

Building Information for 4111 Union Street

Stories-Year Built-Building Size-Lot Size4.64 AC / 202,118 SF

Payment Calculator

$1,266 per month

30 year fixed, 6.36% Interest

Principal and Interest

$1,171

Property Taxes

$95

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 4111 Union Street

Summary
Location and General Information
  • Longitude: -84.261995
  • Latitude: 38.91837
  • Directions: AA to East California Crossroads, left on Mary Ingles Hwy, right on Union. Last driveway on the right past the post office.
  • MLSArea Major: K19 - Calif/Melb/Silv Grov
  • MLSArea Minor: K19 - Calif/Melb/Silv Grov
  • Year Built Known: No
  • Property Condition Disclosure: Yes
  • SIC: CF - California
Taxes and HOA
  • Association: No
  • Parcel Number: 999-99-29-757.00
  • Tax Rate: 11.94
School Information
  • High School District: Campbell Co Public
  • Elementary School: Campbell Ridge Elementary
  • Middle Or Junior School: Campbell County Middle School
  • High School: Campbell County High
Parking
  • Parking Features: Driveway
  • Attached Garage: No
Property
Lot Information
  • Road Frontage Type: County Road
  • Lot Size Units: Acres
  • Lot Size Square Feet: 93249.0
  • Lot Features: Wooded, Corner Lot, Waterfront
  • Lot Size Acres: 4.64
  • Lot Size Area: 4.64
  • Lot Features: Wooded, Corner Lot, Waterfront
Property and Assessments
  • New Construction: No
  • Property Condition: Existing Structure
  • Land Lease: Yes
  • Property Attached: No
  • Land Description: 1 to 4.9 Acres
Building Features
  • Levels: Two
  • Structure Type: House
  • Foundation Details: Block
  • Construction Materials: Vinyl Siding
Interior and Exterior Features
Interior Features
  • Appliances: Other
  • Fireplace: No
  • Has Heating: No
  • Has Cooling: No
  • Basement: Other
Exterior Features
  • Roof: Other

Property History for 4111 Union Street

DateEvent & SourcePriceAppreciation
Apr 22, 2026

Listed (Active)

Northern Kentucky Multiple Listing Service #641814

$235,000
Sep 17, 2020

Sold (Public Record)

Public Record #680043371

$85,000
Sep 11, 2020

Sold

Northern Kentucky Multiple Listing Service #532529

$85,000
DateEvent & SourcePrice
04/22/2026

Listed (Active)

Northern Kentucky Multiple Listing Service #641814

$235,000
09/17/2020

Sold (Public Record)

Public Record #680043371

$85,000
09/11/2020

Sold

Northern Kentucky Multiple Listing Service #532529

$85,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 4111 Union Street

Taxable ValueLand$18,000Additions$67,000Total$85,000
Tax Record2021$1,145 ($95 / month)
Home Facts
Baths3Total Finished SqFt4,620 SqFtAbove Grade Finished SqFt4,620 SqFtStories1Lot Size93,262 SqFtStyleMiscellaneous CommercialYear Built1976CountyCAMPBELLAPN999-99-29-757.00Fireplace TypeHas Fireplace

Schools near 4111 Union Street

This home is within Campbell County.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 8
Public - 9 to 12
Public - 6 to 12
Rating
School
Distance
Campbell Ridge Elementary School
PublicPK to 5

Campbell County Middle School
Public6 to 8

Campbell County High School
Public9 to 12

Alexandria Educational Center
Public6 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

4111 Union Street is a single family home for sale in California, KY 41007. This property was listed for sale on April 22, 2026 by Horan Rosenhagen Real Estate, it's currently listed at $235,000. It has been on the market for a total of 9735 days and was last sold on September 17, 2020. This listing's school district is Campbell County. Nearby schools include Campbell Ridge Elementary School, Campbell County Middle School and Campbell County High School. 4111 Union Street is a 0-bed, 0-bath, single family home.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Horan Rosenhagen Real Estate

The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Compass and its related brokerages are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers. Listing information is deemed reliable, but not guaranteed. Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.