NOT LISTED FOR SALE

2459 Saint Philip Ct Union, KY 41091

Estimated Value: $600,000 - $652,000

4 Beds
3.5 Baths
3,360 Sq Ft
$187/Sq Ft Est. Value

Last Sold March 25, 2022

Last sale price $500,000 $149 Per Sq Ft

Est. 25% increase in value since last sale

Current estimated payment $3,619/month

28 Days on Market

Highlights

  • Gourmet Kitchen
  • Lake View
  • Clubhouse
  • Erpenbeck Elementary School Rated A
  • Open Floorplan
  • Wooded Lot

About This Home

As of March 2022

Completely 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

Vickie House

RE/MAX Victory + Affiliates License #190887 Listed on: 01/29/2022

RE/MAX Victory + Affiliates

Last Buyer's Agent

Nicole Riegler

RE/MAX Victory + Affiliates License #198576

RE/MAX Victory + Affiliates

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2006

Lot Details

  • 0.36 Acre 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
  • Resident Manager or Management On Site

Home Details

Home Type

Single Family

Year Built

Built in 2006

Lot Details

0.36 Acres

Parking

3

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.36
  • Year Built: 2006
  • Lot Size: Irregular
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Directions: I-75 Exit at US 42 South approximately 2.5 miles, R on OLD US 42, Right on Orleans Blvd, continue straight 1/2 mile to Left on Marais, Left on St. Phillip to cul-de-sac on Right.
  • Architectural Style: Transitional
  • 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: Erpenbeck Elementary
  • Location Tax Legal Info:Middle or Junior School: Ockerman Middle School
  • Location Tax Legal Info:High School: Cooper High School
  • Location Tax Legal Info:Subdivision2: Orleans South
  • 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: Irregular
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Room Type:Dining Room4: Yes
  • Room Type:Entry: Yes
  • Room Type:Laundry Room3: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Natural Gas Available: Yes
  • Utilities Gas Company: Duke Energy
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 0.3555
  • General Property Description:Living Area: 3360.0
  • General Property Description:Lot Size Square Feet: 15484.0
  • Structure Type:House: Yes
  • Laundry Features:Laundry Room2: Yes
  • Laundry Features:Main Level: Yes
  • Miscellaneous Home Warranty: Yes
  • Room Type:Breakfast Room2: Yes
  • Room Type:Breakfast Room Level: First
  • Security Features:Smoke Detector(s): Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 051.00-05-284.00
  • Appliances Refrigerators: Yes
  • Laundry Features:Electric Dryer Hookup: Yes
  • Laundry Features:Washer Hookup: Yes
  • Roof:Composition: Yes
  • Room Type:Living Room4: Yes
  • General Property Description:Fireplaces Total: 1
  • View:TreesWoods: Yes
  • Architecture:Transitional: Yes
  • Room Type:Bonus Room2: Yes
  • Utilities:Sewer Available: Yes
  • Utilities:Water Available: Yes
  • Room Type:Game Room: Yes
  • Room Type:Game Room Level: Lower
  • Room Type:Great Room4: Yes
  • Great Room Features:Recessed Lighting2: Yes
  • Entry Features:Wood Flooring: Yes
  • Bonus Room Features:Carpet Flooring12: Yes
  • Laundry Room Features:Built-in Features6: Yes
  • Great Room Features:Wood Flooring9: Yes
  • Great Room Features:Ceiling Fan(s)4: Yes
  • Great Room Features:High Ceiling(s)3: Yes
  • View:Lake2: Yes
  • Room Type:Workshop2: Yes
  • Room Type:Workshop Level: First
  • Workshop Features:Storage7: Yes
  • Entry Features:Private Entry: Yes
  • Bonus Room Features:Storage8: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Walk-In Closet(s), Storage, Soaking Tub, Pantry, Open Floorplan, High Speed Internet, Granite Counters, Entrance Foyer, Double Vanity, Chandelier, Bookcases, Breakfast Bar, Built-in Features, 220 Volts, Cathedral Ceiling(s), Ceiling Fan(s), Central Vacuum, High Ceilings, Multi Panel Doors, Recessed Lighting, Vaulted Ceiling(s), Master Downstairs
  • Basement: Full
  • Heating: Natural Gas, Forced Air
  • Levels: Two
  • Property Type: Residential
  • Appliances: Stainless Steel Appliance(s), Electric Cooktop, Electric Oven, Dishwasher, Disposal, Double Oven, Microwave, Refrigerator
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: Blower Fan, Gas, Marble
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 3360.0
  • Window Features: Insulated Window(s), Picture Window(s), Vinyl Clad Window(s)
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Double Oven: Yes
  • Appliances:Electric Oven: 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:Entrance Foyer2: Yes
  • Interior Features:Granite Counters: Yes
  • Interior Features:High Ceilings: 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
  • Kitchen Features:Granite Countertops: Yes
  • Primary Bedroom Features:Ceiling Fan(s)8: Yes
  • Kitchen Features Pantry: Yes
  • Kitchen Features:Wood Cabinets: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Kitchen Features:Walk-Out Access3: Yes
  • Primary Bath Features:Shower: Yes
  • Interior Features:Primary Downstairs: Yes
  • Living Room Features:Wood Flooring2: Yes
  • Dining Room Features:Wood Flooring3: Yes
  • Kitchen Features:Wood Flooring4: Yes
  • Fireplace Features:Gas: Yes
  • Interior Features:High Speed Internet: Yes
  • Interior Features:Breakfast Bar2: Yes
  • Interior Features:Cathedral Ceiling(s): Yes
  • Interior Features:Chandelier2: Yes
  • Interior Features:Vaulted Ceiling(s): Yes
  • Living Room Features:Window Treatments: Yes
  • Dining Room Features:Chandelier: Yes
  • Kitchen Features:Breakfast Bar: Yes
  • Kitchen Features:Window Treatments3: Yes
  • Primary Bedroom Features:Window Treatments6: Yes
  • Appliances:Electric Cooktop: Yes
  • Primary Bath Features:Soaking Tub2: Yes
  • Primary Bedroom Features:High Ceiling(s)6: Yes
  • Interior Features:Recessed Lighting: Yes
  • Interior Features:Bookcases4: Yes
  • Interior Features:Central Vacuum: Yes
  • Interior Features:Soaking Tub: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Kitchen Features:Recessed Lighting3: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Primary Bedroom Features:Wood Flooring7: Yes
  • Fireplace Features:Blower Fan: Yes
  • Primary Bedroom Features:Cathedral Ceiling(s)2: Yes
  • Primary Bath Features:Ceramic Tile Flooring: Yes
  • Primary Bath Features:Tub: Yes
  • Primary Bath Features:Shower With Bench: Yes
  • Primary Bath Features:Tile Flooring4: Yes
  • Primary Bedroom Features:Dressing Area: Yes
  • Primary Bath Features:Window Treatments7: Yes
  • Dining Room Features:Chair Rail: Yes
  • Fireplace Features:Marble: Yes
  • Interior Features 220 Volts: Yes

Exterior Features

  • View: Lake, Trees/Woods
  • Roof: Composition
  • Lot Features: Cul-De-Sac, Wooded
  • View: Yes
  • Home Warranty: Yes
  • Construction Type: Brick Veneer, Vinyl Siding
  • Exterior Features: Fenced, Private Yard
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Patio, Porch
  • Construction Materials:Vinyl Siding: 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
  • Window Features:Picture Window(s): Yes
  • Window Features:Vinyl Clad Window(s): Yes
  • Exterior Features:Fenced: Yes
  • Lot Features:Wooded: Yes
  • Lot Features:Cul-De-Sac: Yes
  • Construction Materials:Brick Veneer: Yes
  • Exterior Features:Private Yard: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Garage Door Opener, Garage Faces Side, Oversized
  • General Property Description:Garage Spaces: 3.0
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Oversized: Yes
  • Parking Features:Garage Faces Side: Yes

Utilities

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

Condo/Co-op/Association

  • Amenities: Landscaping, Pool, Clubhouse
  • Association: Yes

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: Vertex
  • Association Information:Association Management Phone 1: (859) 491-5711
  • Association Information:Total Yearly Fees: 560.0
  • Association Fee Includes:Association Fees: Yes
  • Association Amenities:Management: Yes
  • Association Amenities:Clubhouse: Yes
  • Association Amenities:Pool5: Yes
  • Association Amenities:Landscaping: Yes

Fee Information

  • Association Fee Includes: Association Fees, Management

Schools

  • Elementary School: Erpenbeck Elementary
  • Junior High Dist: Boone Co Public
  • High School: Cooper High School
  • Middle Or Junior School: Ockerman Middle School

Lot Info

  • Lot Size Sq Ft: 15484.0
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Ownership History

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
Cary Richard D and Cary Lori A
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
$627,279

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$127,279
Avg. Annual Appreciation
5.89%

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

Date Buyer Sale Price Title Company
Cary Richard D $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

Date Status Borrower Loan Amount
Previous Owner Moreland Brian D $346,750
Previous Owner Stelamrk Shawn R $319,089
Source: Public Records

Property History

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

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

  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 601053

Northern Kentucky Multiple Listing Service

APN: 051.00-05-284.00

Your Personal Tour Guide

Ask me questions while you tour the home.