$506,000
SOLD JAN 27, 2025

1047 Bayswater Dr Union, KY 41091

3 Beds
3.5 Baths
1,855 Sq Ft
0.42 Acres

Recently Sold

$273 Per Sq Ft

4% Below List Price

25 Days on Market

Highlights

  • Media Room
  • Eat-In Gourmet Kitchen
  • Vaulted Ceiling
  • Shirley Mann Elementary School Rated A
  • Open Floorplan
  • Traditional Architecture

About This Home

As of January 2025

Thoughtful design and refined detail join modern convenience here. 1st floor primary ensuite, superior remodel of kitchen, primary bath & lower level(media room, wet bar w/beer tap, built-in shelves with secret entrance to storage area AND a temperature controlled wine room with 600 bottle capacity +25 feet of shelving for bottle spirits!), pinterest worthy covered patio w/stone fireplace, plantation shutters, custom pull-out kitchen drawers, amish built primary bath cabinetry, newer garage doors & gutters(including gutter guards), professional landscaping, fountain, newer HVAC, tankless water heater, water softener, meticulously maintained. Pool community, located in the award winning Shirley Mann/Gray/Ryle school district. When can you move in?

Last Agent to Sell the Property

Janell Stuckwisch

eXp Realty, LLC License #210274 Listed on: 11/14/2024

eXp Realty, LLC

Last Buyer's Agent

Sheila Roderick

Huff Realty - CC License #191467

Huff Realty - CC

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1996

Lot Details

  • 0.42 Acre Lot
  • Year Round Access
  • Corner Lot
  • Level Lot

HOA Fees

  • $58 Monthly HOA Fees

Parking

  • 2 Car Garage
  • Side Facing Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Composition Roof

Interior Spaces

  • 1,855 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Home Theater Equipment
  • Sound System
  • Wired For Data
  • Built-In Features
  • Bookcases
  • Crown Molding
  • Vaulted Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • 2 Fireplaces
  • Wood Burning Fireplace
  • Marble Fireplace
  • Gas Fireplace
  • Insulated Windows
  • Transom Windows
  • French Doors
  • Panel Doors
  • Entryway
  • Great Room
  • Family Room
  • Breakfast Room
  • Formal Dining Room
  • Media Room
  • Home Office
  • Storage
  • Neighborhood Views
  • Fire and Smoke Detector

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Bar
  • Gas Range
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops
  • Utility Sink
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile
  • Luxury Vinyl Tile
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom on Main
  • En-Suite Primary Bedroom
  • En-Suite Bathroom
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom
  • Bathtub with Shower
  • Shower Only
  • Primary Bathroom includes a Walk-In Shower

Laundry

  • Laundry Room
  • Laundry on main level

Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Finished Basement Bathroom
  • Stubbed For A Bathroom
  • Basement Storage

Outdoor Features

  • Covered Patio or Porch
  • Water Fountains

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Tankless Water Heater
  • Water Softener

Listing and Financial Details

  • Assessor Parcel Number 063.00-12-109.00

Community Details

Overview

  • Association fees include association fees, management
  • Vertex Professional Group Association, Phone Number (859) 491-5711

Recreation

  • Tennis Courts
  • Community Playground
  • Community Pool

Security

  • Resident Manager or Management On Site

Home Details

Home Type

Single Family

Year Built

Built in 1996

Lot Details

0

HOA Fees

$58 per month

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.42
  • Year Built: 1996
  • Lot Size: Irreg
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Directions: I71/75 S, Exit 178, R on Mt Zion Rd, L on Hempsteade Dr, R on Burleigh Ln, L on Bayswater Drive. Home is on the Right at corner of Bayswater Drive and Lura Woods Ct.
  • 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
  • Location Tax Legal Info:Subdivision2: Hempsteade
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 1
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: Irreg
  • General Property Description:Approx SqFt2: 1855.0
  • Remarks Misc:Agent Only Remarks: *Conveying in Sale: Theatre Room tv, audio components, speakers/mounts/Refrigerator, kegerator, microwave, and freezer in lower level/Refrigerator in Kitchen/Water softener. *12mos average utility costs based on current owner usage: Duke Energy - elec/gas $170, SD1 - sewage/storm water $50, Boone County Water $20
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Room Type:Dining Room4: Yes
  • Room Type:Entry: Yes
  • Room Type:Family Room4: Yes
  • Room Type:Laundry Room3: Yes
  • Room Type:Office5: Yes
  • Sewer:Public Sewer: Yes
  • Utilities Electric Company: Duke Energy
  • Utilities Gas Company: Duke Energy
  • Water Company: Boone County Water
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 0.42
  • General Property Description:Living Area: 1855.0
  • General Property Description:Lot Size Square Feet: 18295.0
  • Structure Type:House: Yes
  • Laundry Features:Laundry Room2: Yes
  • Laundry Features:Main Level: Yes
  • Room Type:Breakfast Room2: Yes
  • Room Type:Breakfast Room Level: First
  • Security Features:Smoke Detector(s): Yes
  • Architecture:Traditional: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 063.00-12-109.00
  • Appliances Refrigerators: Yes
  • Roof:Composition: Yes
  • General Property Description:Fireplaces Total: 2
  • Other Equipment:Sump Pump: Yes
  • Percent Basement Finished: Yes
  • Water Softeners: Yes
  • Other Equipment:Home Theater: Yes
  • Room Type:Great Room4: Yes
  • Entry Features:Hardwood Floors5: Yes
  • Entry Features:Wood Flooring: Yes
  • Laundry Room Features:Tile Flooring15: Yes
  • Great Room Features:Wood Flooring9: Yes
  • Great Room Features:Ceiling Fan(s)4: Yes
  • Great Room Features:High Ceiling(s)3: Yes
  • Office Features:Hardwood Floors16: Yes
  • Great Room Features:Hardwood Floors8: Yes
  • Special Features: VirtualTour

Interior Features

  • Interior Amenities: Kitchen Island, Wet Bar, Walk-In Closet(s), Storage, Pantry, Open Floorplan, Granite Counters, Double Vanity, Crown Molding, Chandelier, Bookcases, Breakfast Bar, Built-in Features, Ceiling Fan(s), High Ceilings, Multi Panel Doors, Recessed Lighting, Vaulted Ceiling(s), Wired for Data, Wired for Sound, Master Downstairs
  • Basement: Full, Finished, Bath/Stubbed, Storage Space
  • Heating: Natural Gas, Forced Air
  • Levels: Two
  • Flooring: Carpet, Vinyl
  • Property Type: Residential
  • Appliances: Wine Cooler, See Remarks, Stainless Steel Appliance(s), Gas Range, Dishwasher, Disposal, Microwave, Refrigerator, Tankless Water Heater, Water Softener
  • Other Equipment: Home Theater, Sump Pump
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Door Features: French Doors
  • Fireplace Features: Gas, Marble, Wood Burning
  • Fireplaces: 2
  • Fireplace: Yes
  • Living Area: 1855.0
  • Window Features: Insulated Windows
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Stainless Steel Appliance(s): Yes
  • Interior Features:Built-in Features2: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Double Vanity2: Yes
  • Interior Features:Granite Counters: Yes
  • Interior Features:High Ceilings: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Interior Features:Open Floorplan: Yes
  • Interior Features:Pantry2: Yes
  • Interior Features:Storage2: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Interior Features:Wet Bar4: Yes
  • Interior Features:Wired for Data: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Primary Bedroom Features:Ceiling Fan(s)8: Yes
  • Appliances:Gas Range: Yes
  • Family Room Features:Luxury Vinyl Flooring8: Yes
  • Kitchen Features Pantry: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Family Room Features:Carpet Flooring4: Yes
  • Kitchen Features:Walk-Out Access3: Yes
  • Primary Bath Features:Shower: Yes
  • Interior Features:Primary Downstairs: Yes
  • Fireplace Features:Wood Burning: Yes
  • Interior Features:Crown Molding: Yes
  • Dining Room Features:Wood Flooring3: Yes
  • Kitchen Features:Wood Flooring4: Yes
  • Basement:Full Finished Bath: Yes
  • Basement:Storage Space: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Basement:Carpet Flooring7: Yes
  • Basement:Full Finished Half Bath: Yes
  • Fireplace Features:Gas: Yes
  • Interior Features:Breakfast Bar2: Yes
  • Interior Features:Chandelier2: Yes
  • Interior Features:Vaulted Ceiling(s): Yes
  • Dining Room Features:Chandelier: Yes
  • Kitchen Features:Breakfast Bar: Yes
  • Kitchen Features:Solid Surface Counters: Yes
  • Primary Bedroom Features:Hardwood Floors18: Yes
  • Interior Features:Recessed Lighting: Yes
  • Family Room Features:Ceiling Fan(s)3: Yes
  • Basement:Wet Bar5: Yes
  • Interior Features:Bookcases4: Yes
  • Interior Features:Wired for Sound: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Kitchen Features:Recessed Lighting3: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Primary Bedroom Features:Wood Flooring7: Yes
  • Family Room Features:Recessed Lighting6: Yes
  • Appliances:Tankless Water Heater: Yes
  • Primary Bath Features:Ceramic Tile Flooring: Yes
  • Basement:Built-in Features3: Yes
  • Primary Bedroom Features:Vaulted Ceiling(s)2: Yes
  • Appliances:WineBeverage Cooler: Yes
  • Dining Room Features:Recessed Lighting8: Yes
  • Fireplace Features:Marble: Yes
  • Basement:Vinyl Flooring8: Yes
  • Appliances:See Remarks32: Yes

Exterior Features

  • View: Neighborhood
  • Roof: Composition, Shingle
  • Lot Features: Corner Lot, Level
  • View: Yes
  • Construction Type: Brick
  • Exterior Features: Fountain
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Patio, Porch
  • Construction Materials:Brick2: Yes
  • Lot Features:Corner Lot: Yes
  • Window Features:Insulated Window(s): Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Lot Features:Level: Yes
  • Exterior Features:Fountain: Yes
  • Door Features:French Doors: Yes

Garage/Parking

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

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Laundry Room, Main Level
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Amenities: Lake Year Round, Playground, Pool, Tennis Court(s)
  • Association Fee: 700.0
  • Association Fee Frequency: Annually
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: Vertex Professional Group
  • Association Information:Association Management Phone 1: 859-491-5711
  • Association Information:Total Yearly Fees: 700.0
  • Association Fee Includes:Association Fees: Yes
  • Association Information:Association Fee: 700.0
  • Association Information:Association Fee Frequency: Annually
  • Association Amenities:Management: Yes
  • Association Amenities:Playground: Yes
  • Association Amenities:Pool5: Yes
  • Association Amenities:Tennis Court(s)2: Yes
  • Association Amenities:Lake Year Round: Yes

Fee Information

  • Association Fee Includes: Association Fees, Management

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: 18295.0
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 14, 2024
Closed on
Jan 27, 2025
Sold by
Vance Coyd M and Vance Cynthia M
Bought by
Day Bridget
Seller's Agent
Janell Stuckwisch
eXp Realty, LLC
Buyer's Agent
Sheila Roderick
Huff Realty - CC
List Price
$525,000
Sold Price
$506,000
Premium/Discount to List
-$19,000
-3.62%
Views
55
Current Estimated Value
$528,456

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$22,456
Avg. Annual Appreciation
5.18%

Purchase Details

Listed on
Feb 12, 2021
Closed on
Apr 9, 2021
Sold by
Pollard Francis T and Pollard Cynthia A
Bought by
Vance Coyd M and Vance Cynthia M
Seller's Agent
Janell Stuckwisch
Coldwell Banker Realty FM
Buyer's Agent
Patrick Eschan
Pivot Realty Group
List Price
$400,000
Sold Price
$430,000
Premium/Discount to List
$30,000
7.5%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.36%
Original Mortgage
$348,816
Interest Rate
2.9%
Mortgage Type
VA

Purchase Details

Closed on
Apr 8, 2008
Sold by
Relocation Advantage Llc
Bought by
Pollard Francis T and Pollard Cynthia A

Home Financials for this Owner

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

Purchase Details

Closed on
Apr 2, 2008
Sold by
Maldovan James and Maldovan Andra
Bought by
Relocation Advantage Llc

Home Financials for this Owner

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

Purchase Details

Closed on
Jun 16, 2006
Sold by
Purdential Relocation Inc
Bought by
Maldovan James and Maldovan Andra

Home Financials for this Owner

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

Purchase Details

Closed on
Apr 12, 2006
Sold by
Martin David R and Martin Suzanne P
Bought by
Prudential Relocation Inc

Purchase Details

Closed on
Aug 28, 1997
Sold by
Drees Co
Bought by
Martin David R and Martin Suzanne P

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$175,000
Interest Rate
5.88%
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 Type Sale Price Title Company
Deed $506,000 Excel Title
Deed $506,000 Excel Title
Warranty Deed $430,000 Agility Closing & Ttl Svcs I
Deed $295,000 Advanced Land Title Agency
Deed $295,000 Advanced Land Title Agency
Special Warranty Deed $263,650 None Available
Warranty Deed $277,500 None Available
Deed $233,355 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $348,816 VA
Previous Owner $236,000 New Conventional
Previous Owner $188,650 New Conventional
Previous Owner $175,000 New Conventional
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
01/27/2025 01/27/25 Sold $506,000 -3.6% $273 / Sq Ft
12/09/2024 12/09/24 Pending -- -- --
11/14/2024 11/14/24 For Sale $525,000 +22.1% $283 / Sq Ft
04/09/2021 04/09/21 Sold $430,000 +7.5% $232 / Sq Ft View Prior Sale
02/14/2021 02/14/21 Pending -- -- --
02/12/2021 02/12/21 For Sale $400,000 -- $216 / 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 $4,332 $430,000 $35,000 $395,000
2024 $4,289 $430,000 $35,000 $395,000
2023 $4,441 $430,000 $35,000 $395,000
2022 $4,373 $430,000 $35,000 $395,000
2021 $3,894 $380,000 $35,000 $345,000
2020 $2,478 $255,730 $35,000 $220,730
2019 $2,507 $255,730 $35,000 $220,730
2018 $2,993 $255,730 $35,000 $220,730
2017 $2,918 $255,730 $35,000 $220,730
2015 $2,882 $255,730 $35,000 $220,730
2013 -- $295,000 $30,000 $265,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 628044

Northern Kentucky Multiple Listing Service

APN: 063.00-12-109.00