NOT LISTED FOR SALE

Estimated Value: $799,000 - $846,809

5 Beds
3 Baths
3,140 Sq Ft
$260/Sq Ft Est. Value

Last Sold March 13, 2023

Last sale price $727,500 $232 Per Sq Ft

Est. 12% increase in value since last sale

Current estimated payment $5,768/month

2 Days on Market

Highlights

  • Open Floorplan
  • Landscaped Professionally
  • Traditional Architecture
  • Clifford Crone Middle School Rated A
  • Property is near a park
  • Main Floor Bedroom

About This Home

As of March 2023

JUST GORGEOUS! "PICTURE PERFECT"! THIS HIGHLY UPGRADED & UPDATED HOME IN THE WAGNER FARMS SUBDIVISION IS BRAND NEW TO THE MARKET! 5 BEDROOMS! 3 FULL BATHROOMS! 3,140 SF! OPEN FLOOR PLAN! 2ND FLOOR LOFT! AWARD WINNING SCHOOL DISTRICT # 204 W/NEUQUA VALLEY HIGH SCHOOL! BUILT IN 2020! GOURMET KITCHEN W/UPGRADED STAINLESS STEEL APPLIANCES INCLUDING HOODED VENT W/COOK TOP, CUSTOM BACK SPLASH, UPGRADED CABINETRY, GRANITE COUNTERS, CENTER ISLAND/BREAKFAST BAR, BUTLER PANTRY, WALK-IN PANTRY, EAT-IN AREA & HARDWOOD LAMINATE FLOORS! LARGER FAMILY ROOM W/GAS FIREPLACE AND TV WALL MOUNT & HARDWOOD LAMINATE! 1ST FLOOR SUNROOM W/HARDWOOD LAMINATE LEADING TO HUGE STAMPED CONCRETE PATIO! FORMAL DINING ROOM! 5TH BEDROOM/OFFICE W/CLOSET ON 1ST FLOOR MAKING IT A POSSIBLE IN-LAW SUITE W/FULL BATHROOM! WONDERFUL PLANNING DESK AREA AS WELL! MASTER BEDROOM SUITE W/SITTING AREA, HIS/HER CLOSETS & SPA "LIKE" MASTER BATHROOM W/SEPARATE SHOWER, PRIVATE WATER CLOSET, DUAL SINK VANITY & SOAKING TUB! 2ND FLOOR LAUNDRY! 3 OTHER BEDROOMS LOCATED ON THE 2ND FLOOR ALL HAVE ADDITIONAL LIGHTING AND CEILING FANS INSTALLED! FULL UNFINISHED BASEMENT AWAITING YOUR FINISHING IDEAS W/BACK-UP SUMP AND HIGH EFFICIENCY MECHANICALS! 2 1/2 CAR GARAGE W/UPGRADE POLYURETHANE FLOORING! OAK STAIRS WERE INSTALLED TO REPLACE BUILDER CARPET LEADING TO 2ND FLOOR! ALL BATHROOMS WERE COMPLETELY UPGRADED! UPGRADED FRONT FACADE AND GARAGE DOOR! THIS IS A MUST SEE HOME! MULTIPLE OFFERS RECEIVED.... HIGHEST AND BEST CALL FOR BY 2/13 10:00AM

Last Agent to Sell the Property

Jeff Stainer

RE/MAX Action License #475118334 Listed on: 02/10/2023

RE/MAX Action

Last Buyer's Agent

Maribel Lopez

Keller Williams Infinity License #475168274

Keller Williams Infinity

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $15,257

Year Built

  • Built in 2020

Lot Details

  • Lot Dimensions are 57x120
  • Landscaped Professionally
  • Paved or Partially Paved Lot

HOA Fees

  • $52 Monthly HOA Fees

Parking

  • 2.5 Car Attached Garage
  • Garage Transmitter
  • Garage Door Opener
  • Driveway
  • Parking Space is Owned

Home Design

  • Traditional Architecture
  • Asphalt Roof

Interior Spaces

  • 3,140 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Ceiling Fan
  • Gas Log Fireplace
  • Blinds
  • Family Room with Fireplace
  • Sitting Room
  • Formal Dining Room
  • Loft
  • Heated Sun or Florida Room
  • Laminate Flooring
  • Unfinished Basement
  • Basement Fills Entire Space Under The House
  • Carbon Monoxide Detectors

Kitchen

  • Built-In Oven
  • Cooktop with Range Hood
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Granite Countertops
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • 5 Potential Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • In-Law or Guest Suite
  • Bathroom on Main Level
  • 3 Full Bathrooms
  • Dual Sinks
  • Soaking Tub
  • Separate Shower

Laundry

  • Laundry Room
  • Dryer
  • Washer
  • Sink Near Laundry

Schools

  • Kendall Elementary School
  • Crone Middle School
  • Neuqua Valley High School

Utilities

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

Additional Features

  • Stamped Concrete Patio
  • Property is near a park

Community Details

  • Association fees include insurance
  • Proeprty Manager Association, Phone Number (847) 806-6121
  • Wagner Farms Subdivision, Continental Floorplan
  • Property managed by Property Specialist, Inc

Listing and Financial Details

  • Homeowner Tax Exemptions

Home Details

Home Type

Single Family

Est. Annual Taxes

$15,257

Year Built

Built in 2020

Lot Details

0

HOA Fees

$52 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Type: Detached Single
  • Type Detached: 2 Stories
  • Ownership: Fee Simple w/ HO Assn.
  • ArchitecturalStyle: Traditional
  • New Construction: No
  • Property Sub-Type: 2 Stories
  • Subdivision Name: Wagner Farms
  • Year Built: 2020
  • Age: 1-5 Years
  • Built Before 1978 (Y/N): No
  • Disability Access and/or Equipped: No
  • General Information: School Bus Service,Commuter Bus
  • Rebuilt (Y/N): No
  • Rehab (Y/N): No
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Microwave, Dishwasher, Refrigerator, Washer, Dryer, Disposal, Stainless Steel Appliance(s), Cooktop, Built-In Oven, Range Hood
  • Basement: Full
  • Full Bathrooms: 3
  • Total Bathrooms: 3
  • Total Bedrooms: 5
  • Fireplace Features: Gas Log
  • Fireplaces: 1
  • Interior Amenities: Wood Laminate Floors, First Floor Bedroom, In-Law Arrangement, First Floor Full Bath, Walk-In Closet(s), Open Floorplan, Drapes/Blinds, Granite Counters
  • LivingArea: 3140
  • Other Equipment: CO Detectors, Ceiling Fan(s), Backup Sump Pump;
  • Room Type: Bedroom 5, Loft, Heated Sun Room, Sitting Room
  • Estimated Total Finished Sq Ft: 0
  • Assessed Sq Ft: 0
  • Basement Description: Unfinished
  • Bathroom Amenities: Separate Shower,Double Sink,Soaking Tub
  • Basement Bathrooms: No
  • Below Grade Bedrooms: 0
  • Dining Room: Separate
  • Total Sq Ft: 0
  • Fireplace Location: Family Room
  • Total Sq Ft: 0
  • ResoLivingAreaSource: Appraiser

Exterior Features

  • ExteriorFeatures: Stamped Concrete Patio
  • List Price: 724323
  • Lot Features: Landscaped
  • Roof: Asphalt
  • Waterfront: No
  • Exterior Building Type: Vinyl Siding,Stone,Other

Garage/Parking

  • Garage Spaces: 2.5
  • Number of Cars: 2.5
  • Driveway: Asphalt
  • Garage Details: Garage Door Opener(s),Transmitter(s)
  • Garage On-Site: Yes
  • Garage Ownership: Owned
  • Garage Type: Attached
  • Parking: Garage

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Natural Gas, Forced Air
  • Laundry Features: Gas Dryer Hookup, In Unit, Sink
  • Water Source: Lake Michigan

Condo/Co-op/Association

  • Association Fee: 155
  • Association Fee Frequency: Quarterly
  • Community Features: Park, Sidewalks, Street Lights, Street Paved
  • Master Association Fee: No
  • Master Association Fee Frequency: Not Required
  • Management Company: Property Specialist, Inc
  • Management Contact Name: Proeprty Manager
  • Management Phone: 847-806-6121
  • ResoAssociationFeeFrequency: Quarterly

Fee Information

  • Association Fee Includes: Insurance

Schools

  • Elementary School: Kendall Elementary School
  • High School: Neuqua Valley High School
  • Middle/Junior School: Crone Middle School
  • Middle/Junior School District: 204

Lot Info

  • Lot Dimensions: 57X120
  • Rural (Y/N): N
  • Lot Size: Less Than .25 Acre
  • Special Assessments: N

Rental Info

  • Board Number: 10

Tax Info

  • Tax Year: 2021
  • Tax Exemptions: Homeowner

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 10, 2023
Closed on
Mar 13, 2023
Sold by
Sahota Gurpreet Singh
Bought by
Gopalkrishnan Subramanian and Ramanathan Divya
Seller's Agent
Jeff Stainer
RE/MAX Action
Buyer's Agent
Maribel Lopez
Keller Williams Infinity
List Price
$724,323
Sold Price
$727,500
Premium/Discount to List
$3,177
0.44%
Views
21
Current Estimated Value
$817,452

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$89,952
Avg. Annual Appreciation
4.84%
Original Mortgage
$640,200
Outstanding Balance
$622,752
Interest Rate
6.5%
Mortgage Type
New Conventional
Estimated Equity
$194,885

Purchase Details

Closed on
Mar 17, 2020
Sold by
Pulte Home Company Llc
Bought by
Sahota Gurpreet Singh and Sahota Amneet K

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$510,400
Interest Rate
3.5%
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
Gopalkrishnan Subramanian $727,500 Fidelity National Title
Sahota Gurpreet Singh $576,903 Pgp Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Gopalkrishnan Subramanian $640,200
Previous Owner Sahota Gurpreet Singh $492,000
Previous Owner Sahota Gurpreet Singh $510,400
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/13/2023 03/13/23 Sold $727,500 +0.4% $232 / Sq Ft
02/14/2023 02/14/23 For Sale $724,323 0.0% $231 / Sq Ft
02/13/2023 02/13/23 Pending -- -- --
02/10/2023 02/10/23 For Sale $724,323 -- $231 / 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
2023 $15,257 $216,696 $46,557 $170,139
2022 $14,522 $188,023 $44,042 $143,981
2021 $12,607 $179,070 $41,945 $137,125
2020 $7,660 $373 $373 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: 11716834

Midwest Real Estate Data (MRED)

APN: 07-01-10-312-003