$550,000
SOLD JUN 18, 2026

1047 Bayswater Dr Union, KY 41091

3 Beds
3.5 Baths
1,855 Sq Ft
0.42 Acres Lot

Sale Details

Date Sold: June 18, 2026

$296 Per Sq Ft

7 Days on Market

Highlights

  • Wine Cellar
  • Media Room
  • Open Floorplan
  • Shirley Mann Elementary School Rated A
  • View of Trees or Woods
  • Cathedral Ceiling

About This Home

As of June 2026

As you pull up to this stunning 3-bed/4-bath/ plus Den home you will be captivated by the classic red brick exterior w/the contrast of traditional elegance of the black shutters & black leaded glass front door & sidelight accented by the updated black exterior lighting. It is a true testament to traditional timeless beauty. The inviting front porch extends a warm welcome to come inside and explore the charm within. As you step through the front door you immediately feel a warm hug as you take in all the beauty of this professionally decorated home w/many upgrades including updated lighting, refinished hardwood flooring, freshly painted interior along w/custom closet in primary suite, custom pantry w/double doors, custom laundry room, new carpet, new roof. The two-story foyer seamlessly extends from the dining room into the vaulted living room. enhanced by the gas fireplace. The large kitchen with two islands, open to the eat-in- dining is perfect for entertaining friends and family.
Mr. Chef says, ''This is a chefs dream kitchen with the gas range, custom kitchen cabinets that have numerous pull-out drawers giving you an endless amount of storage. The beautiful new sliding door brings in a lot more natural light connecting the inside out to the covered rear patio featuring a beautiful stone fireplace, ideal for entertaining. The rear patio offers enhanced privacy as a result of the newly landscaped yard.
The first floor boasts a luxurious primary suite, providing convenience and privacy. The finished basement is an entertainer's dream, complete with a bar, a theatre room for movie nights, and a temperature-controlled wine cellar for wine enthusiasts. This pristine corner lot in an established neighborhood, surrounded by huge maple trees. The neighborhood has great amenities, including two community pools, tennis courts, & a playground, making it a perfect place for active lifestyles. This home is a perfect combination of elegance and comfort in a picturesque setti

Last Agent to Sell the Property

Bridget Day

ERA Real Solutions Realty License #216990 Listed on: 05/04/2026

ERA Real Solutions Realty

Last Buyer's Agent

Christine Graham

Coldwell Banker Realty FM License #185331

Coldwell Banker Realty FM

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1995

Lot Details

  • 18,295 Sq Ft Lot
  • Property fronts a county road
  • Cul-De-Sac
  • Corner Lot
  • Land Lease

HOA Fees

  • $60 Monthly HOA Fees

Parking

  • Attached Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway

Home Design

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

Interior Spaces

  • 1,855 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Home Theater Equipment
  • Sound System
  • Built-In Features
  • Crown Molding
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Wood Burning Fireplace
  • Fireplace Features Blower Fan
  • Stone Fireplace
  • Gas Fireplace
  • Vinyl Clad Windows
  • Double Hung Windows
  • Sliding Doors
  • Panel Doors
  • Entrance Foyer
  • Wine Cellar
  • Living Room
  • Breakfast Room
  • Formal Dining Room
  • Media Room
  • Den
  • Game Room
  • Workshop
  • Storage Room
  • Utility Room
  • Views of Woods

Kitchen

  • Eat-In Kitchen
  • Gas Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • En-Suite Bathroom
  • Walk-In Closet
  • Double Vanity
  • Bathtub with Shower
  • Shower Only

Laundry

  • Laundry Room
  • Laundry on main level
  • Stacked Washer and Dryer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Basement Storage

Home Security

  • Home Security System
  • Security Lights
  • Smart Thermostat
  • Fire and Smoke Detector
  • Fire Sprinkler System

Outdoor Features

  • Covered Patio or Porch
  • Water Fountains
  • Exterior Lighting

Schools

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

Utilities

  • Humidifier
  • Forced Air Zoned Cooling and Heating System
  • Heating System Uses Natural Gas
  • Underground Utilities
  • Tankless Water Heater
  • Water Softener
  • High Speed Internet
  • Cable TV Available

Community Details

Overview

  • Hempsteade Vertex Association, Phone Number (859) 495-5214

Recreation

  • Tennis Courts
  • Community Playground
  • Community Pool

Home Details

Home Type

Single Family

Year Built

Built in 1995

Lot Details

0.42 Acres

HOA Fees

$60 per month

Parking

2

Listing Details

  • Cooling: Central Air, Zoned
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.42
  • Year Built: 1995
  • Lot Size: irregular
  • Road Frontage Type: County Road
  • Road Surface Type: Paved
  • Ownership: Agent/Owner
  • Directions: Heading East on Mount Zion Rd, Turn Left onto Hempsteade Dr stay straight, Turn Right on Bayswater Drive (Hempsteade Manor) house is on the left, corner of Lurawoods and Bayswater.
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: Yes
  • Structure Type: House
  • Contract Info:Auction YN: No
  • General Property Description:Basement YN2: Yes
  • Utilities Electric Company: Duke
  • Utilities Gas Company: Duke
  • Water Company: Boone county water
  • Room Details:Family Room YN: No
  • Room Details:Formal Dining Rm YN: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Ceiling Fan(s), Recessed Lighting, Multi Panel Doors, Crown Molding, Vaulted Ceiling(s), Chandelier, Double Vanity, Eat-in Kitchen, Entrance Foyer, Granite Counters, High Speed Internet, Kitchen Island, Open Floorplan, Pantry, Smart Thermostat, Stone Counters, Storage, Walk-In Closet(s), Wet Bar
  • Basement: Full, Full Finished Bath, Finished, Storage Space
  • Heating: Forced Air, Natural Gas
  • Levels: Two
  • Property Type: Residential
  • Appliances: Disposal, Dishwasher, Microwave, Refrigerator, Washer, Water Softener, Tankless Water Heater, Wine Cooler, Gas Range, Washer/Dryer Stacked, Stainless Steel Appliance(s), See Remarks
  • Other Equipment: Humidifier, Sump Pump, Home Theater
  • Accessibility Features: None
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Door Features: Sliding Doors
  • Fireplace Features: Blower Fan, Gas, Wood Burning, Stone, See Remarks
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 1855.0
  • Window Features: Insulated Windows, Vinyl Frames, Double Hung

Exterior Features

  • View: Trees/Woods
  • Roof: Shingle
  • Lot Features: Cul-De-Sac, Corner Lot
  • View: Yes
  • Construction Type: Stone, Vinyl Siding
  • Exterior Features: Lighting, Fountain
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Patio, Covered

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Driveway, Garage Faces Side, Garage Door Opener, Garage

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Electric Dryer Hookup, Main Level, Washer Hookup
  • Security: Security Lights, Smoke Detector(s), Security System, Fire Sprinkler System
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available, Underground Utilities

Condo/Co-op/Association

  • Amenities: Pool, Tennis Court(s), Playground
  • Association Fee: 360.0
  • Association Fee Frequency: Semi-Annually
  • Association: Yes

Association/Amenities

  • Association Information:Association Management Name 1: Hempsteade Vertex
  • Association Information:Association Management Phone 1: 859-495-5214
  • Association Information:Total Yearly Fees: 720.0
  • Association Information:Association Fee 3 Frequency: Semi-Annually

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

  • Land Lease: Yes
  • Lot Size Sq Ft: 18295.0
  • Zoning Description: Residential

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 14, 2024
Closed on
Jan 27, 2025
Sold by
Bought by
Seller's Agent
Janell Stuckwisch
eXp Realty, LLC - Janell
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

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.75%

Purchase Details

Listed on
Feb 12, 2021
Closed on
Apr 9, 2021
Sold by
Bought by
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
Bought by

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
Bought by

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
Bought by

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
Bought by

Purchase Details

Closed on
Aug 28, 1997
Sold by
Bought by

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
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
06/18/2026 06/18/26 Sold $550,000 0.0% $296 / Sq Ft
05/11/2026 05/11/26 Pending -- -- --
05/04/2026 05/04/26 For Sale $550,000 +8.7% $296 / Sq Ft
01/27/2025 01/27/25 Sold $506,000 -3.6% $273 / Sq Ft View Prior Sale
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 642221

Northern Kentucky Multiple Listing Service

APN: 063.00-12-109.00

Your Personal Tour Guide

Ask me questions while you tour the home.