NOT LISTED FOR SALE

Estimated Value: $978,000 - $1,034,000

4 Beds
4 Baths
4,416 Sq Ft
$229/Sq Ft Est. Value

Last Sold April 23, 2021

Last sale price $745,000 $169 Per Sq Ft

Est. 36% increase in value since last sale

Current estimated payment $7,057/month

32 Days on Market

Highlights

  • Updated Kitchen
  • Landscaped Professionally
  • Double Shower
  • Welch Elementary School Rated A+
  • Deck
  • Vaulted Ceiling

About This Home

As of April 2021

Nestled among trees and ivy in Stillwater Club, This Executive home brilliantly combines rustic & refined traditional luxury which never forgets its past but forges into the future. 4 CAR GARAGE- TWO ZOOM OFFICE ROOMS- E-LEARNING SPACE- EXERCISE ROOM , FABULOUS OUTDOOR SPACE. And,So many BRAND NEW updates! Just move right in and ENJOY LIVING. Such a DEAL @$174.34/ square feet! The updates include: NEWLY finished Staircase painted & stained Dec 2020**NEWLY refinished FLOORING-entire house- even in the upstairs hallway**NEW H2O 2018**NEW AC 2010**NEW Roof & Gutters 2015**NEW outdoor gas fire pit 2015**NEWER LG HG 4K 65" TV ( included)**NEW 2019-2020 Dishwasher/ Microwave**NEW Nov/Dec 2020- Master Suite-Installed 2 Barn Doors,Painted Vanities,New Mirrors,NEW sinks,Retiled Fireplace,NEW paint,New Fixtures**NEW Nov/Dec 2020- all Bathroom Painted Cabinets, New lighting fixtures, New Paint.**NEW Dec 2020 Family Room- TV included, Painted Ceiling White, NEW Paint on walls**Dining Room NEW Dec/2020- NEW Painted Trey ceiling, New Chandelier and Scones. The GOURMET Kitchen has 2 Pantries, Restaurant Quality Stainless Steel appliances, Stone countertops. Bake with your favorite Food Network star ( TV in Kitchen is included). This space will act like a magnet for family & friends. Spacious. Luxe. HEATED SUN ROOM is a perfect E-LEARNING SPACE. Enjoy the wall of windows as it overlooks a large backyard complete with Deck, Patio and Fire pit. Formal Dining room & Living rooms with 10 foot ceilings, Plantation shutters and New fixtures. First floor office can convert to the 5th Bedroom with features of Hardwood flooring, plantation shutters and a TV hidden in the closet ( included). The 2-story foyer is large and inviting which showcases the stunning newly painted Staircase. Upstairs- hardwood flooring ( refinished) in the hallway is 4 Large Bedrooms. The Master Retreat features Bedroom with spa-like master bathroom an exercise room and 2 large walk-in closets w/organizers. A Private bath and Jack-n-jill allows access to baths with every bedroom. Enjoy the Stillwater Clubhouse, pool, tennis courts as well as activities for this vibrant community. Walk to award winning elementary schools and Neuqua Valley high school. Welcome Home!

Last Agent to Sell the Property

Jill Clark

Compass License #471001480 Listed on: 12/17/2020

Compass

Last Buyer's Agent

Paul Ragi

@properties Christie's International Real Estate License #475126859

@properties Christie's International Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $18,959

Year Built

  • 2000

Lot Details

  • East or West Exposure
  • Landscaped Professionally

HOA Fees

  • $83 per month

Parking

  • Attached Garage
  • Garage ceiling height seven feet or more
  • Heated Garage
  • Garage Door Opener
  • Circular Driveway
  • Parking Included in Price
  • Garage Is Owned

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Asphalt Shingled Roof
  • Cedar

Interior Spaces

  • Wet Bar
  • Built-In Features
  • Historic or Period Millwork
  • Vaulted Ceiling
  • Skylights
  • Gas Log Fireplace
  • Electric Fireplace
  • Entrance Foyer
  • Breakfast Room
  • Home Office
  • Heated Sun or Florida Room
  • Home Gym
  • Wood Flooring

Kitchen

  • Updated Kitchen
  • Breakfast Bar
  • Walk-In Pantry
  • Double Oven
  • Cooktop with Range Hood
  • Microwave
  • High End Refrigerator
  • Dishwasher
  • Wine Cooler
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops
  • Built-In or Custom Kitchen Cabinets
  • Disposal

Bedrooms and Bathrooms

  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Dual Sinks
  • Whirlpool Bathtub
  • Double Shower
  • Separate Shower

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Rough-In Basement Bathroom

Outdoor Features

  • Deck
  • Fire Pit
  • Brick Porch or Patio

Utilities

  • Forced Air Heating and Cooling System
  • Two Heating Systems
  • Heating System Uses Gas
  • Lake Michigan Water

Home Details

Home Type

Single Family

Est. Annual Taxes

$18,959

Year Built

2000

Lot Details

0

HOA Fees

$83 per month

Parking

4

Listing Details

  • Property Type: Detached Single
  • General Information: School Bus Service
  • Age: 21-25 Years
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Number Interior Fireplaces: 2
  • Ownership: Fee Simple
  • Total Full or Half Bathrooms: 3.1
  • Total Sq Ft: 4416
  • Unfinished Basement Sq Ft: 2285
  • Style Of House: Traditional
  • Type Detached: 2 Stories
  • Estimated Year Built: 2000
  • Total Sq Ft: 6701
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 2000

Interior Features

  • Interior Property Features: Vaulted/Cathedral Ceilings, Skylight(s), Bar-Wet, Hardwood Floors, 1st Floor Laundry, Built-in Features, Walk-In Closet(s), Special Millwork, Granite Counters
  • Number Of Rooms: 11
  • Living Room: Dimensions: 15X13, On Level: Main Level, Windows: Plantation Shutters
  • Appliances: Oven-Double, Oven/Range, Microwave, Dishwasher, Refrigerator, High End Refrigerator, Washer, Dryer, Disposal, All Stainless Steel Kitchen Appliances, Wine Cooler/Refrigerator, Cooktop, Range Hood
  • Equipment: Humidifier, TV-Cable, Security System, CO Detectors, Ceiling Fan, Fan-Attic Exhaust, Sump Pump, Sprinkler-Lawn, Backup Sump Pump;, Multiple Water Heaters
  • Fireplace Details: Electric, Gas Logs, Gas Starter
  • Fireplace Location: Family Room, Master Bedroom
  • Basement: Full
  • Basement: Unfinished, Bathroom Rough-In
  • Bedrooms All Levels: 4
  • Primary Bedroom Bath: Full
  • Bathroom Amenities: Whirlpool, Separate Shower, Double Sink, Double Shower
  • Above Grade Bedrooms: 4
  • Laundry: Dimensions: 8X7, On Level: Main Level
  • Dining Room: Dimensions: 15X13, On Level: Main Level, Windows: Plantation Shutters
  • Kitchen Type: Dimensions: 27X14, On Level: Main Level, Flooring: Hardwood
  • Kitchen Type: Eating Area-Breakfast Bar, Eating Area-Table Space, Island, Pantry-Closet, Pantry-Walk-in, Breakfast Room, Custom Cabinetry, Granite Counters, Updated Kitchen
  • Additional Rooms: Sun/Florida Room Heated, Office, Exercise Room, Foyer
  • Master Bedroom: Dimensions: 19X17, On Level: 2nd Level, Flooring: Carpet, Windows: Plantation Shutters
  • Additional Room 1 Name: Sun/Florida Room Heated, Dimensions: 27X11, On Level: Main Level, Flooring: Hardwood, Windows: Shades
  • Additional Room 2 Name: Office, Dimensions: 14X11, On Level: Main Level, Flooring: Hardwood, Windows: Plantation Shutters
  • Bedroom 2: Dimensions: 14X12, On Level: 2nd Level, Flooring: Carpet
  • Additional Room 3 Name: Exercise Rm, Dimensions: 13X11, On Level: 2nd Level, Flooring: Carpet, Windows: Plantation Shutters
  • Bedroom 3: Dimensions: 17X15, On Level: 2nd Level, Flooring: Carpet
  • Additional Room 4 Name: Foyer, Dimensions: 12X14, On Level: Main Level, Flooring: Hardwood
  • Bedroom 4: Dimensions: 16X15, On Level: 2nd Level, Flooring: Carpet
  • Estimated Sq Ft: 4416
  • Estimated Total Finished Sq Ft: 4416
  • Basement Sq Ft: 2285
  • Upper Level Sq Ft: 4416
  • Dining Room Type: Separate
  • Family Room: Dimensions: 24X21, On Level: Main Level, Flooring: Carpet, Windows: Plantation Shutters

Exterior Features

  • Lot Size: .25-.49 Acre
  • Exterior Building Type: Brick, Cedar
  • Roof Type: Asphalt/Glass (Shingles)
  • Exterior Property Features: Deck, Porch, Brick Paver Patio, Fire Pit
  • Exposure: W (West)
  • Acreage: 0.32

Garage/Parking

  • Number of Cars: 4
  • Parking: Garage
  • Garage Type: Attached
  • Garage Details: Garage Door Opener(s), Heated, 7 Foot or more high garage door
  • Garage On Site: Yes
  • Number Garage Spaces: 4
  • Driveway: Concrete, Circular
  • Parking Included In Price: Yes
  • Garage Ownership: Owned

Utilities

  • Air Conditioner: Central Air
  • Water: Lake Michigan
  • Sewer: Sewer-Public
  • Heating Fuel: Gas, Forced Air, 2+ Sep Heating Systems

Condo/Co-op/Association

  • Fee Frequency: Quarterly
  • Assessment Includes: Clubhouse, Pool
  • Assessed Sq Ft: 6704
  • Assessment Association Fees: 250

Schools

  • School District: 204
  • Elementary School: Welch Elementary School
  • Middle School: Scullen Middle School
  • High School: Neuqua Valley High School
  • Junior High Dist: 204

Lot Info

  • Lot Dimensions: 130X134X56X158
  • Lot Description: Landscaped Professionally
  • Parcel Identification Number: 0701031110010000

Tax Info

  • Taxes: 16214.02

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Dec 17, 2020
Closed on
Apr 20, 2021
Sold by
Lentz Julienne M and Julienne M Lentz Trust
Bought by
Giri Shivraman and Gupta Oishika
Seller's Agent
Jill Clark
Compass
Buyer's Agent
Paul Ragi
@properties Christie's International Real Estate
List Price
$769,900
Sold Price
$745,000
Premium/Discount to List
-$24,900
-3.23%
Current Estimated Value
$1,012,481

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$267,481
Avg. Annual Appreciation
7.22%
Original Mortgage
$548,250
Outstanding Balance
$410,242
Interest Rate
2.13%
Mortgage Type
New Conventional
Estimated Equity
$602,239

Purchase Details

Closed on
Jan 21, 2001
Sold by
Lentz Ronald E and Lentz Julienne M
Bought by
Lentz Julienne M and Julienne M Lentz Trust

Purchase Details

Closed on
Sep 28, 2000
Sold by
Dirilten Suleyman
Bought by
Lentz Ronald E and Lentz Julienne M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$250,000
Interest Rate
8.03%

Purchase Details

Closed on
Sep 27, 2000
Sold by
Dirilten Mustafa and Dirilten Mary L
Bought by
Dirilten Suleyman

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$250,000
Interest Rate
8.03%

Purchase Details

Closed on
Apr 28, 2000
Sold by
Oliver Hoffmann Corp
Bought by
Dirilten Mustafa and Dirilten Mary L
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
Giri Shivraman $745,000 First American Title
Lentz Julienne M -- --
Lentz Ronald E $562,500 Collar Counties Title Plant
Dirilten Suleyman -- Collar Counties Title Plant
Dirilten Mustafa $101,000 Collar Counties Title Plant
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Gupta Oishika $548,250
Closed Giri Shivraman $548,250
Previous Owner Lentz Julienne M $316,000
Previous Owner Lentz Julienne M $196,000
Previous Owner Lentz Julienne M $249,142
Previous Owner Lentz Julienne M $260,000
Previous Owner Lentz Julienne M $260,000
Previous Owner Lentz Julienne M $247,000
Previous Owner Lentz Julienne M $431,250
Previous Owner Lentz Ronald E $250,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/23/2021 04/23/21 Sold $745,000 -3.2% $169 / Sq Ft
01/18/2021 01/18/21 Pending -- -- --
12/17/2020 12/17/20 For Sale $769,900 -- $174 / Sq Ft
Source: Midwest Real Estate Data (MRED)

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 $18,959 $297,460 $72,166 $225,294
2023 $18,959 $262,774 $63,751 $199,023
2022 $18,108 $248,579 $60,307 $188,272
2021 $16,807 $236,742 $57,435 $179,307
2020 $16,491 $232,991 $56,525 $176,466
2019 $16,214 $226,425 $54,932 $171,493
2018 $16,186 $222,067 $53,724 $168,343
2017 $15,943 $216,334 $52,337 $163,997
2016 $15,918 $211,677 $51,210 $160,467
2015 $15,833 $203,535 $49,240 $154,295
2014 $15,833 $198,477 $49,240 $149,237
2013 $15,833 $198,477 $49,240 $149,237
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: MRD10955214

Midwest Real Estate Data (MRED)

APN: 07-01-03-111-001