NOT LISTED FOR SALE

Estimated Value: $552,487 - $647,000

5 Beds
4 Baths
2,944 Sq Ft
$208/Sq Ft Est. Value

Last Sold May 24, 2024

Current estimated payment $3,706/month

4 Days on Market

Highlights

  • Gourmet Kitchen
  • Deck
  • Transitional Architecture
  • Sitting Area In Primary Bedroom
  • Vaulted Ceiling
  • Outdoor Fireplace

About This Home

As of May 2024

Welcome to your lakeside paradise! This exceptional property offers stunning lake views from every balcony. Enjoy the convenience of a 4-floor elevator & custom kitchen w/quartz countertops & maple cabinets. The whole floor master suite includes an office & laundry. Remodeled bathrooms, bamboo floors & updated lighting add elegance. 5 bed, 4 full bath, an office, 2 laundry sites and entertaining space. Security features include an alarm system & underground pet fence. Step onto trex decking for minimal upkeep & take in tranquil ambiance. Car enthusiasts will delight in the 3-car garage, complete w/an oil bay. Partially finished basement w/full bath. Schedule a viewing today and make this your dream home!

Last Agent to Sell the Property

Zachary Marshall

Coldwell Banker Realty License #2017006327 Listed on: 04/04/2024

Coldwell Banker Realty

Last Buyer's Agent

Non Member

NonMember Firm

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,020

Year Built

  • Built in 2003

Lot Details

  • 0.26 Acre Lot
  • Lot Dimensions are 75x150

HOA Fees

  • $94 Monthly HOA Fees

Parking

  • 3 Car Garage
  • Driveway
  • On-Street Parking

Home Design

  • Transitional Architecture
  • Metal Roof
  • Vinyl Siding

Interior Spaces

  • 2,944 Sq Ft Home
  • 3-Story Property
  • Elevator
  • Woodwork
  • Crown Molding
  • Vaulted Ceiling
  • 2 Fireplaces
  • Gas Fireplace
  • Vinyl Clad Windows
  • French Doors
  • Family Room
  • Formal Dining Room

Kitchen

  • Gourmet Kitchen
  • Double Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops

Flooring

  • Cork
  • Concrete
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Sitting Area In Primary Bedroom
  • Main Floor Bedroom
  • Walk-In Closet
  • 4 Full Bathrooms

Basement

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

Outdoor Features

  • Balcony
  • Deck
  • Patio
  • Outdoor Fireplace
  • Fire Pit
  • Exterior Lighting
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Gas Water Heater

Community Details

  • Association fees include security, snowremoval, trash, association dues, clubhouse, golf, landscapingcommunity, playarea, pool, tennis, walkingtrails
  • Hvl Poa
  • Hidden Valley Lake Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,020

Year Built

Built in 2003

Lot Details

0

HOA Fees

$94 per month

Parking

3

Listing Details

  • Suburb: Hidden Valley
  • Cross Street: Ryan Ct.
  • Land Description: Less than .5 Acre
  • Access: City Street
  • Broker Approved: Yes
  • Basement Sq Ft: 3688
  • Census Tract Realist: 804.00
  • Cooling: Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 11250.00
  • Sub Lease Expiration Date: 1800-01-01T00:00:00-05:00
  • Suburb S I C: Hidden Valley
  • Price Per Acre: 2477351.92
  • Basement Features: Concrete Floor,Fireplace,Part Finished,Walkout
  • Bathroom 4: Full
  • Bathroom 4 Level: Basement
  • Level 1 Bathroom Type: Full
  • Level 1 Bathroom: Yes
  • Bedroom 5 Area: 192
  • Level 1 Bedroom: Yes
  • Dining Room Feat: Built-ins,French Doors,Walkout
  • Entry Dim: 0 x 0
  • Entry Foyer: Tile Floor
  • Family Room Feat: Bookcases,Cork/Bamboo Floor,French Doors,Skylight
  • Lifestyle Community: Boating,Fishing,Golf Cart,Golf Course,Sports-Organized,Tennis,Walk/Run Paths,Water Features
  • Living Great Rm Area: 216
  • Living Great Rm Dim: 12 x 18
  • Living Great Rm Len: 12
  • Living Great Rm Wid: 18
  • Living Room Feat: Bookcases,Cork/Bamboo Floor
  • Mechanical Systems: Garage Door Opener,Security System,Water Softener
  • Single Family Desc: Single Family
  • Study Lib Den Dim: 0 x 0
  • Water Heating: Gas
  • Year Built: 2003
  • Architecture: Transitional
  • Full Bathrooms: 4
  • Bedrooms: 5
  • Directions: HVL Main Gate, L on Alpine, R on Longview, L on Lakeview, property on Left just before the Marina!
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2024-04-04
  • Property Subtype 1: Single Family Residence
  • Suburb (SIC): Hidden Valley Lake
  • Occupancy: At Closing
  • ResoPropertyType: Residential
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Crown Molding, Elevator, French Doors, Natural Woodwork, Vaulted Ceiling
  • Bedroom 2: 16x16 Level: 2
  • Bedroom 3: 10x16 Level: 2
  • Bedroom 4: 12x13 Level: 1
  • Bedroom 5: 12x16 Level: 3
  • Dining Room: 12x14 Level: 1
  • Living Room: 12x18 Level: 1
  • Formal Dining Room: Yes
  • Flex Rooms: Bedroom,Bonus Room,Game Room
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: 2010
  • Kitchen: 12x18 Level: 1
  • Appliances: Dishwasher, Double Oven, Gas Cooktop, Microwave, Refrigerator
  • Kitchen Features: Gourmet,Island,Pantry,Quartz Counters,Tile Floor
  • Bedroom 2 Area: 256
  • Basement: Full
  • Bedroom 3 Area: 160
  • Study Features: Cork/Bamboo Floor
  • Bedroom 4 Area: 156
  • Bathrooms: 4.00
  • Kitchen Area: 216
  • Kitchen Dim: 12 x 18
  • Levels: Three
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 3
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: 1
  • Diningroom Area: 168
  • Laundryroom Dim: 0 x 0
  • Other: Elevator Access
  • Recreation Room Dim: 0 x 0
  • Fireplace: Gas
  • Fireplaces: 2
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 2944.00
  • Total Rooms: 12
  • Windows: Vinyl
  • First Floor Family Room: Yes
  • PrimaryBedroomArea: 285
  • PrimaryBedroomDim: 15 x 19
  • PrimaryBedroomLen: 15
  • Primary Bathrooms: Built-In Shower Seat,Double Vanity,Shower,Tile Floor,Tub
  • PrimaryBedFeat: Bath Adjoins,Cork/Bamboo Floor,Fireplace,Sitting Room,Vaulted Ceiling,Walk-in Closet
  • P R I M A R Y B E D R O O M: 15x19 Level: 3

Exterior Features

  • View: Lake/Pond
  • Roof: Metal
  • Construction: Stone, Vinyl Siding
  • Outside Features: Balcony, Deck, Entertain Ctr, Fire Pit, Fireplace, Patio, Porch, Tiered Deck, Yard Lights
  • Foundation: Poured
  • Listing Price: 639900.00
  • Acres: 0.2583
  • New Construction: No
  • TopographyDetails: Cleared,Level

Garage/Parking

  • Garage Spaces: 3.00
  • Garage Carport: Front,Garage Attached,Oversized
  • Parking: Driveway, On Street

Utilities

  • Gas: Natural
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 94.00
  • Fee Frequency: Monthly
  • HOA Management Co: HVL POA
  • HOA Yes/No: Yes
  • Association: Cincinnati Area Multiple Listing Service
  • ResoAssociationFeeFrequency: Monthly

Fee Information

  • Inc.In HOA/Condo Fee: Security, SnowRemoval, Trash, AssociationDues, Clubhouse, Golf, LandscapingCommunity, PlayArea, Pool, Tennis, WalkingTrails

Schools

  • District: Lawrenceburg Com Sch

Lot Info

  • Lot Dimensions: 75x150
  • Lot Size Sq Ft: 11252.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
Apr 4, 2024
Closed on
May 24, 2024
Sold by
Lambrinides Michael Thomas and Lambrinides Jamie Marie
Bought by
Elsen Family Trust and Elsen
Seller's Agent
Zachary Marshall
Coldwell Banker Realty
Buyer's Agent
Non Member
NonMember Firm
List Price
$636,900
Sold Price
$639,900
Premium/Discount to List
$3,000
0.47%
Views
17
Current Estimated Value
$612,872

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$27,028
Avg. Annual Appreciation
-3.29%
Original Mortgage
$326,900
Outstanding Balance
$322,615
Interest Rate
6.88%
Mortgage Type
New Conventional
Estimated Equity
$290,257

Purchase Details

Listed on
Jul 24, 2018
Closed on
Apr 12, 2021
Sold by
Rummel Brian and Rummel Diane
Bought by
Lambrinides Michael T and Lambrinides Jamie M
Seller's Agent
Kathy Patterson
Premier Properties
Buyer's Agent
Paige Wurtz
Premier Properties
List Price
$469,900
Sold Price
$430,000
Premium/Discount to List
-$39,900
-8.49%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
13.59%
Original Mortgage
$408,500
Interest Rate
3%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Oct 9, 2014
Sold by
Murphy Insurance Agency Inc
Bought by
Rummel Brian and Rummel Diane

Purchase Details

Closed on
Sep 26, 2013
Bought by
Rummel Brian and Rummel Diane

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$232,000
Interest Rate
4.5%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 27, 2013
Sold by
Sheriff Of Dearborn County State Of Ind
Bought by
Us Bank Na Successor Tte To Bank Of Am
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
Elsen Family Trust -- None Listed On Document
Lambrinides Michael T $430,000 None Available
Rummel Brian -- Attorney
Rummel Brian -- --
Us Bank Na Successor Tte To Bank Of Am $359,100 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Elsen Family Trust $326,900
Previous Owner Lambrinides Michael Thomas $35,000
Previous Owner Lambrinides Michael T $408,500
Previous Owner Rummel Diane $217,000
Previous Owner Rummel Brian $232,000
Previous Owner Walor Jan $75,000
Previous Owner Walor Jan $444,000
Previous Owner Walor Jan $25,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/24/2024 05/24/24 Sold $639,900 0.0% $217 / Sq Ft
05/24/2024 05/24/24 Sold -- -- --
04/10/2024 04/10/24 For Sale $639,900 0.0% $174 / Sq Ft
04/10/2024 04/10/24 Pending -- -- --
04/09/2024 04/09/24 Pending -- -- --
04/04/2024 04/04/24 Price Changed $639,900 +0.5% $217 / Sq Ft
04/04/2024 04/04/24 For Sale $636,900 -0.5% $216 / Sq Ft
04/04/2024 04/04/24 For Sale $639,900 +48.8% $174 / Sq Ft
04/12/2021 04/12/21 Sold $430,000 -4.4% $146 / Sq Ft
03/01/2021 03/01/21 Pending -- -- --
07/22/2020 07/22/20 Price Changed $449,950 -4.2% $153 / Sq Ft
06/25/2020 06/25/20 For Sale $469,900 0.0% $160 / Sq Ft
06/19/2020 06/19/20 Pending -- -- --
07/26/2019 07/26/19 Price Changed $469,900 0.0% $160 / Sq Ft
07/26/2019 07/26/19 For Sale $469,900 +9.3% $160 / Sq Ft
07/22/2019 07/22/19 Off Market $430,000 -- --
03/27/2019 03/27/19 Sold -- -- --
02/25/2019 02/25/19 Pending -- -- --
07/22/2018 07/22/18 For Sale $479,900 -- $163 / Sq Ft
07/16/2013 07/16/13 For Sale -- -- --
Source: MLS of Greater Cincinnati (CincyMLS)

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 $4,148 $469,900 $24,800 $445,100
2023 $4,021 $469,900 $24,800 $445,100
2022 $4,097 $469,900 $24,800 $445,100
2021 $4,256 $469,900 $24,800 $445,100
2020 $3,763 $469,900 $24,800 $445,100
2019 $3,522 $419,300 $24,800 $394,500
2018 $3,493 $409,700 $24,800 $384,900
2017 $2,867 $349,800 $24,800 $325,000
2016 $2,899 $353,800 $24,800 $329,000
2014 $2,533 $353,900 $24,800 $329,100
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1800977

MLS of Greater Cincinnati (CincyMLS)

APN: 15-06-25-202-072.000-012