Donna Berling
Huff Realty - Florence
(859) 279-4544
40 Total Sales
20 in Union
$70K - $1.9M Price Range
1047 Bayswater Dr Union, KY 41091
Union Area
3
Beds
3.5
Baths
1,855
Sq Ft
0.42
Acre Lot
Highlights
- Wine Cellar
- View of Trees or Woods
- Cathedral Ceiling
- Media Room
- Open Floorplan
- Traditional Architecture
About This Home
As of June 2026As 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
ERA Real Solutions Realty License #216990 Listed on: 05/04/2026
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 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
- Insulated 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
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
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
May 4, 2026
Closed on
Jun 18, 2026
Sold by
Bought by
Seller's Agent
Bridget Day
ERA Real Solutions Realty
Buyer's Agent
Christine Graham
Coldwell Banker Realty FM
List Price
$550,000
Sold Price
$550,000
Views
29
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-2.00%
Original Mortgage
$365,000
Outstanding Balance
$365,000
Interest Rate
6.36%
Mortgage Type
New Conventional
Estimated Equity
$183,671
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
6.18%
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
$48,000
Interest Rate
6.57%
Mortgage Type
Credit Line Revolving
Purchase Details
Closed on
Apr 12, 2006
Sold by
Bought by
Purchase Details
Closed on
Aug 28, 1997
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Union, KY
-
Donna Berling
-
Bradley Treas
Bradley Treas
Huff Realty - Florence
(859) 600-0806
12 Total Sales
2 in Union
$362K - $1.2M Price Range
-
Kim Hermann
Kim Hermann
Huff Realty - CC
(859) 479-0331
237 Total Sales
7 in Union
$170K - $575K Price Range
-
Teresa Gillum
Teresa Gillum
eXp Realty
(859) 927-3267
113 Total Sales
9 in Union
$145K - $950K Price Range
-
Kellie Barter
Kellie Barter
Weichert, REALTORS - R.E. 1790
(513) 572-6995
73 Total Sales
1 in Union
$485,000 Price
-
Cullen Wainscott
Cullen Wainscott
Berkshire Hathaway HomeService
(859) 600-6518
136 Total Sales
25 in Union
$165K - $926K Price Range
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 |
|---|---|---|---|
| Warranty Deed | $550,000 | Lawyers 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 |
|---|---|---|---|
| Open | $365,000 | New Conventional | |
| Previous Owner | $348,816 | VA | |
| Previous Owner | $23,750 | New Conventional | |
| Previous Owner | $214,500 | New Conventional | |
| Previous Owner | $227,000 | New Conventional | |
| Previous Owner | $26,000 | New Conventional | |
| Previous Owner | $236,000 | New Conventional | |
| Previous Owner | $48,000 | Credit Line Revolving | |
| Previous Owner | $188,650 | 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
-
Bridget Day
B
Seller's Agent in 2026
Bridget Day
ERA Real Solutions Realty
(859) 630-4612
1 Total Sale
-
Christine Graham
Buyer's Agent in 2026
Christine Graham
Coldwell Banker Realty FM
(859) 750-4593
56 Total Sales
-
Janell Stuckwisch
Seller's Agent in 2025
Janell Stuckwisch
eXp Realty, LLC - Janell
(859) 992-1602
273 Total Sales
-
Sheila Roderick
Buyer's Agent in 2025
Sheila Roderick
Huff Realty - CC
(859) 781-5100
9 Total Sales
-
Patrick Eschan
Buyer's Agent in 2021
Patrick Eschan
Pivot Realty Group
(859) 743-3883
61 Total Sales
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 642221
APN: 063.00-12-109.00
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.
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 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Nearby Homes
- 10036 Cedarwood Dr
- 10195 Lewis Ln
- 2104 Wyndham Way
- 10285 Hempsteade Dr
- 1003 Bayswater Dr
- 1103 Ashton Ct
- 1311 Scottish Ln
- 1212 Farmcrest Dr
- 1111 Bayswater Dr
- 10094 Brandsteade Ct
- 1258 Edinburgh Ln
- 10093 Whittlesey Dr
- 10058 Brandsteade Ct
- 1276 Frogtown Rd
- 987 Lakeway Ct
- 10008 Wild Cherry Dr
- 943 Lakepointe Ct
- 10389 Brookhurst Ln N
- 11512 Gregson Ct
- 10624 Brookhurst Ln S
Your Personal Tour Guide
Ask me questions while you tour the home.