John Lorms Home Team
Keller Williams Realty Service
(859) 888-0644
142 Total Sales
81 in Union
$130K - $1.8M Price Range
2459 Saint Philip Ct Union, KY 41091
Union AreaEstimated Value: $604,060
4
Beds
3.5
Baths
3,360
Sq Ft
$180/Sq Ft
Est. Value
Highlights
- Gourmet Kitchen
- Lake View
- Clubhouse
- Erpenbeck Elementary School Rated A
- Open Floorplan
- Wooded Lot
About This Home
As of March 2022Completely custom, exceptional quality 2-story with FIRST floor Primary Bedroom w/private spa bath, large shower, private water closet & 2 walk-in closets w/built ins*Stained glass transom windows*2-story great room overlooks the private, fenced backyard/patio*PREMIER view of trees and lake in the distance*3 car oversized side entry garage*Hardwood flooring throughout the first floor*Open kitchen features granite countertops & bar, wall ovens, cooktop, abundant cabinetry & pantry*Upstairs ~ new carpet throughout*Downstairs ~ a hidden game/theater room*
Last Agent to Sell the Property
RE/MAX Victory + Affiliates License #190887 Listed on: 01/29/2022
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 2006
Lot Details
- 15,484 Sq Ft Lot
- Cul-De-Sac
- Private Entrance
- Fenced
- Landscaped
- Wooded Lot
- Private Yard
Parking
- 3 Car Garage
- Side Facing Garage
- Garage Door Opener
Property Views
- Lake
- Woods
Home Design
- Transitional Architecture
- Brick Veneer
- Poured Concrete
- Composition Roof
- Vinyl Siding
Interior Spaces
- 3,360 Sq Ft Home
- 2-Story Property
- Open Floorplan
- Central Vacuum
- Built-In Features
- Bookcases
- Chair Railings
- Cathedral Ceiling
- Ceiling Fan
- Recessed Lighting
- Chandelier
- Fireplace Features Blower Fan
- Marble Fireplace
- Gas Fireplace
- Vinyl Clad Windows
- Insulated Windows
- Window Treatments
- Picture Window
- Panel Doors
- Entrance Foyer
- Great Room
- Family Room
- Living Room
- Breakfast Room
- Formal Dining Room
- Bonus Room
- Game Room Downstairs
- Workshop
- Storage Room
- Basement Fills Entire Space Under The House
- Fire and Smoke Detector
Kitchen
- Gourmet Kitchen
- Breakfast Bar
- Double Oven
- Electric Oven
- Electric Cooktop
- Microwave
- Dishwasher
- Stainless Steel Appliances
- Granite Countertops
- Solid Wood Cabinet
- Disposal
Flooring
- Wood
- Carpet
- Ceramic Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- Primary Bedroom on Main
- En-Suite Primary Bedroom
- Walk-In Closet
- Dressing Area
- Dual Vanity Sinks in Primary Bathroom
- Soaking Tub in Primary Bathroom
- Primary Bathroom Bathtub Only
- Soaking Tub
- Primary Bathroom includes a Walk-In Shower
Laundry
- Laundry Room
- Laundry on main level
- Washer and Electric Dryer Hookup
Outdoor Features
- Covered Patio or Porch
Schools
- Erpenbeck Elementary School
- Ockerman Middle School
- Cooper High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- 220 Volts
- High Speed Internet
Listing and Financial Details
- Home warranty included in the sale of the property
- Assessor Parcel Number 051.00-05-284.00
Community Details
Overview
- Property has a Home Owners Association
- Association fees include association fees, management
- Vertex Association, Phone Number (859) 491-5711
Recreation
- Community Pool
Additional Features
- Clubhouse
- On-Site Manager or Management
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 29, 2022
Closed on
Mar 29, 2022
Sold by
Moreland Brain D and Moreland Kimberly K
Bought by
Seller's Agent
Vickie House
RE/MAX Victory + Affiliates
Buyer's Agent
Nicole Riegler
RE/MAX Victory + Affiliates
Sold Price
$500,000
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
$104,060
Avg. Annual Appreciation
4.28%
Purchase Details
Closed on
Feb 7, 2014
Sold by
Moreland Brian D and Moreland Kimberly K
Bought by
Howe Alison L and Howe Jeffrey J
Purchase Details
Closed on
Sep 30, 2013
Sold by
Stelmak Shawn R and Stelmak Suzanne M
Bought by
Moreland Brian D and Moreland Kimberly K
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$346,750
Interest Rate
4.57%
Mortgage Type
New Conventional
Purchase Details
Closed on
Dec 18, 2006
Sold by
Fischersingle Family Homes Ii
Bought by
Stelamrk Shawn R and Stelamrk Suzanne M
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$319,089
Interest Rate
6.1%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jul 20, 2006
Sold by
Grand Communities Ltd
Bought by
Fishcer Single Family Home Ii Llc
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Union, KY
-
John Lorms Home Team
-
Varun Varma
Varun Varma
Coldwell Banker Realty FM
(513) 866-5856
244 Total Sales
9 in Union
$360K - $1M Price Range
-
Cami Diodonet
Cami Diodonet
Keller Williams Realty Service
(859) 279-4233
88 Total Sales
3 in Union
$183K - $362K Price Range
-
Josh Denigan
JD
Josh Denigan
Hillcrest Realty, LLC
(859) 888-1762
14 Total Sales
2 in Union
$410K - $594K Price Range
-
Ben Schreiber
Ben Schreiber
eXp Realty, LLC
(859) 600-6189
90 Total Sales
11 in Union
$347K - $840K Price Range
-
Julia Gootee
Julia Gootee
Sibcy Cline, REALTORS-Florence
(859) 600-0720
54 Total Sales
6 in Union
$227K - $570K 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 |
|---|---|---|---|
| $500,000 | Northwest Title | ||
| Howe Alison L | -- | None Available | |
| Moreland Brian D | $365,000 | Kentucky Land Title Agency I | |
| Stelamrk Shawn R | -- | Homestead Title Agency Ltd | |
| Fishcer Single Family Home Ii Llc | $54,000 | None Available |
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 |
|---|---|---|---|
| Previous Owner | $695,000 | ||
| Previous Owner | Moreland Brian D | $52,000 | |
| Previous Owner | Moreland Brian D | $334,500 | |
| Previous Owner | Moreland Brian D | $346,750 | |
| Previous Owner | Stelmak Shawn R | $308,000 | |
| Previous Owner | Stelamrk Shawn R | $319,089 |
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 |
|---|---|---|---|---|
| 03/25/2022 03/25/22 | Sold | $500,000 | +5.3% | $149 / Sq Ft |
| 02/27/2022 02/27/22 | Pending | -- | -- | -- |
| 02/25/2022 02/25/22 | For Sale | -- | -- | -- |
| 02/04/2022 02/04/22 | Pending | -- | -- | -- |
| 01/29/2022 01/29/22 | For Sale | $475,000 | -- | $141 / 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,683 | $499,500 | $44,500 | $455,000 |
| 2024 | $4,588 | $499,500 | $44,500 | $455,000 |
| 2023 | $4,710 | $499,500 | $44,500 | $455,000 |
| 2022 | $4,734 | $499,500 | $44,500 | $455,000 |
| 2021 | $4,434 | $364,500 | $44,500 | $320,000 |
| 2020 | $3,535 | $364,500 | $44,500 | $320,000 |
| 2019 | $3,566 | $364,500 | $44,500 | $320,000 |
| 2018 | $3,578 | $364,500 | $44,500 | $320,000 |
| 2017 | $3,528 | $364,500 | $44,500 | $320,000 |
| 2015 | $3,499 | $364,500 | $44,500 | $320,000 |
| 2013 | -- | $370,000 | $45,000 | $325,000 |
Source: Public Records
Agents Affiliated with this Home
-
Vickie House
Seller's Agent in 2022
Vickie House
RE/MAX
(859) 512-7070
27 Total Sales
-
Nicole Riegler
Buyer's Agent in 2022
Nicole Riegler
RE/MAX
(859) 866-3261
155 Total Sales
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 601053
APN: 051.00-05-284.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
- 2583 Saint Charles Cir
- 8780 Marais Dr
- 8900 Cimmaron Trail
- 8759 Marais Dr
- 8812 Marais Dr
- 8901 Cimmaron Trail
- 8813 Marais Dr
- 4069 Cardiff St
- 3228 Roseland Place
- 4078 Cardiff St
- 4096 Cardiff St
- 3217 Roseland Place
- 2381 Longbranch Rd-Lot 3 Rd
- 2381 Longbranch Rd-Lot 4 Rd
- 2381 Longbranch Rd-Lot 1 Rd
- 9350 Westfield Ln
- 7100 Desmond Ln
- 6201 Ballyshannon Dr
- 8380 Orleans Blvd
- 2221 Shay Ct
- 2459 St Philip Ct
- 2455 Saint Philip Ct
- 2462 Saint Philip Ct
- 2466 Saint Philip Ct
- 2548 Beauregard Place
- 2544 Beauregard Place
- 2544 Beauregard Place Unit 316
- 2458 Saint Philip Ct
- 8668 Marais Dr
- 8672 Marais Dr
- 2454 Saint Philip Ct
- 2552 Beauregard Place Unit 318
- 8676 Marais Dr
- 8676 Marais Dr Unit 288
- 8660 Marais Dr
- 2553 Beauregard Place
- 2549 Beauregard Place
- 2545 Beauregard Place
- 2545 Beauregard Place Unit 321
- 8649 Marais Dr
Your Personal Tour Guide
Ask me questions while you tour the home.