NOT LISTED FOR SALE

559 Locust Run Rd Cincinnati, OH 45245

Estimated Value: $956,000 - $1,320,000

4 Beds
3.5 Baths
3,724 Sq Ft
$304/Sq Ft Est. Value

Last Sold February 16, 2021

Last sale price $830,000 $223 Per Sq Ft

Est. 36% increase in value since last sale

Current estimated payment $7,060/month

100 Days on Market

Highlights

  • Eat-In Gourmet Kitchen
  • Lake View
  • Partially Wooded Lot
  • Sitting Area In Primary Bedroom
  • Family Room with Fireplace
  • Traditional Architecture

About This Home

As of February 2021

Click 3D Tour to Walk Through Home! Featured in Better Homes & Gardens, this custom-built home offers over 5000 square feet on 5.5 acres! Enjoy nature in every season surrounded by lush gardens and mature trees, relax in your private pool in the warmer months, stroll through the woods savoring the crisp autumn air, enjoy the beauty of a fresh snowfall, and the gorgeous spring perennials! A respite from the hustle & bustle of the city, close enough to commute downtown or easily catch a flight!

Last Agent to Sell the Property

Sandra Lettie

RE/MAX Preferred Group License #0000427144 Listed on: 10/09/2020

RE/MAX Preferred Group

Co-Listed By

Deb LaFrance

RE/MAX Preferred Group License #0000427341

Last Buyer's Agent

Sandra Burkhart-Williams

Huff Realty License #2004005404

Huff Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,508

Year Built

  • Built in 1995

Lot Details

  • 5.5 Acre Lot
  • Cul-De-Sac
  • Property has an invisible fence for dogs
  • Sprinkler System
  • Partially Wooded Lot

HOA Fees

  • $167 Monthly HOA Fees

Parking

  • 3 Car Garage
  • Driveway

Property Views

  • Lake
  • Woods
  • Valley

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof

Interior Spaces

  • 3,724 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Bookcases
  • Crown Molding
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Chandelier
  • Wood Burning Fireplace
  • Stone Fireplace
  • Brick Fireplace
  • Double Pane Windows
  • Double Hung Windows
  • Bay Window
  • Wood Frame Window
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Family Room with Fireplace
  • 3 Fireplaces
  • Great Room with Fireplace
  • Living Room with Fireplace
  • Formal Dining Room
  • Wood Flooring

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Bar
  • Double Convection Oven
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Kitchen Island
  • Solid Surface Countertops
  • Solid Wood Cabinet
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Sitting Area In Primary Bedroom
  • Walk-In Closet
  • Dressing Area

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Fireplace in Basement

Outdoor Features

  • Covered Deck
  • Enclosed Patio or Porch

Utilities

  • Forced Air Heating and Cooling System
  • Geothermal Heating and Cooling
  • Propane
  • Septic Tank

Community Details

  • Association fees include snow removal, association dues, landscapingcommunity, professionalmgt
  • Locust Run Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,508

Year Built

Built in 1995

Lot Details

0

HOA Fees

$167 per month

Parking

3

Listing Details

  • Suburb: Pierce Twp.
  • Cross Street: Locust
  • Trees: Wooded-Partial
  • Buildings: Gazebo,Other
  • Land Description: 5 to 9.9 Acres,Other
  • Access: Private Drive,Other
  • Broker Approved: Yes
  • Miscellaneous: 220 Volt,Attic Storage,Cable,Ceiling Fan,Fountain,Home Warranty,Recessed Lights,Smoke Alarm,Other
  • Census Tract Realist: 415.01
  • Cooling: Ceiling Fans, Central Air, Geothermal
  • Heating: Forced Air, Geothermal, Other
  • Lot Area Realist: 239580.00
  • Property Ownership: Consumer
  • Suburb S I C: Pierce Twp.
  • Price Per Acre: 150909.09
  • Basement Features: Finished,Fireplace,Walkout,WW Carpet,Other
  • Bathroom 4: Partial
  • Bathroom 4 Level: 1
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: No
  • Dining Room Feat: Built-ins,Chandelier,French Doors,Window Treatment,Wood Floor,Other
  • Entry Dim: 23 x 9
  • Entry Foyer: Closet,Open Foyer,Transom/Sidelit,Wood Floor,Other
  • Family Room Feat: Bookcases,Fireplace,French Doors,Walkout,Wet Bar,Window Treatment,WW Carpet,Other
  • Great Room Feat: Fireplace,Walkout,Window Treatment,Wood Floor,Other
  • Living Great Rm Dim: 24 x 20
  • Living Room Feat: Fireplace,Walkout,Window Treatment,Wood Floor,Other
  • Mechanical Systems: Air Cleaner,Garage Door Opener,Humidifier,Security System,Other
  • Single Family Desc: Single Family
  • Smart Technology: HVAC,Irrigation System,Safety,Security
  • Study Lib Den: 13x13 Level: 1
  • Study Lib Den Dim: 13 x 13
  • Water Heating: Electric,Other
  • Year Built: 1995
  • Architecture: Traditional
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Bedrooms: 4
  • Directions: US 52 to Left on 9 Mile, Right on Locust Corner, Left on Locust Run
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2020-10-09
  • Property Subtype 1: Single Family Residence
  • Suburb (SIC): Locust Run
  • Occupancy: At Closing
  • On Market: No
  • Third Party Approval Required: No
  • ResoPropertyType: Residential
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Crown Molding, French Doors, Multi Panel Doors, Other
  • Bedroom 2: 15x12 Level: 2
  • Bedroom 3: 12x12 Level: 2
  • Bedroom 4: 12x11 Level: Lower
  • Breakfast Room: 21x13 Level: 1
  • Dining Room: 20x15 Level: 1
  • Family Room: 24x20 Level: Lower
  • Living Room: 24x20 Level: 1
  • Recreation Room: 22x15 Level: Lower
  • Formal Dining Room: Yes
  • Property Type: Residential
  • Bathrooms Display: 4 (3 1)
  • Reciprocal Listing: No
  • School Name1: Call SD 513-553-2616
  • Semi Annual Taxes: 5254
  • Kitchen: 17x11 Level: 1
  • Appliances: Convection Oven, Dishwasher, Double Oven, Garbage Disposal, Microwave, Oven/Range, Refrigerator, Wine Cooler, Other
  • Kitchen Features: Counter Bar,Eat-In,Gourmet,Island,Marble/Granite/Slate,Pantry,Planning Desk,Solid Surface Ctr,Walkout,Window Treatment,Wood Cabinets,Wood Floor,Other
  • Basement: Full
  • Study Features: French Doors,Walkout,Window Treatment,Wood Floor,Other
  • Entry: 23x9 Level: 1
  • Bathrooms: 4.00
  • Great Room: 24x20 Level: 1
  • Kitchen Dim: 17 x 11
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: Lower
  • Laundry Room: 12x8 Level: 2
  • Laundryroom Dim: 12 x 8
  • Recreation Room Dim: 22 x 15
  • Fireplace: Brick, Stone, Wood
  • Fireplaces: 3
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 3724.00
  • Windows: Bay/Bow, Double Hung, Double Pane, Wood, Other
  • First Floor Family Room: Yes
  • PrimaryBedroomDim: 23 x 14
  • Primary Bathrooms: Double Vanity,Marb/Gran/Slate,Shower,Tile Floor,Tub,Jetted Tub,Window Treatment
  • PrimaryBedFeat: Bath Adjoins,Dressing Area,Sitting Room,Walk-in Closet,Window Treatment,WW Carpet,Other
  • P R I M A R Y B E D R O O M: 23x14 Level: 2

Exterior Features

  • View: Lake/Pond, Valley, Woods, Other
  • Fencing: Invisible, Other
  • Roof: Shingle
  • Pool: Automated Cover,Cleaner,Gunite,Heated,In-Ground
  • Construction: Brick
  • Outside Features: Covered Deck/Patio, Cul de sac, Enclosed Porch, Entertain Ctr, Patio, Porch, Sprinklers, Wooded Lot, Other
  • Foundation: Poured
  • Listing Price: 899999.00
  • Acres: 5.5000
  • New Construction: No
  • TopographyDetails: Cleared,Level,Sloped,Other

Garage/Parking

  • Garage Spaces: 3.00
  • Garage Carport: Front,Garage Detached,Oversized
  • Parking: Driveway

Utilities

  • Gas: Propane
  • Sewer: Septic Tank
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 2000.00
  • Fee Frequency: Annually
  • HOA Yes/No: Yes
  • Association: Cincinnati Area Multiple Listing Service
  • ResoAssociationFeeFrequency: Annually

Fee Information

  • Inc.In HOA/Condo Fee: SnowRemoval, AssociationDues, LandscapingCommunity, Other, ProfessionalMgt

Schools

  • District: New Richmond Ex Vill

Lot Info

  • Lot Dimensions: Irregular
  • Lot Size Sq Ft: 239580.00
  • Total Assessed Value: Of Record
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Abatement: No

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 9, 2020
Closed on
Feb 12, 2021
Sold by
Moeggenberg Joseph J and Moeggenberg Patricia A
Bought by
Stutler Mark and Stutler Gabriella
Seller's Agent
Sandra Lettie
RE/MAX Preferred Group
Buyer's Agent
Sandra Burkhart-Williams
Huff Realty
List Price
$949,000
Sold Price
$830,000
Premium/Discount to List
-$119,000
-12.54%
Current Estimated Value
$1,132,131

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$302,131
Avg. Annual Appreciation
6.43%

Purchase Details

Closed on
Mar 10, 1994
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

Purchase History

Date Buyer Sale Price Title Company
Stutler Mark $830,000 Lawyers Title
-- $170,000 --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
02/16/2021 02/16/21 Sold $830,000 -7.8% $223 / Sq Ft
01/17/2021 01/17/21 Pending -- -- --
12/12/2020 12/12/20 Price Changed $899,999 -5.2% $242 / Sq Ft
10/09/2020 10/09/20 For Sale $949,000 -- $255 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

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 $12,032 $290,500 $90,720 $199,780
2023 $12,030 $290,500 $90,720 $199,780
2022 $10,942 $211,440 $56,250 $155,190
2021 $10,765 $211,440 $56,250 $155,190
2020 $10,735 $211,440 $56,250 $155,190
2019 $10,508 $231,670 $56,110 $175,560
2018 $10,511 $231,670 $56,110 $175,560
2017 $10,522 $231,670 $56,110 $175,560
2016 $11,008 $222,750 $53,940 $168,810
2015 $10,145 $222,750 $53,940 $168,810
2014 $10,145 $222,750 $53,940 $168,810
2013 $10,739 $234,120 $61,250 $172,870
Source: Public Records

Agents Affiliated with this Home

  • Sandra Lettie

    Seller's Agent in 2021

    Sandra Lettie

    RE/MAX

    (513) 652-9256

    127 Total Sales

    Sandra Lettie
    Section Image
  • Deb LaFrance

    Seller Co-Listing Agent in 2021

    Deb LaFrance

    RE/MAX

    (513) 652-9256

    140 Total Sales

    Deb LaFrance
    Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1679127

MLS of Greater Cincinnati (CincyMLS)

APN: 27-28-14H-103

Ohio Clermont County Cincinnati 45245

559 Locust Run Rd, Cincinnati, OH

Not Listed for Sale

Detached

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.

MLS of Greater Cincinnati (CincyMLS) The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved

Nearby Homes