Lena Keith
Responds Quickly
Pivot Realty Group
(859) 279-4304
111 Total Sales
5 in Union
$173K - $558K Price Range
1003 Bayswater Dr Union, KY 41091
Union AreaEstimated Value: $541,000 - $569,000
4
Beds
2.5
Baths
--
Sq Ft
0.48
Acre Lot
Highlights
- In Ground Pool
- Eat-In Gourmet Kitchen
- 0.48 Acre Lot
- Shirley Mann Elementary School Rated A
- View of Trees or Woods
- Open Floorplan
About This Home
As of March 2024Welcome to your dream home on a premier corner lot in the highly desirable Hempsteade community! This stunning 4-bedroom home blends spacious living with incredible recent updates for ultimate peace of mind. Step inside to a grand entry featuring a double staircase and gorgeous hardwood floors that flow seamlessly across both the first and second levels. The main floor features a private home office, a formal dining room, and an open kitchen that flows right into the family room. The kitchen includes an extra full size upright freezer and refrigerator. Upstairs, the primary suite serves as a true sanctuary with a vaulted ceiling, a double-vanity bathroom, a jetted tub, and an oversized walk-in closet. The whole home is freshly painted. The expansive basement is plumbed for a full bath. New hydra board with drain tile system and double sump pump with gel cell battery backup ensuring a dry space that can easily be finished. Your private outdoor oasis awaits in the fully fenced backyard, featuring a spectacular 9-foot-deep in-ground pool boasting a brand-new pool liner (2026) with multicolored lights for nighttime swimming. The exterior is already wired for a 220 hot tub and features a gazebo. Best of all, you can enjoy this paradise with absolute ease thanks to the maintenance-free landscaping and a brand-new front yard sprinkler system. Major mechanical updates include a brand-new HVAC system (2026) and a new water heater (2025). Truly a turn-key property you do not want to miss!
Last Agent to Sell the Property
Huff Realty - Florence License #181847 Listed on: 01/18/2024
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
Lot Details
- 20,909 Sq Ft Lot
- Lot Dimensions are 121x135x140x150
- Fenced
- Level Lot
- Wooded Lot
HOA Fees
- $53 Monthly HOA Fees
Parking
- 2 Car Garage
- Garage Door Opener
- Driveway
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Vinyl Siding
Interior Spaces
- 2-Story Property
- Open Floorplan
- Wet Bar
- Built-In Features
- Crown Molding
- Cathedral Ceiling
- Ceiling Fan
- Recessed Lighting
- Chandelier
- Brick Fireplace
- Gas Fireplace
- Insulated Windows
- French Doors
- Panel Doors
- Entrance Foyer
- Family Room with Fireplace
- Living Room
- Breakfast Room
- Formal Dining Room
- Home Office
- Storage
- Views of Woods
Kitchen
- Eat-In Gourmet Kitchen
- Breakfast Bar
- Electric Oven
- Electric Cooktop
- Dishwasher
- Kitchen Island
- Granite Countertops
Flooring
- Wood
- Concrete
Bedrooms and Bathrooms
- 4 Bedrooms
- En-Suite Primary Bedroom
- Walk-In Closet
- Dual Vanity Sinks in Primary Bathroom
- Jetted Tub in Primary Bathroom
- Primary Bathroom includes a Walk-In Shower
Laundry
- Laundry Room
- Laundry on main level
Unfinished Basement
- Stubbed For A Bathroom
- Rough-In Basement Bathroom
Home Security
- Home Security System
- Fire and Smoke Detector
Outdoor Features
- In Ground Pool
- Deck
- Covered Patio or Porch
- Gazebo
Schools
- Shirley Mann Elementary School
- Gray Middle School
- Ryle High School
Utilities
- Central Air
- Heating System Uses Natural Gas
- Cable TV Available
Listing and Financial Details
- Assessor Parcel Number 063.00-12-192.01
Community Details
Overview
- Association fees include association fees
- Vertex Association, Phone Number (859) 491-5711
Recreation
- 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
Jan 18, 2024
Closed on
Mar 18, 2024
Sold by
Shaida Punam
Bought by
Seller's Agent
Susan Huff
Huff Realty - Florence
Buyer's Agent
Missy Bricking
Keller Williams Realty Service
List Price
$500,000
Sold Price
$498,000
Premium/Discount to List
-$2,000
-0.4%
Views
256
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$53,971
Avg. Annual Appreciation
4.27%
Original Mortgage
$373,000
Outstanding Balance
$363,473
Interest Rate
6.64%
Mortgage Type
New Conventional
Estimated Equity
$188,498
Purchase Details
Listed on
Jun 3, 2023
Closed on
Jun 30, 2023
Sold by
Prince Richard E and Prince Christina L
Bought by
Shaida Punam
Seller's Agent
Nikki Culbertson
Culbertson Real Estate Group
Buyer's Agent
Nikki Culbertson
Culbertson Real Estate Group
List Price
$435,000
Sold Price
$435,000
Views
511
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
20.67%
Purchase Details
Closed on
Jun 21, 2010
Sold by
Gibb Dan and Gibb Lou Ellen
Bought by
Gibb Louise Ellen and Louise Ellen Gibb Revocable Li
Purchase Details
Closed on
Apr 16, 1998
Sold by
Easton Leon E
Bought by
Gibb Dan and Gibb Lou E
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Union, KY
-
Lena Keith
-
Ben Walling
Ben Walling
Cahill Real Estate Services
(513) 586-6760
92 Total Sales
3 in Union
$270K - $769K Price Range
-
Cherish Jessup
Cherish Jessup
Responds QuicklyeXp Realty
(859) 279-4286
74 Total Sales
8 in Union
$163K - $360K Price Range
-
Nicole Rankin
Nicole Rankin
Coldwell Banker Realty FM
(859) 651-7170
216 Total Sales
11 in Union
$160K - $610K Price Range
-
Shane Reno
Shane Reno
Huff Realty - Florence
(859) 600-0793
76 Total Sales
6 in Union
$290K - $500K Price Range
-
Richard Hubbard
Richard Hubbard
RE/MAX Victory + Affiliates
(859) 955-4553
181 Total Sales
2 in Union
$650K - $765K 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 | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $498,000 | 360 American Title Services | ||
| Shaida Punam | $435,000 | None Listed On Document | |
| Gibb Louise Ellen | -- | None Available | |
| Gibb Dan | $289,500 | -- |
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 | Borrower | Loan Amount |
|---|---|---|---|
| Open | $373,000 | ||
| Previous Owner | Shaida Punam | $259,481 | |
| Previous Owner | Prince Richard E | $337,981 | |
| Previous Owner | Prince Richard E | $333,361 |
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 |
|---|---|---|---|---|---|
| 07/25/2026 07/25/26 | Price Changed | $540,000 | -1.8% | $160 / Sq Ft | |
| 07/25/2026 07/25/26 | Price Changed | $550,000 | -4.3% | $163 / Sq Ft | |
| 07/20/2026 07/20/26 | For Sale | $575,000 | +15.5% | $170 / Sq Ft | |
| 03/18/2024 03/18/24 | Sold | $498,000 | -0.4% | -- | |
| 02/25/2024 02/25/24 | Pending | -- | -- | -- | |
| 01/19/2024 01/19/24 | For Sale | $500,000 | +14.9% | -- | |
| 06/30/2023 06/30/23 | Sold | $435,000 | 0.0% | $129 / Sq Ft | View Prior Sale |
| 06/05/2023 06/05/23 | Pending | -- | -- | -- | |
| 06/03/2023 06/03/23 | For Sale | $435,000 | -- | $129 / 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 | $5,640 | $498,000 | $35,000 | $463,000 |
| 2024 | $4,853 | $435,000 | $35,000 | $400,000 |
| 2023 | $4,084 | $358,900 | $35,000 | $323,900 |
| 2022 | $3,593 | $320,000 | $30,000 | $290,000 |
| 2021 | $3,675 | $320,000 | $30,000 | $290,000 |
| 2020 | $3,663 | $320,000 | $30,000 | $290,000 |
| 2019 | $3,707 | $320,000 | $30,000 | $290,000 |
| 2018 | $3,726 | $320,000 | $30,000 | $290,000 |
| 2017 | $3,651 | $320,000 | $30,000 | $290,000 |
| 2015 | $2,918 | $295,830 | $35,000 | $260,830 |
| 2013 | -- | $318,000 | $30,000 | $288,000 |
Source: Public Records
Agents Affiliated with this Home
-
Amy Miller
Seller's Agent in 2026
Amy Miller
Simple Fee Realty
(859) 803-9551
11 Total Sales
-
Susan Huff
Seller's Agent in 2024
Susan Huff
Huff Realty - Florence
(859) 802-2338
494 Total Sales
-
Missy Bricking
Buyer's Agent in 2024
Missy Bricking
Keller Williams Realty Service
(859) 240-7832
285 Total Sales
-
Nikki Culbertson
Seller's Agent in 2023
Nikki Culbertson
Culbertson Real Estate Group
(859) 653-0972
322 Total Sales
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 619870
APN: 063.00-12-192.01
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
- 10195 Lewis Ln
- 10285 Hempsteade Dr
- 10094 Brandsteade Ct
- 10082 Cedarwood Dr
- 10036 Cedarwood Dr
- 10058 Brandsteade Ct
- 10015 Bent Tree Cir
- 9845 Burleigh Ln
- 10008 Wild Cherry Dr
- 1311 Scottish Ln
- 1103 Ashton Ct
- 1340 Scottish Ln
- 1227 Farmcrest Dr
- 1111 Bayswater Dr
- 10392 Lanes End Cir
- 10258 Cardigan Dr
- 705 Oakridge Dr
- 1276 Frogtown Rd
- 9753 Manassas Dr
- 10641 Cheshire Ridge Dr
- 10221 Hempsteade Dr
- 1007 Bayswater Dr
- 10227 Hempsteade Dr
- 10216 Hempsteade Dr
- 10208 Lewis Ln
- 1004 Bayswater Dr
- 10210 Hempsteade Dr
- 10222 Hempsteade Dr
- 1011 Bayswater Dr
- 10204 Hempsteade Dr
- 10196 Glenfield Ct
- 10233 Hempsteade Dr
- 10213 Lewis Ln
- 10198 Hempsteade Dr
- 10204 Lewis Ln
- 10204 Lewis La
- 10234 Hempsteade Dr
- 10193 Hempsteade Dr
- 10533 Gunpowder Rd
- 10239 Hempsteade Dr
Your Personal Tour Guide
Ask me questions while you tour the home.