NOT LISTED FOR SALE

974 Frogtown Rd Union, KY 41091

Estimated Value: $375,000 - $437,000

4 Beds
3.5 Baths
1,648 Sq Ft
$249/Sq Ft Est. Value

Last Sold September 03, 2023

Last sale price $362,000 $220 Per Sq Ft

Est. 13% increase in value since last sale

Current estimated payment $2,620/month

25 Days on Market

Highlights

  • Spa
  • 0.74 Acre Lot
  • Traditional Architecture
  • Shirley Mann Elementary School Rated A
  • Vaulted Ceiling
  • Wood Flooring

About This Home

As of September 2023

BACK ON MARKET after prior buyer's financing fell through. This 4 bedroom home with 1st floor owner's suite includes bonus room/office on the second floor and two bonus rooms in the basement. Kitchen appliances and washer/dryer are less than 2.5 years old . Spacious, private fenced backyard on nearly 3/4 acre lot; pool with brand new equipment, new hot tub. Outbuilding with garage door for riding mower.

Last Agent to Sell the Property

Christa Zielke

KW Seven Hills Realty License #223643 Listed on: 07/07/2023

KW Seven Hills Realty

Co-Listed By

Peter Chabris

KW Seven Hills Realty License #211154

Last Buyer's Agent

Jim Muchmore

Coldwell Banker West Shell License #203779

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,052

Year Built

  • Built in 2008

Lot Details

  • 0.74 Acre Lot
  • Aluminum or Metal Fence

Parking

  • 2 Car Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Poured Concrete
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 1,648 Sq Ft Home
  • 2-Story Property
  • Vaulted Ceiling
  • Fireplace
  • Vinyl Clad Windows
  • Living Room
  • Bonus Room
  • First Floor Utility Room
  • Storage Room
  • Utility Room

Kitchen

  • Eat-In Kitchen
  • Electric Oven
  • Electric Range
  • Microwave
  • Dishwasher
  • Kitchen Island

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Bathtub and Shower Combination in Primary Bathroom

Laundry

  • Laundry Room
  • Laundry on lower level
  • Dryer
  • Washer

Basement

  • Walk-Out Basement
  • Finished Basement Bathroom
  • Stubbed For A Bathroom

Pool

  • Spa
  • Above Ground Pool

Outdoor Features

  • Covered patio or porch
  • Shed

Schools

  • Shirley Mann Elementary School
  • Gray Middle School
  • Ryle High School

Utilities

  • Central Air
  • Heating Available
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 063.00-00-070.00

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,052

Year Built

Built in 2008

Lot Details

0

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.74
  • Year Built: 2008
  • Lot Size: Of record
  • Co List Office Mls Id: o656006417
  • Co List Office Phone: 513-371-5070
  • Directions: Frogtown Road near Triple Crown Blvd
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • 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: Shirley Mann School
  • Location Tax Legal Info:Middle or Junior School: Gray Middle School
  • Location Tax Legal Info:High School: Ryle High
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 1
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: No
  • General Property Description:Lot Size Dimensions: Of record
  • General Property Description:Approx SqFt2: 1648.0
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Utilities Electric Company: Duke
  • Water Company: Boone County
  • Water Source:Public: Yes
  • Room Details:Family Room YN: No
  • Room Details:Formal Dining Rm YN: No
  • General Property Description:Lot Size Acres: 0.74
  • General Property Description:Living Area: 1648.0
  • General Property Description:Lot Size Square Feet: 32234.0
  • Structure Type:House: Yes
  • Architecture:Traditional: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 063.00-00-070.00
  • Appliances Refrigerators: Yes
  • Room Type:Living Room4: Yes
  • Other Structures:Shed(s): Yes
  • Appliances Dryer: Yes
  • Washers: Yes
  • Room Type:Bonus Room2: Yes
  • Utilities:Sewer Available: Yes
  • Utilities:Water Available: Yes
  • Laundry Features:Lower Level: Yes
  • Pool Features:Above Ground: Yes
  • Fencing:Metal4: Yes
  • Room Type:Utility Room2: Yes
  • Room Type:Utility Room Level2: First
  • Bonus Room Features:Storage8: Yes
  • Recreation Room Features:Storage10: Yes
  • Utility Room Features:Tile Flooring18: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Eat-in Kitchen, Vaulted Ceiling(s)
  • Basement: See Remarks, Bath/Stubbed, Walk-Out Access
  • Heating: Electric
  • Levels: Two
  • Property Type: Residential
  • Appliances: Electric Oven, Electric Range, Dishwasher, Dryer, Microwave, Refrigerator, Washer
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace: No
  • Living Area: 1648.0
  • Window Features: Vinyl Frames
  • Appliances Dishwasher: Yes
  • Appliances:Electric Oven: Yes
  • Interior Features:Kitchen Island2: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Basement:Walk-Out Access7: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Appliances:Electric Range: Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Living Room Features:Wood Flooring2: Yes
  • Basement:Full Finished Bath: Yes
  • Interior Features:Vaulted Ceiling(s): Yes
  • Primary Bath Features:Tub With Shower: Yes
  • Basement:See Remarks36: Yes

Exterior Features

  • Fencing: Metal
  • Roof: Shingle
  • Pool Features: Above Ground
  • Construction Type: Vinyl Siding
  • Exterior Features: Fenced, Hot Tub
  • Foundation Details: Poured Concrete
  • Other Structures: Shed(s)
  • Patio And Porch Features: Covered, Porch
  • Construction Materials:Vinyl Siding: Yes
  • Window Features:Vinyl Frames: Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Porch: Yes
  • Exterior Features:Fenced: Yes
  • Exterior Features:Hot Tub: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Garage
  • General Property Description:Garage Spaces: 2.0
  • Parking Features:Driveway: Yes
  • Parking Features:Garage5: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Lower Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Sewer Available, Water Available
  • Heating:Electric2: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

  • Elementary School: Shirley Mann School
  • Junior High Dist: Boone Co Public
  • High School: Ryle High
  • Middle Or Junior School: Gray Middle School

Lot Info

  • Lot Size Sq Ft: 32234.0
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 7, 2023
Closed on
Sep 2, 2023
Sold by
Lykins Darl L and Lykins Amanda
Bought by
Barhorst Matthew and Turney Stephanie
Seller's Agent
Christa Zielke
KW Seven Hills Realty
Buyer's Agent
Jim Muchmore
Coldwell Banker West Shell
List Price
$365,000
Sold Price
$362,000
Premium/Discount to List
-$3,000
-0.82%
Views
194
Current Estimated Value
$409,634

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$47,634
Avg. Annual Appreciation
7.11%
Original Mortgage
$289,600
Outstanding Balance
$284,671
Interest Rate
6.81%
Mortgage Type
New Conventional
Estimated Equity
$124,963

Purchase Details

Closed on
Jul 7, 2020
Sold by
Wren Christopher and Wren Angela
Bought by
Lykins Darl L and Lykins Amanda

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$270,655
Interest Rate
3.1%
Mortgage Type
FHA

Purchase Details

Closed on
May 1, 2006
Sold by
Poole Florine
Bought by
Wren Christopher and Wren Angela
Source: Public Records

Similar Homes in Union, KY

  • 2246 Algiers St, Union, KY 41091

    $370,000

    • 4 Beds
    • 4 Baths
    • 1,940 Sq Ft
    • 2246 Algiers St
    • Union, KY

    Beautifully updated, thoughtfully maintained, and truly move-in ready! Located on a quiet cul-de-sac in the sought-after Orleans North neighborhood, this spacious 4-bedroom, 4-bath two-story offers comfort, functionality, and prime location.The current owners especially loved the open-concept main floor—ideal for staying connected while cooking, entertaining, or keeping an eye on things. The

    Kyle Art RE/MAX Victory + Affiliates

    Section Image
  • 10154 Hamlet Ct, Union, KY 41091

    $460,000

    • 4 Beds
    • 4 Baths
    • 3,328 Sq Ft
    • 10154 Hamlet Ct
    • Union, KY

    Welcome to the Welborne by Drees!Tucked away on a peaceful cul-de-sac this great one-owner home features every available builder extension, 4 lg.bedrooms, 2 full/2 half baths and a true 3-car garage this home offers room to live, relax,and entertain.Step inside to 9-ft ceilings on the first floor with an open-concept main level. Expansive family room w/fireplace, a welcoming kitchen w/wood

    Patrina Hensley eXp Realty, LLC

    Section Image
  • 10070 Cedarwood Dr, Union, KY 41091

    $455,000

    • 4 Beds
    • 3.5 Baths
    • 10070 Cedarwood Dr
    • Union, KY

    Stunning 4-Bedroom Home with Finished Lower Level & Multi-Tier Deck!This beautifully maintained 2-story home offers 4 spacious bedrooms, 3.5 bathrooms, and a finished lower level complete with an exercise room. The first floor features elegant hardwood flooring, a cozy wood-burning fireplace, and a modern kitchen with stainless steel appliances. Step outside to enjoy the multi-tier deck—perfect

    Julie Ray-Ritchie Coldwell Banker Realty FM

    Section Image
  • 10716 Station Ln, Union, KY 41091

    $384,900

    • 3 Beds
    • 3.5 Baths
    • 2,069 Sq Ft
    • 10716 Station Ln
    • Union, KY

    This home is ready for the next homeowner to grow. Enjoy the large front porch plus a great rear deck overlooking a fenced backyard. Convenient location-close to everything. This home features a formal living room, dining room plus eat-in kitchen & family room. Lower level finished offering a great place to entertain with a walk out to the back yard and a finished full bathroom and walk-in

    Joe Lockaby Century 21 Premiere Properties

    Section Image
  • 1413 R J Ln, Union, KY 41091

    $319,500

    • 3 Beds
    • 3 Baths
    • 2,432 Sq Ft
    • 1413 R J Ln
    • Union, KY

    Oversized move-in-ready tri-level with hardwood floors, right in the heart of Union! Quiet cul-de-sac, Mann/Gray/Ryle school district, 3 Bedrooms, 3 Full baths. Peaceful, fenced -in, flat backyard with deck, large shade tree, and fruit trees. Cozy window seat. Huge lower-level features expansive family room, full bathroom, and massive storage area. Large primary bedroom with ensuite. Newer:

    Ryan Clendenin Huff Realty - Florence

    Section Image
  • 10083 Irish Way, Union, KY 41091

    $375,000

    • 3 Beds
    • 3.5 Baths
    • 10083 Irish Way
    • Union, KY

    Check out this freshly updated 2 Story in sought after Union school district! Beautifully appointed large kitchen, featuring, granite counter tops, stainless steel appliances and breakfast bar. Fully finished basement with large wet bar and custom tin ceiling! New roof & paint in 25, new patio & hot tub in '22, New ktichen & floor in '21 All this sits on a large corner lot, w/ sunroom and shed.

    Marc Garrison Huff Realty - Florence

    Section Image
  • 3825 Sonata Dr, Union, KY 41091

    $439,000

    • 3 Beds
    • 4 Baths
    • 3,143 Sq Ft
    • 3825 Sonata Dr
    • Union, KY

    This stunning Drees-built Fulton floor plan offers an ideal blend of space, comfort, and style. You'll love the hardwood entry, formal dining room, private study, and the soaring 2-story great room that fills with natural light. The spacious kitchen features a large island, custom cabinetry, and a bright breakfast nook that flows effortlessly into the main living area. Upstairs, enjoy oversized

    Lisa Brandenburg Huff Realty - Florence

    Section Image
  • 9751 Cherbourg Dr, Union, KY 41091

    $450,000

    • 5 Beds
    • 3.5 Baths
    • 9751 Cherbourg Dr
    • Union, KY

    WOW—this one is stellar! From the completely remodeled kitchen to the finished lower level, every inch of this home is pristine. The gourmet kitchen is straight out of a magazine with custom cabinetry, granite counters, wine rack, tile backsplash, stainless appliances, island, and pantry—the works. Luxury vinyl flooring flows throughout the first floor, leading into a cozy great room with

    Nicole Riegler RE/MAX Victory + Affiliates

    Section Image
  • 1344 Wilshire Ct, Union, KY 41091

    $415,000

    • 4 Beds
    • 3 Baths
    • 2,260 Sq Ft
    • 1344 Wilshire Ct
    • Union, KY

    Welcome to 1344 Wilshire Court, a beautifully maintained ranch in the fantastic Harmony subdivision. Built in 2016. 2260+ square feet, featuring 4 bed, 3 full baths & finished lower level. The open-concept main level is perfect for both entertaining or relaxing, while the finished walkout lower level provides additional living space ideal for a recreation room, guest suite, or home office. Enjoy

    Heather Herr Private Real Estate Collection

    Section Image

Range of Values:

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
Barhorst Matthew -- Lawyers Title
Lykins Darl L $280,000 Northwest Ttl Fam Of Compani
Wren Christopher $55,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Barhorst Matthew $289,600
Previous Owner Lykins Darl L $270,655
Previous Owner Wren Christopher $69,100
Previous Owner Wren Christopher $36,000
Previous Owner Wren Christopher $149,000
Previous Owner Wren Chris $16,000
Previous Owner Wren Christopher $162,000
Previous Owner Wren Christopher $160,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/03/2023 09/03/23 Sold $362,000 -0.8% $220 / Sq Ft
08/02/2023 08/02/23 Pending -- -- --
07/30/2023 07/30/23 Price Changed $365,000 0.0% $221 / Sq Ft
07/30/2023 07/30/23 For Sale $365,000 -1.1% $221 / Sq Ft
07/11/2023 07/11/23 Pending -- -- --
07/07/2023 07/07/23 For Sale $369,000 -- $224 / 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
2024 $4,052 $362,000 $35,000 $327,000
2023 $3,261 $280,000 $35,000 $245,000
2022 $3,144 $280,000 $35,000 $245,000
2021 $3,225 $280,000 $35,000 $245,000
2020 $2,155 $188,200 $35,000 $153,200
2019 $1,992 $172,000 $30,000 $142,000
2018 $2,038 $172,000 $30,000 $142,000
2017 $1,963 $172,000 $30,000 $142,000
2015 $1,938 $172,000 $30,000 $142,000
2013 -- $172,000 $30,000 $142,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 615042

Northern Kentucky Multiple Listing Service

APN: 063.00-00-070.00