NOT LISTED FOR SALE

2004 Irmaleen Ln Hebron, KY 41048

Hebron Neighborhood

Estimated Value: $1,265,000 - $1,369,000

4 Beds
6 Baths
7,000 Sq Ft
$189/Sq Ft Est. Value

Last Sold February 07, 2023

Last sale price $1,125,000 $161 Per Sq Ft

Est. 18% increase in value since last sale

Current estimated payment $8,270/month

87 Days on Market

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 2023

Stunning 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

Jane Ashcraft-West

RE/MAX Victory + Affiliates License #187308 Listed on: 09/26/2022

RE/MAX Victory + Affiliates

Last Buyer's Agent

Jane Ashcraft-West

Huff Realty - Florence

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,758

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 entrance to outdoor space
  • 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

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,758

Year Built

Built in 2005

Lot Details

0

HOA Fees

$30 per month

Parking

3

Listing Details

  • Cooling: Central Air
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 1.11
  • Year Built: 2005
  • Lot Size: 1.11 ac.
  • Directions: Ky 237 to Coachtrail Dr. to L on Rivershore Dr. to L on Irmaleen Lane.
  • Architectural Style: Craftsman
  • 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: North Pointe Elementary
  • Location Tax Legal Info:Middle or Junior School: Conner Middle School
  • Location Tax Legal Info:High School: Conner Senior High
  • Location Tax Legal Info:Subdivision2: Rivershore Farms
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 2
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: 1.11 ac.
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Room Type:Dining Room4: Yes
  • Room Type:Entry: Yes
  • Room Type:Family Room4: Yes
  • Room Type:Laundry Room3: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Utilities:Natural Gas Available: Yes
  • Utilities Electric Company: Owen
  • Utilities Gas Company: Duke Energy
  • Water Company: Boone County
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 1.11
  • General Property Description:Living Area: 7000.0
  • Structure Type:House: Yes
  • Laundry Features:Laundry Room2: Yes
  • Laundry Features:Main Level: Yes
  • Room Type:Breakfast Room2: Yes
  • Room Type:Breakfast Room Level: First
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 034.00-02-110.00
  • Appliances Refrigerators: Yes
  • Roof:Composition: Yes
  • Room Type:Living Room4: Yes
  • General Property Description:Fireplaces Total: 1
  • View:TreesWoods: Yes
  • Room Type:Bonus Room2: Yes
  • Utilities:Sewer Available: Yes
  • Utilities:Water Available: Yes
  • Percent Basement Finished: Yes
  • Room Type:Library: Yes
  • Other Equipment:Home Theater: Yes
  • Library Features:Carpet Flooring11: Yes
  • Laundry Room Features:Tile Flooring15: Yes
  • Bonus Room Features:Carpet Flooring12: Yes
  • Entry Features:Entrance Foyer: Yes
  • Laundry Room Features:Built-in Features6: Yes
  • Room Type:Exercise Room: Yes
  • Room Type:Exercise Room Level: Lower
  • View:Lake2: Yes
  • Architecture:Craftsman: Yes
  • Entry Features:Private Entry: Yes
  • Laundry Features:Laundry Chute: Yes
  • Bonus Room Features:Recessed Lighting5: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Wet Bar, Walk-In Closet(s), Tray Ceiling(s), Storage, Pantry, Open Floorplan, High Speed Internet, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Coffered Ceiling(s), Chandelier, Bookcases, Breakfast Bar, Built-in Features, Butler's Pantry, Cathedral Ceiling(s), Ceiling Fan(s), French Doors, High Ceilings, Multi Panel Doors, Recess Ceiling(s), Recessed Lighting, Vaulted Ceiling(s), Wired for Sound
  • Basement: Full, Finished, Bath/Stubbed, Storage Space, Walk-Out Access
  • Heating: Geothermal
  • Levels: Two
  • Property Type: Residential
  • Appliances: Other, Gas Cooktop, Dishwasher, Double Oven, Microwave, Refrigerator, Wine/Beverage Cooler
  • Other Equipment: Home Theater
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Total Bedrooms: 4
  • Fireplace Features: Stone
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 7000.0
  • Window Features: Insulated Window(s)
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Double Oven: Yes
  • Appliances:Gas Cooktop: 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:Kitchen Island2: 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
  • Interior Features:Wet Bar4: Yes
  • Family Room Features:See Remarks6: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Primary Bedroom Features:Ceiling Fan(s)8: Yes
  • Basement:Walk-Out Access7: Yes
  • Interior Features:French Doors: Yes
  • Kitchen Features Pantry: Yes
  • Kitchen Features:Wood Cabinets: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Carpet Flooring5: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Family Room Features:Carpet Flooring4: Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Living Room Features:Walk-Out Access: Yes
  • Kitchen Features:Walk-Out Access3: Yes
  • Primary Bath Features:Shower: Yes
  • Interior Features:Crown Molding: Yes
  • Dining Room Features:Wood Flooring3: Yes
  • Family Room Features:Walk-Out Access4: Yes
  • Basement:Full Finished Bath: Yes
  • Basement:Storage Space: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Interior Features:High Speed Internet: Yes
  • Living Room Features:Carpet Flooring2: Yes
  • Living Room Features:Fireplace(s): Yes
  • Kitchen Features:Ceramic Tile Flooring2: Yes
  • Interior Features:Breakfast Bar2: Yes
  • Interior Features:Cathedral Ceiling(s): Yes
  • Interior Features:Chandelier2: Yes
  • Interior Features:Vaulted Ceiling(s): Yes
  • Dining Room Features:Chandelier: Yes
  • Kitchen Features:Breakfast Bar: Yes
  • Primary Bedroom Features:Window Treatments6: Yes
  • Primary Bath Features:Soaking Tub2: Yes
  • Primary Bedroom Features:High Ceiling(s)6: Yes
  • Interior Features:Recessed Lighting: Yes
  • Primary Bath Features:Jetted Tub: Yes
  • Basement:Wet Bar5: Yes
  • Interior Features:Bookcases4: Yes
  • Interior Features:Wired for Sound: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Kitchen Features:Recessed Lighting3: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Fireplace Features:Stone4: Yes
  • Interior Features:Butler_squote_s Pantry: Yes
  • Interior Features:Coffered Ceiling(s): Yes
  • Interior Features:Recess Ceiling(s): Yes
  • Family Room Features:Recessed Lighting6: Yes
  • Family Room Features:Wet Bar2: Yes
  • Kitchen Features:Butler_squote_s Pantry2: Yes
  • Kitchen Features:Tile Flooring2: Yes
  • Appliances:Other5: 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
  • Living Room Features:Built-in Features7: Yes
  • Living Room Features:Recessed Lighting4: Yes
  • Interior Features:Tray Ceiling(s): Yes
  • Kitchen Features:Crown Molding2: Yes
  • Appliances:WineBeverage Cooler: Yes
  • Family Room Features:Storage3: Yes
  • Family Room Features:French Doors3: Yes
  • Dining Room Features:Recessed Lighting8: Yes
  • Dining Room Features:See Remarks22: Yes
  • Kitchen Features:See Remarks8: Yes
  • Primary Bedroom Features:See Remarks16: Yes
  • Living Room Features:See Remarks11: Yes
  • Primary Bath Features:See Remarks15: Yes

Exterior Features

  • View: Lake, Trees/Woods
  • Roof: Composition, Shingle
  • Lot Features: Cleared, Cul-De-Sac, Lake, Level, Pond, Waterfront, Wooded
  • View: Yes
  • Construction Type: HardiPlank Type, Stone
  • Exterior Features: Private Yard
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Patio, Porch
  • Construction Materials:HardiPlank Type: 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
  • Construction Materials:Stone2: Yes
  • Lot Features:Wooded: Yes
  • Lot Features:Cul-De-Sac: Yes
  • Lot Features:Level: Yes
  • Exterior Features:Private Yard: Yes
  • Lot Features:Cleared: Yes
  • Lot Features:Lake: Yes
  • Lot Features:Pond: Yes
  • Lot Features:Waterfront: Yes

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Driveway, Garage, Garage Faces Side, Off Street, Oversized
  • General Property Description:Garage Spaces: 3.0
  • Parking Features:Attached: Yes
  • Parking Features:Driveway: Yes
  • Parking Features:Garage5: Yes
  • Parking Features:Off Street2: Yes
  • Parking Features:Oversized: Yes
  • Parking Features:Garage Faces Side: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Utility Sink, Laundry Chute, Laundry Room, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available, Sewer Available, Water Available
  • Heating:Geothermal: Yes

Condo/Co-op/Association

  • Amenities: Lake Year Round
  • Association Fee: 360.0
  • Association Fee Frequency: Annually
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: Stonegate Management - Jessica
  • Association Information:Association Management Phone 1: 859-534-0900
  • Association Information:Total Yearly Fees: 360.0
  • Association Fee Includes:Association Fees: Yes
  • Association Information:Association Fee: 360.0
  • Association Information:Association Fee Frequency: Annually
  • Association Amenities:Lake Year Round: Yes

Fee Information

  • Association Fee Includes: Association Fees

Schools

  • Elementary School: North Pointe Elementary
  • Junior High Dist: Boone Co Public
  • High School: Conner Senior High
  • Middle Or Junior School: Conner Middle School

Lot Info

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 3, 2024
Sold by
Warden Phillip Matthew and Warden Phil M
Bought by
Philip Matthew Warden And Abigale Tyree Warde and Warden
Current Estimated Value
$1,326,003

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
171

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.74%
Original Mortgage
$300,000
Interest Rate
6.75%
Mortgage Type
New Conventional
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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
Philip Matthew Warden And Abigale Tyree Warde -- None Listed On Document
Warden Phil M $1,125,000 Kentucky Land Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
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 $417,000
Previous Owner Neltner Paul M $183,000
Previous Owner Neltner Paul M $400,000
Previous Owner Neltner Paul M $250,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
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 Compared to Growth

Source: Public Records

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

    20 in this area

    369 Total Sales

    Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 608229

Northern Kentucky Multiple Listing Service

APN: 034.00-02-110.00

Kentucky Boone County Hebron 41048 Hebron

2004 Irmaleen Ln, Hebron, KY

This home is located at 2004 Irmaleen Ln, Hebron, KY 41048 since 26 September 2022 and is currently estimated at $1,326,003, approximately $189 per square foot. This property was built in 2005. 2004 Irmaleen Ln is a home located in Boone County with nearby schools including North Pointe Elementary School, Conner Middle School, and Conner High School.

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.

Northern Kentucky Multiple Listing Service 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 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.

Nearby Homes