NOT LISTED FOR SALE

479 Ruschman Dr Cold Spring, KY 41076

Estimated Value: $590,000 - $763,000

4 Beds
4 Baths
3,150 Sq Ft
$202/Sq Ft Est. Value

Last Sold June 11, 2021

Last sale price $476,000 $151 Per Sq Ft

Est. 33% increase in value since last sale

Current estimated payment $3,807/month

2 Days on Market

Highlights

  • Eat-In Gourmet Kitchen
  • Granite Flooring
  • Deck
  • Donald E. Cline Elementary School Rated A
  • 0.88 Acre Lot
  • Living Room with Fireplace

About This Home

As of June 2021

Joe Hunt renovated this home into a true masterpiece. Enter through the front door to the two-story foyer which sets the stage for this exquisite home that eludes opulence, style& warmth. The chef's kitchen features upgraded Bosch appliances, a massive island, designer lighting, built-in coffee maker, wine cooler, and custom cabinets. Decorative moldings, hand-honed hickory floors, multiple outdoor decks, built-ins, surround sound, impressive quartz stone fireplace all adorn the first floor. Incredible master suite with pocket office, and stunning master bath is true oasis. You will be amazed!

Last Agent to Sell the Property

The Cindy Shetterly Team

Keller Williams Realty Services License #220012 Listed on: 04/28/2021

Last Buyer's Agent

The Trauth Property Group

Keller Williams Realty Services

Keller Williams Realty Services

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1995

Lot Details

  • 0.88 Acre Lot
  • Cul-De-Sac
  • Wood Fence

Parking

  • 3 Car Garage
  • Driveway
  • On-Street Parking

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 2-Story Property
  • Crown Molding
  • Ceiling Fan
  • Recessed Lighting
  • Gas Fireplace
  • Insulated Windows
  • Window Treatments
  • Wood Frame Window
  • Panel Doors
  • Great Room
  • Family Room
  • Living Room with Fireplace
  • 2 Fireplaces
  • Sitting Room
  • Formal Dining Room
  • Loft
  • Bonus Room
  • Fire and Smoke Detector

Kitchen

  • Eat-In Gourmet Kitchen
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Kitchen Island
  • Solid Surface Countertops
  • Solid Wood Cabinet

Flooring

  • Wood
  • Carpet
  • Granite
  • Marble

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • 4 Full Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Primary Bathroom includes a Walk-In Shower

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Outdoor Features

  • Deck
  • Covered Patio or Porch

Schools

  • Donald E.Cline Elementary School
  • Campbell County Middle School
  • Campbell County High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Propane
  • Septic Tank
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Ruschman Estates Subdivision

Listing and Financial Details

  • Assessor Parcel Number 999-99-19-849.05

Home Details

Home Type

Single Family

Year Built

Built in 1995

Lot Details

0

Parking

3

Listing Details

  • Cooling: Central Air
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.88
  • Year Built: 1995
  • Lot Size: of record
  • Subdivision Name: Ruschman Estates
  • Directions: I 275 to 471 to US 27S (2 miles) R on Murnan, L on Ruschman, 2nd house on right
  • Architectural Style: Traditional
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • ResoPropertyType: Residential
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: Donald E.Cline Elem
  • Location Tax Legal Info:Middle or Junior School: Campbell County Middle School
  • Location Tax Legal Info:High School: Campbell County High
  • Location Tax Legal Info:Subdivision2: Ruschman Estates
  • Contract Info:Auction YN: No
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: of record
  • Remarks Misc:Agent Only Remarks: All offers to be reviewed FRI at 3pm. SELLER RESERVES RIGHT TO ACCEPT AN OFFER AT ANY TIME! Sellers would like possession until the end of June. Please follow all CDC guidelines, wear your masks and remove your shoes when showing the home.
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Utilities:Cable Available: Yes
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 0.88
  • General Property Description:Lot Size Square Feet: 38332.8
  • Structure Type:House: Yes
  • Security Features:Smoke Detector(s): Yes
  • Architecture:Traditional: Yes
  • Room Type:Loft3: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 999-99-19-849.05
  • Appliances Refrigerators: Yes
  • General Property Description:Fireplaces Total: 2
  • Fencing:Wood3: Yes
  • Room Type:Bonus Room2: Yes
  • Percent Basement Finished: Yes
  • Room Type:Great Room4: Yes
  • Utilities:Propane3: Yes
  • Pets Allowed:Pets Allowed: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Crown Molding, Ceiling Fan(s), Multi Panel Doors, Recessed Lighting
  • Basement: Full, Finished, Walk-Out Access
  • Heating: Natural Gas, Forced Air
  • Levels: Two
  • Flooring: Carpet
  • Property Type: Residential
  • Appliances: Dishwasher, Microwave, Oven, Range, Refrigerator, Wine/Beverage Cooler
  • Full Bathrooms: 4
  • Total Bedrooms: 4
  • Fireplace Features: Gas
  • Fireplaces: 2
  • Fireplace: Yes
  • Window Features: Insulated Window(s), Wood Frames
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Multi Panel Doors: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Basement:Walk-Out Access7: Yes
  • Kitchen Features Pantry: Yes
  • Kitchen Features:Wood Cabinets: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Family Room Features:Carpet Flooring4: Yes
  • Living Room Features:Walk-Out Access: Yes
  • Primary Bath Features:Shower: Yes
  • Interior Features:Crown Molding: Yes
  • Dining Room Features:Wood Flooring3: Yes
  • Kitchen Features:Wood Flooring4: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Basement:Carpet Flooring7: Yes
  • Fireplace Features:Gas: Yes
  • Living Room Features:Carpet Flooring2: Yes
  • Living Room Features:Fireplace(s): Yes
  • Kitchen Features:Window Treatments3: Yes
  • Kitchen Features:Solid Surface Counters: Yes
  • Interior Features:Recessed Lighting: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Kitchen Features:Marble Flooring2: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Primary Bedroom Features:Wood Flooring7: Yes
  • Appliances Range: Yes
  • Kitchen Features:Granite Flooring2: Yes
  • Kitchen Features:Slate Flooring2: Yes
  • Primary Bedroom Features:Sitting Room: Yes
  • Appliances:WineBeverage Cooler: Yes

Exterior Features

  • Fencing: Wood
  • Roof: Shingle
  • Lot Features: Cul-De-Sac
  • Construction Type: Brick, Vinyl Siding
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Deck, Patio
  • Construction Materials:Brick2: Yes
  • Construction Materials:Vinyl Siding: Yes
  • Window Features:Insulated Window(s): Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes
  • Lot Features:Cul-De-Sac: Yes
  • Window Features:Wood Frames: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, On Street
  • General Property Description:Garage Spaces: 3.0
  • Parking Features:Driveway: Yes
  • Parking Features:On Street: Yes

Utilities

  • Sewer: Septic Tank
  • Water Source: Public
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Propane
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes
  • Sewer Septic Tank: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

  • Elementary School: Donald E.Cline Elem
  • Junior High Dist: Campbell Co Public
  • High School: Campbell County High
  • Middle Or Junior School: Campbell County Middle School

Lot Info

  • Lot Size Sq Ft: 38332.8
  • Zoning Description: {"Residential":true}
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Sep 30, 2021
Sold by
Gomez Julie Broderick and Gomez Andrew Budde
Bought by
Gomez Andrew B and Gomez Julie B
Current Estimated Value
$635,061

Purchase Details

Listed on
Apr 28, 2021
Closed on
Jun 11, 2021
Sold by
Johnson Kevin R and Johnson Cassie
Bought by
Gomez Julie Broderick and Gomez Andrew Budde
Seller's Agent
The Cindy Shetterly Team
Keller Williams Realty Services
Buyer's Agent
The Trauth Property Group
Keller Williams Realty Services
List Price
$429,900
Sold Price
$476,000
Premium/Discount to List
$46,100
10.72%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.51%
Original Mortgage
$414,450
Outstanding Balance
$310,507
Interest Rate
2.9%
Mortgage Type
New Conventional
Estimated Equity
$324,554

Purchase Details

Closed on
Sep 5, 2013
Sold by
Johnson Kevin R
Bought by
Johnson Kevin R

Purchase Details

Closed on
Apr 16, 2010
Sold by
Kohler Dieter Paul and Leibrand Kohler Carmen Marie
Bought by
Johnson Kevin R and Johnson Christina C

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$280,000
Interest Rate
4.99%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 31, 2008
Sold by
Weinel Fayella
Bought by
Leibrand Kohler Carmen Marie and Kohler Dieter Paul

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$240,000
Interest Rate
5.37%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Nov 13, 1995
Sold by
Buten Brothers Inc
Bought by
Weinel Fayella

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$130,000
Interest Rate
7.55%
Mortgage Type
New Conventional
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Gomez Andrew B -- None Available
Gomez Julie Broderick $476,000 360 American Title Svcs Llc
Johnson Kevin R -- None Available
Johnson Kevin R $305,000 Lawyers Title Of Cincinnati
Leibrand Kohler Carmen Marie $300,000 None Available
Weinel Fayella $273,500 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Gomez Julie Broderick $414,450
Previous Owner Johnson Kevin R $280,000
Previous Owner Leibrand Kohler Carmen Marie $240,000
Previous Owner Weinel Fayella $130,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
06/11/2021 06/11/21 Sold $476,000 +10.7% $151 / Sq Ft
04/30/2021 04/30/21 Pending -- -- --
04/28/2021 04/28/21 For Sale $429,900 -- $136 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $5,845 $497,400 $50,000 $447,400
2024 $5,845 $476,000 $50,000 $426,000
2023 $5,712 $476,000 $50,000 $426,000
2022 $5,901 $476,000 $50,000 $426,000
2021 $4,541 $365,000 $50,000 $315,000
2020 $3,847 $305,000 $40,000 $265,000
2019 $3,780 $305,000 $40,000 $265,000
2018 $3,806 $305,000 $40,000 $265,000
2017 $3,754 $305,000 $40,000 $265,000
2016 $3,682 $305,000 $0 $0
2015 $3,741 $305,000 $0 $0
2014 $3,646 $305,000 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • T

    Seller's Agent in 2021

    The Cindy Shetterly Team

    Keller Williams Realty Services

  • T

    Buyer's Agent in 2021

    The Trauth Property Group

    Keller Williams Realty Services

    Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 548114

Northern Kentucky Multiple Listing Service

APN: 999-99-19-849.05

Kentucky Campbell County Cold Spring 41076

479 Ruschman Dr, Cold Spring, KY

Not Listed for Sale

Detached

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Northern Kentucky Multiple Listing Service 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 Ten-X 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 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.

Nearby Homes