David Schneider
Blue Chicken Realty
(513) 586-5839
97 Total Sales
1 in Hebron
$220,000 Price
2004 Irmaleen Ln Hebron, KY 41048
Hebron AreaEstimated Value: $1,102,000 - $1,470,058
4
Beds
6
Baths
7,000
Sq Ft
$184/Sq Ft
Est. Value
Highlights
- Eat-In Gourmet Kitchen
- Lake View
- 1.11 Acre Lot
- North Pointe Elementary School Rated A
- Waterfront
- Open Floorplan
About This Home
As of February 2023Stunning Sutter Custom Built 5 BDRM (4 BDRM + 2ND Floor Bonus RM), 6 Bath, 3 Car Garage, Arts & Crafts MASTERPIECE Perfectly Appointed on a Phenomenal 1.11 Acre Homesite in Desirable Rivershore Farms! This MASSIVE ESTATE w/ 9,615 Gross SQ FT (Realist) & 3 FIN LEVELS Boasts an Outstanding Waterfront Setting, Huge Covered Porch, & Seasonal River View from 2ND Floor. Low County Tax Rate/Award Winning North Pointe Elementary, Conner Middle, & Conner High Schools/Impressive Entry w/Handcrafted Front Door/Spectacular Fit & Finish w/the Ultimate in Quality Craftsmanship & Meticulous Attention to Detail/State of the Art Improvements/Incredible Gourmet KIT w/Double Oven, Granite Counters, & Walk-In Pantry/ Hearth RM/ Fabulous, 1ST FL OWNER'S SUITE & 1ST FL Study w/Adjacent Full Bath Which Could be Used as 2ND, 1ST FL BDRM/10 FT Ceilings/Fantastic Custom Appointments, & High-End Finishes/Plushly FIN LL w/Amazing Bar, Theatre, Walkout, & Fitness Area/Lots of Storage/Geo-Thermal Heating & Cooling/Pella Windows/2 FP's/2 Staircases/ + Much More! Enjoy the Unsurpassed LIFESTYLE this Very Special Property Provides for Even the Most Distinguished Taste!
Last Agent to Sell the Property
RE/MAX Victory + Affiliates License #187308 Listed on: 09/26/2022
Last Buyer's Agent
Jane Ashcraft-West
Huff Realty - Florence
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 2005
Lot Details
- 1.11 Acre Lot
- Waterfront
- Cul-De-Sac
- Private Entrance
- Year Round Access
- Level Lot
- Cleared Lot
- Wooded Lot
- Private Yard
HOA Fees
- $30 Monthly HOA Fees
Parking
- 3 Car Attached Garage
- Side Facing Garage
- Driveway
- Off-Street Parking
Property Views
- Lake
- Woods
Home Design
- Craftsman Architecture
- Poured Concrete
- Shingle Roof
- Composition Roof
- HardiePlank Type
- Stone
Interior Spaces
- 7,000 Sq Ft Home
- 2-Story Property
- Open Floorplan
- Wet Bar
- Home Theater Equipment
- Wired For Sound
- Built-In Features
- Bookcases
- Crown Molding
- Coffered Ceiling
- Tray Ceiling
- Cathedral Ceiling
- Ceiling Fan
- Recessed Lighting
- Chandelier
- Stone Fireplace
- Insulated Windows
- Window Treatments
- French Doors
- Panel Doors
- Entrance Foyer
- Family Room with Outdoor Entry
- Family Room
- Living Room with Fireplace
- Breakfast Room
- Formal Dining Room
- Library
- Bonus Room
- Storage Room
- Home Gym
Kitchen
- Eat-In Gourmet Kitchen
- Breakfast Bar
- Butlers Pantry
- Double Oven
- Gas Cooktop
- Microwave
- Dishwasher
- Wine Cooler
- Kitchen Island
- Granite Countertops
- Solid Wood Cabinet
Flooring
- Wood
- Carpet
- Ceramic Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- En-Suite Primary Bedroom
- Walk-In Closet
- Dressing Area
- Dual Vanity Sinks in Primary Bathroom
- Jetted Soaking Tub in Primary Bathroom
- Primary Bathroom Bathtub Only
- Primary Bathroom includes a Walk-In Shower
Laundry
- Laundry Room
- Laundry on main level
- Laundry Chute
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Finished Basement Bathroom
- Stubbed For A Bathroom
- Basement Storage
Outdoor Features
- Pond
- Lake Property
- Covered Patio or Porch
Schools
- North Pointe Elementary School
- Conner Middle School
- Conner Senior High School
Utilities
- Central Air
- Geothermal Heating and Cooling
- High Speed Internet
- Cable TV Available
Community Details
- Association fees include association fees
- Stonegate Management Jessica Association, Phone Number (859) 534-0900
Listing and Financial Details
- Assessor Parcel Number 034.00-02-110.00
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
Closed on
May 3, 2024
Sold by
Warden Phillip Matthew and Warden Phil M
Bought by
Current Estimated Value
Purchase Details
Listed on
Sep 26, 2022
Closed on
Feb 7, 2023
Sold by
Neither Paul M and Neither Tracy A
Bought by
Warden Phil M and Warden Abigale T
Seller's Agent
Jane Ashcraft-West
RE/MAX Victory + Affiliates
Buyer's Agent
Jane Ashcraft-West
RE/MAX Victory + Affiliates
List Price
$1,195,000
Sold Price
$1,125,000
Premium/Discount to List
-$70,000
-5.86%
Views
154
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.86%
Original Mortgage
$300,000
Interest Rate
6.75%
Mortgage Type
New Conventional
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Hebron, KY
-
David Schneider
-
Kimberly Nachazel
Kimberly Nachazel
eXp Realty, LLC
(513) 802-9458
132 Total Sales
3 in Hebron
$465K - $640K Price Range
-
Chris Kennedy
Chris Kennedy
Sibcy Cline, REALTORS-Florence
(513) 586-6325
103 Total Sales
2 in Hebron
$400K - $455K Price Range
-
Lisa Brandenburg
Lisa Brandenburg
Responds QuicklyHuff Realty - Florence
(513) 657-2418
132 Total Sales
6 in Hebron
$242K - $522K Price Range
-
Tom Sturm
Tom Sturm
Coldwell Banker Realty
(513) 586-4566
232 Total Sales
1 in Hebron
$415,000 Price
-
Sara Scheyer-Arnett
Sara Scheyer-Arnett
RE/MAX Victory + Affiliates
(859) 600-0275
91 Total Sales
9 in Hebron
$100K - $585K 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 |
|---|---|---|---|
| -- | None Listed On Document | ||
| Warden Phil M | $1,125,000 | Kentucky Land Title |
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 | $135,000 | ||
| Open | Warden Phillip Matthew | $312,300 | |
| Previous Owner | Warden Phil M | $300,000 | |
| Previous Owner | Neltner Paul M | $361,000 | |
| Previous Owner | Neltner Paul M | $395,000 | |
| Previous Owner | Neltner Paul M | $410,000 | |
| Previous Owner | Neltner Paul M | $417,000 | |
| Previous Owner | Neltner Paul M | $417,000 | |
| Previous Owner | Neltner Paul M | $138,000 | |
| Previous Owner | Neltner Paul M | $183,000 | |
| Previous Owner | Neltner Paul M | $417,000 | |
| Previous Owner | Neltner Paul M | $250,000 | |
| Previous Owner | Neltner Paul M | $400,000 |
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 |
|---|---|---|---|---|
| 02/07/2023 02/07/23 | Sold | $1,125,000 | -5.9% | $161 / Sq Ft |
| 12/23/2022 12/23/22 | Pending | -- | -- | -- |
| 09/26/2022 09/26/22 | For Sale | $1,195,000 | -- | $171 / 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 | $11,972 | $1,125,000 | $100,000 | $1,025,000 |
| 2024 | $11,758 | $1,125,000 | $100,000 | $1,025,000 |
| 2023 | $8,384 | $785,000 | $100,000 | $685,000 |
| 2022 | $8,421 | $785,000 | $100,000 | $685,000 |
| 2021 | $8,482 | $785,000 | $100,000 | $685,000 |
| 2020 | $8,563 | $785,000 | $100,000 | $685,000 |
| 2019 | $8,465 | $770,000 | $100,000 | $670,000 |
| 2018 | $8,406 | $770,000 | $100,000 | $670,000 |
| 2017 | $7,630 | $700,000 | $70,000 | $630,000 |
| 2015 | $7,574 | $700,000 | $70,000 | $630,000 |
| 2013 | -- | $700,000 | $70,000 | $630,000 |
Source: Public Records
Agents Affiliated with this Home
-
Jane Ashcraft-West
Seller's Agent in 2023
Jane Ashcraft-West
RE/MAX
(859) 283-9888
314 Total Sales
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 608229
APN: 034.00-02-110.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
- 720 Broomtail Ln
- 2071 Madison Dr
- 2059 Madison Dr
- 2011 Falling Water Ln
- 1833 Patton Dr
- 1413 Brookline Ct
- 1530 Autumn Ridge Dr
- 966 Surfridge Dr
- 1078 Glenhurst Ct
- 1537 Autumn Ridge Dr
- 2309 Bentwood Ct
- 1709 Ledgestone Way
- 1631 Stone Crest Dr
- 1745 Ledgestone Way
- 1450 Topaz Trace Ct
- 400 Three Rivers Pkwy
- 7222 Catalpa Rd
- 160 1st St
- 1465 Topaz Trace Ct
- 7160 River Rd
- 2008 Irmaleen Ln
- 2009 Irmaleen Ln
- 607 Rivershore Dr
- 2005 Irmaleen Ln
- 1722 Coachtrail Dr
- 603 Rivershore Dr
- 2013 Irmaleen Ln
- 68 Rivershore Dr
- 12 Rivershore Dr Unit 12
- 4 Rivershore Dr Unit 4
- 8 Rivershore Dr
- 21 Rivershore Dr Unit 21
- 90 Rivershore Dr
- 0 Rivershore Dr
- 627 Rivershore Dr
- 1726 Coachtrail Dr
- 1700 Coachtrail Dr
- 606 Rivershore Dr
- 610 Rivershore Dr
- 1723 Coachtrail Dr
Your Personal Tour Guide
Ask me questions while you tour the home.