NOT LISTED FOR SALE

6652 Ramshorn Dr Deforest, WI 53532

Estimated Value: $640,000 - $787,000

5 Beds
3.5 Baths
3,928 Sq Ft
$187/Sq Ft Est. Value

Last Sold February 23, 2023

Last sale price $675,000 $172 Per Sq Ft

Est. 9% increase in value since last sale

Current estimated payment $4,887/month

21 Days on Market

Highlights

  • Open Floorplan
  • Recreation Room
  • Ranch Style House
  • Windsor Elementary School Rated A-
  • Vaulted Ceiling
  • Wood Flooring

About This Home

As of February 2023

Stunning New Construction in Bear Tree. The home boasts almost 4000 square feet finished with top of the line parade quality finishes throughout. Home has a gourmet kitchen with Amish built Cherry Cabinets & top of line quartz tops. The main bath has a Kohler free standing soaking tub & luxury tile walk in shower with his & her shower heads. The lower level is fully finished with a rec room, bath, 4th & 5th bedrooms & wet bar. Other upgrades include Marvin windows, bamboo flooring, beautiful lighting package, screened in porch & patio area. The buyers can still select a kitchen back splash & carpet.

Last Agent to Sell the Property

Josh Lamp

Berkshire Hathaway HomeServices True Realty License #60880-94 Listed on: 01/03/2023

Berkshire Hathaway HomeServices True Realty

Co-Listed By

Bailey Fedler

Berkshire Hathaway HomeServices True Realty License #77651-94

Last Buyer's Agent

Rachael See

Compass Real Estate Wisconsin License #55812-94

Compass Real Estate Wisconsin

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,768

Year Built

  • Built in 2022

Lot Details

  • 0.37 Acre Lot
  • Property is zoned rec

Parking

  • 3 Car Garage

Home Design

  • Ranch Style House
  • Vinyl Siding
  • Stone Exterior Construction

Interior Spaces

  • Open Floorplan
  • Wet Bar
  • Vaulted Ceiling
  • Gas Fireplace
  • Great Room
  • Recreation Room
  • Screened Porch
  • Wood Flooring
  • Basement Fills Entire Space Under The House

Kitchen

  • Oven or Range
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Bathtub

Accessible Home Design

  • Accessible Full Bathroom
  • Accessible Bedroom
  • Doors are 36 inches wide or more

Outdoor Features

  • Patio

Schools

  • Call School District Elementary And Middle School
  • Call School District High School

Utilities

  • Forced Air Cooling System
  • Water Softener
  • High Speed Internet

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,768

Year Built

Built in 2022

Lot Details

0

Listing Details

  • Municipality: Windsor
  • Status Detail: Sold
  • Mailing City: DeForest
  • Class: Single Family
  • Type: Single Family
  • Type Of Property: 1 story
  • Architecture: Ranch
  • Barrier Free: Open floor plan, First floor bedroom, First floor full bath, Width of hallways 42"+, Door openings 36+
  • Items Included: Range/Oven, Fridge, Dishwasher, Disposal.
  • Year Built: 2022
  • Above Grade Price Per Sq Ft: 310.74
  • Above Grade Sold Price Per Sq Ft: 308.5
  • Special Features: NewHome
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Above Grade Finished Sq Ft: 2188
  • Finished Non Exp Sq Ft: 1740
  • Finished Sq Ft: 3928
  • Bedrooms: 5
  • Total Bathrooms: 3.5
  • Main Level Full Bathrooms: 2
  • Main Half Bathrooms: 1
  • Lower Level Full Bathrooms: 1
  • Total Full Bathrooms: 3
  • Total Half Bathrooms: 1
  • Master Bedroom: Dimensions: 17x14, On Level: M
  • Bedroom 2: Dimensions: 12x11, On Level: M
  • Bedroom 3: Dimensions: 12x11, On Level: M
  • Bedroom 4: Dimensions: 12x11, On Level: L
  • Bedroom 5: Dimensions: 12x11, On Level: L
  • Kitchen: Dimensions: 16x12, On Level: M
  • Kitchen Features: Pantry, Kitchen Island, Range/Oven, Refrigerator, Dishwasher, Disposal
  • Living Room: Dimensions: 16x17, On Level: M
  • Other Rooms: Rec Room, Screened Porch
  • Other Room 1: Screened Porch, Dimensions: 12x16, On Level: M
  • Other Room 2: Rec Room, Dimensions: 45x17, On Level: L
  • Basement: Full
  • Fireplace: Gas
  • Interior Amenities: Wood or sim. wood floor, Walk-in closet(s), Great room, Vaulted ceiling, Water softener inc, Wet bar, At Least 1 tub, Internet - Cable
  • Primary Bedroom Bathrooms: Full

Exterior Features

  • Exterior: Vinyl, Stone
  • Exterior Features: Patio

Garage/Parking

  • Driveway: Paved
  • Garage: 3 car
  • Total Full Garage Stalls: 3

Utilities

  • Fuel: Natural gas
  • Heating Cooling: Forced air, Central air
  • Water Waste: Municipal water, Municipal sewer

Schools

  • School District: DeForest
  • Elementary School: Call School District
  • Middle School: Call School District
  • High School: Call School District
  • Elementary School: Call School District
  • High School: Call School District
  • Middle School: Call School District
  • School District: DeForest

Lot Info

  • Assessor Parcel Number: 0910-284-4829-1
  • Estimated Aces: 0.37
  • Zoning: rec
  • Geo Subdivision: WI

Tax Info

  • Assessment year: 2023
  • Tax Year: 2023

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 3, 2023
Closed on
Feb 23, 2023
Sold by
Lamp Joshua
Bought by
Martinez-Najera Kerri L and Martinez-Najera Moises
Seller's Agent
Josh Lamp
Berkshire Hathaway HomeServices True Realty
Buyer's Agent
Rachael See
Compass Real Estate Wisconsin
List Price
$679,900
Sold Price
$675,000
Premium/Discount to List
-$4,900
-0.72%
Total Days on Market
21
Views
58
Current Estimated Value
$733,871

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$58,871
Avg. Annual Appreciation
7.14%

Purchase Details

Closed on
Sep 12, 2022
Sold by
Bear Tree Farms Inc
Bought by
Lamp Joshua

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$490,000
Interest Rate
6.13%
Mortgage Type
New Conventional
Source: Public Records

Similar Homes in the area

  • 6631 Grouse Woods Rd, Deforest, WI 53532

    $658,875

    • 5 Beds
    • 3 Baths
    • 2,600 Sq Ft
    • 6631 Grouse Woods Rd
    • Deforest, WI

    Under Construction, completion August 2025. Tim O'Brien Homes Monterey plan opens into a spacious foyer. A bedroom and full bath are featured on the main level of the home. The great room boasts a cozy fireplace and a beautiful cathedral ceiling. Quartz countertops and range hood make this large kitchen a chef's dream. A spacious dinette and expansive rear foyer are in the rear of the home.

    Aeryn Barry Tim O'Brien Homes LLC

    Section Image
  • 6643 Royal View Dr, Deforest, WI 53532

    $619,900

    • 4 Beds
    • 3 Baths
    • 2,703 Sq Ft
    • 6643 Royal View Dr
    • Deforest, WI

    Welcome to this brand-new, crafted ranch home. Ready by May. Featuring an open floor plan, vaulted ceiling, large windows, and LVP flooring. Gas fireplace, kitchen with SS appliances, quartz countertops, tile backsplash, and a spacious island. Primary bedroom with backyard views, ceiling fan, en-suite bathroom, tile shower, double vanity, and walk-in closet. Two additional bedrooms on the main

    Xue Yu Coldwell Banker Real Estate Group

    Section Image
  • 6642 Royal View Dr Unit 169, Deforest, WI 53532

    $654,580

    • 5 Beds
    • 3.5 Baths
    • 2,932 Sq Ft
    • 6642 Royal View Dr
    • Unit 169
    • Deforest, WI

    New construction with est August 25' completion. This beautiful two-story home features a 3-car plus tandem garage stall, with the 3rd stall extending 31ft deep with 8ft garage doors! Enjoy views of nature and your massive backyard from the sunroom off the kitchen / dining area. Quartz countertops in the kitchen with an oversized island perfect for the home chef! A home office/study on the main

    Alex Meunier Home Brokerage and Realty

    Section Image
  • 4104 Painted Arabian Run, Deforest, WI 53532

    $629,000

    • 4 Beds
    • 3 Baths
    • 2,595 Sq Ft
    • 4104 Painted Arabian Run
    • Deforest, WI

    Better than new ranch home located in Bear Tree Farms across from greenspace/park. Beautiful open floor plan cathedral ceiling, w/large open kitchen w/island, quartz countertops, LVP, SS appliances, custom gas fireplace, mudroom, primary suite w/walk-in closet, walk-in tile shower, heated towel bars & shower. The LL is exposed w/plenty of natural light 2bdrns, full bath & storage. This gorgeous

    Tammy Shallberg Restaino & Associates

    Section Image
  • 6695 Burnick Ct, Deforest, WI 53532

    $795,000

    • 4 Beds
    • 5 Baths
    • 4,402 Sq Ft
    • 6695 Burnick Ct
    • Deforest, WI

    Contemporary ranch home on a secluded 2.81-acre wooded lot, free from covenants and restrictions, animals are welcome. Highlights include: a professional-grade kitchen with Quartz countertops, dual islands, a spacious dining room with a wet bar and double-sided fireplace; and a living room with floor to ceiling windows and hickory flooring. The master suite features a distinctive double barn door

    David Baehr American, REALTORS

    Section Image
  • 4003 Banbury St, Windsor, WI 53598

    $589,460

    • 4 Beds
    • 3 Baths
    • 2,509 Sq Ft
    • 4003 Banbury St
    • Windsor, WI

    Eligible buyers may qualify for a 2/1 buy-down (10%+ down): Year 1 at 3.5%, Year 2 at 4.5%, Years 3–30 at 5.5% + $5,000 closing cost credit. Or choose a 7-year ARM: 4.5% (5%+ down) or 3.99% (10%+ down) with $5,000 closing credit—must close with Lennar Mortgage by August 29! This Bryce I Floor Plan by Lennar Homes on site #134 in Windsor Crossing is available for move in Aug-Sept '25! This 4 bed

    Emily Ostermiller First Weber Inc

    Section Image
  • 3993 Banbury St, Windsor, WI 53598

    $583,990

    • 4 Beds
    • 3 Baths
    • 2,509 Sq Ft
    • 3993 Banbury St
    • Windsor, WI

    This new two-story home is a family-friendly haven with a first floor featuring an open design among the kitchen, breakfast room and family room. Ideal for hosting overnight guests, there is also a privately situated bedroom on the same level. Upstairs are a generously sized loft that adds shared living space, two secondary bedrooms and the owner’s suite. A versatile two-car garage completes the

    Section Image
  • 4008 Banbury St, Windsor, WI 53598

    $649,900

    • 5 Beds
    • 3 Baths
    • 2,907 Sq Ft
    • 4008 Banbury St
    • Windsor, WI

    Eligible buyers may qualify for a 5.875% 30-year fixed rate depending on $ down w/ Lennar MTG if closed on or before 7/31/25. The Raleigh C Floor Plan by Lennar Homes, located on homesite #146 in Windsor Crossing, will be available for move-in by June/July 2025. This stunning home features 5 beds, 3 baths, and designer finishes throughout, including luxurious quartz countertops, beautiful LVP

    Emily Ostermiller First Weber Inc

    Section Image
  • 4011 Banbury St, Windsor, WI 53598

    $594,615

    • 4 Beds
    • 3 Baths
    • 2,509 Sq Ft
    • 4011 Banbury St
    • Windsor, WI

    Eligible buyers may qualify for a 1/0 buydown (4.875/5.875) through Lennar Mortgage if closed by Nov 28th PLUS a $5,000 closing cost credit. This Bryce G Floor Plan by Lennar Homes on homesite #138 in Windsor Crossing is available for move in Aug '25! This 4 bed, 3 bath, 2-story home features a gas fireplace, spacious rooms, loft, and a 3-car garage. This brand new home features designer finishes

    Emily Ostermiller First Weber Inc

    Section Image

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
Martinez-Najera Kerri L $674,900 --
Lamp Joshua $90,200 --
Bear Tree Farms Inc -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Lamp Joshua $490,000
Previous Owner Pc Farm Holdings Llc $443,730
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/23/2023 02/23/23 Sold $675,000 +649.1% $172 / Sq Ft
02/23/2023 02/23/23 Sold $90,113 -86.7% --
01/03/2023 01/03/23 For Sale $679,900 +631.9% $173 / Sq Ft
12/13/2021 12/13/21 Pending -- -- --
09/06/2021 09/06/21 For Sale $92,900 -- --
Source: South Central Wisconsin 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 $9,768 $560,200 $91,200 $469,000
2023 $5,134 $301,200 $91,200 $210,000
2021 $12 $100 $100 $0
2020 $10 $100 $100 $0
2019 $8 $100 $100 $0
2018 $427 $100 $100 $0
2017 $2 $100 $100 $0
2016 $2 $100 $100 $0
2015 -- $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: South Central Wisconsin Multiple Listing Service

MLS Number: 1948370

South Central Wisconsin Multiple Listing Service

APN: 0910-284-4829-1