$775,000
SOLD AUG 29, 2024

1701 Red Stem Dr Holland, MI 49424

5 Beds
2.5 Baths
3,260 Sq Ft
0.51 Acres

Recently Sold

$238 Per Sq Ft

3% Above List Price

6 Days on Market

Highlights

  • Private Waterfront
  • Home fronts a pond
  • Wood Flooring
  • Lakewood Elementary School Rated A
  • Deck
  • Mud Room

About This Home

As of August 2024

Don't miss this gorgeous Brian Meiste custom built ranch home minutes from Lake Michigan. One of the standout features of this exquisite home is its stunning privacy, offering residents the perfect spot to relax amidst the trees and 228 feet of water frontage on the 6.3 acre lake. This 5 bedroom, 3 ½ bath home boasts 3,260 sq/ft of finished living space on a .51 acre private lot. The main level has a spacious living room w/ cathedral ceilings and gas log fireplace.The kitchen has center-island w/ granite surface, custom cabinetry, stainless steel appliances with its own eating area. Other main level features include 4 season room, large primary suite w/ tiled shower, soaking tub, private deck, laundry, and 2 large bedrooms w/ shared full bath. The entrance from the 3 stall garage goes into a spacious mudroom with a half bathroom.The house has been meticulously maintained and updated, ensuring that it is in pristine condition. A walkout lower level offers two bedrooms, full bathroom and large recreation room. The finished lower level is heated by its own radiant heating system and cooled with the force air system. Beyond the finished portion of the lower level you will find a large storage area with double doors leading to the lake where you can store paddle boards, paddle boats, kayaks, lawn mower, lawn tools, etc.

Last Agent to Sell the Property

Steve Bouman

Coldwell Banker Woodland Schmidt License #6501391320 Listed on: 07/24/2024

Coldwell Banker Woodland Schmidt

Co-Listed By

Larry Kleinheksel

Coldwell Banker Woodland Schmidt License #6501244844

Last Buyer's Agent

Steve Bouman

Coldwell Banker Woodland Schmidt License #6501391320 Listed on: 07/24/2024

Coldwell Banker Woodland Schmidt

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,774

Year Built

  • Built in 2007

Lot Details

  • 0.51 Acre Lot
  • Lot Dimensions are 105 x 135 x 200 x 250
  • Home fronts a pond
  • Private Waterfront
  • 228 Feet of Waterfront
  • Cul-De-Sac
  • Shrub
  • Sprinkler System
  • Garden

HOA Fees

  • $68 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Home Design

  • Brick Exterior Construction
  • Composition Roof
  • Vinyl Siding

Interior Spaces

  • 3,260 Sq Ft Home
  • 1-Story Property
  • Built-In Desk
  • Ceiling Fan
  • Gas Log Fireplace
  • Low Emissivity Windows
  • Insulated Windows
  • Window Treatments
  • Window Screens
  • Mud Room
  • Living Room with Fireplace
  • Water Views
  • Home Security System

Kitchen

  • Eat-In Kitchen
  • <<OvenToken>>
  • Range<<rangeHoodToken>>
  • <<microwave>>
  • Dishwasher
  • Kitchen Island
  • Snack Bar or Counter
  • Disposal

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms | 3 Main Level Bedrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Basement

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

Accessible Home Design

  • Low Threshold Shower
  • Halls are 36 inches wide or more
  • Rocker Light Switch
  • Doors with lever handles
  • Doors are 36 inches wide or more

Eco-Friendly Details

  • Air Purifier

Outdoor Features

  • Water Access
  • Deck
  • Patio
  • Water Fountains

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Radiant Heating System
  • Tankless Water Heater
  • Natural Gas Water Heater
  • Cable TV Available

Community Details

  • Association Phone (616) 610-7859

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,774

Year Built

Built in 2007

Lot Details

0

HOA Fees

$68 per month

Parking

3

Listing Details

  • Property Sub-Type: Single Family Residence
  • Property Type: Residential
  • New Construction: No
  • ArchitecturalStyle: Ranch
  • Stories: 1
  • Year Built: 2007
  • ResoPropertyType: Residential
  • Location Property Info:Property Sub-Type: Single Family Residence
  • General Property Info:New Construction2: No
  • General Property Info:Lot Dimensions: 105 x 135 x 200 x 250
  • General Property Info:Waterfront3: Yes
  • General Property Info:Basement: Yes
  • General Property Info:Total Fin SqFt All Levels: 3260.0
  • General Property Info:Main Level Primary: Yes
  • Tax Info:Annual Property Tax: 5774.0
  • Waterfront Options:Water Access YN: Yes
  • Roofing:Composition: Yes
  • Heat Type:Forced Air: Yes
  • Air Conditioning:Central Air: Yes
  • Manufactured:Manufactured YN: No
  • Substructure:Full: Yes
  • Appliances Dryer: Yes
  • Appliances Refrigerators: Yes
  • Washers: Yes
  • Landscape:ShrubsHedges: Yes
  • Heat Source:Natural Gas3: Yes
  • General Property Info:Total Fireplaces: 1.0
  • Util Avail at Street:Electric: Yes
  • Util Avail at Street:Natural Gas2: Yes
  • Utilities Attached:Cable: Yes
  • Utilities Attached:Natural Gas: Yes
  • Sewer:Public: Yes
  • Water:Public2: Yes
  • Lot Description:Cul-De-Sac: Yes
  • Waterfront Options:Water Frontage3: 228.0
  • Util Avail at Street:Cable2: Yes
  • Windows:Insulated Windows: Yes
  • Windows:Low Emissivity Windows: Yes
  • Windows:Screens: Yes
  • General Property Info:Fireplace: Yes
  • Heat Type:Radiant: Yes
  • Accessibility Feat:Low Threshold Shower: Yes
  • Additional Items:Ceiling Fans: Yes
  • Additional Items:Window Treatments: Yes
  • Appliances Microwave: Yes
  • Substructure:Walk Out: Yes
  • Additional Items:Humidifier: Yes
  • Water Heater:Natural Gas4: Yes
  • Landscape:Underground Sprinkler: Yes
  • Water Heater:Tankless: Yes
  • Landscape:Flower Garden: Yes
  • Landscape:Fountain: Yes
  • Accessibility Feat:Lever Door Handles: Yes
  • Accessibility Feat:Rocker Light Switches: Yes
  • General Property Info:SqFt Above Grade: 1955.0
  • Laundry Features Main Level: Yes
  • General Property Info Garage YN: Yes
  • Accessibility Feat 36 Inch Entrance Door: Yes
  • Accessibility Feat 36' or Hallway: Yes
  • Flooring:Wood Floor: Yes
  • Architectural Style:Ranch: Yes
  • Flooring:Ceramic Floor: Yes
  • Security Features:Security System: Yes
  • Other Equipment:Air Purifier: Yes
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Humidifier, Dishwasher, Disposal, Dryer, Microwave, Oven, Range, Refrigerator, Washer
  • Accessibility Features: Rocker Light Switches, 36 Inch Entrance Door, 36' or + Hallway, Covered Entrance, Lever Door Handles, Low Threshold Shower
  • Flooring: Ceramic Tile, Wood
  • Interior Amenities: Ceiling Fan(s), Garage Door Opener, Center Island, Eat-in Kitchen, Pantry
  • Fireplace Features: Gas Log, Living Room
  • Fireplace: Yes
  • Fireplaces: 1
  • Total Bedrooms: 5
  • Main Level Bedrooms: 3
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bathrooms: 3
  • Basement: Full, Walk-Out Access
  • LivingArea: 3260.0
  • Other Equipment: Air Purifier
  • Window Features: Low-Emissivity Windows, Screens, Insulated Windows, Window Treatments
  • General Property Info:Stories2: 1.0
  • Kitchen Features:Eating Area: Yes
  • Appliances:Oven: Yes
  • Appliances Range: Yes
  • Kitchen Features:Center Island: Yes
  • Kitchen Features:Mud Room Access: Yes
  • Kitchen Features Pantry: Yes
  • Fireplace:Gas Log: Yes
  • Fireplace:Living: Yes
  • Appliances Dishwasher: Yes
  • Kitchen Features:Snack Bar: Yes
  • Kitchen Features:Desk Built-In: Yes

Exterior Features

  • Construction Materials: Brick, Vinyl Siding
  • List Price: 750000.0
  • Lot Features: Cul-De-Sac
  • Patio and Porch Features: Deck, Patio
  • Road Surface Type: Paved
  • Roof: Composition
  • Water Body Name: Pond
  • Waterfront Features: Pond
  • Waterfront: Yes
  • Exterior Material:Vinyl Siding: Yes
  • Access Feat:Accessibility Features2: Yes
  • Driveway Paved: Yes
  • Exterior Material:Brick: Yes
  • Patio and Porch Features:Deck(s): Yes
  • Patio And Porch Features:Patio: Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3.0
  • Garage: Yes
  • Parking Features: Attached
  • Additional Items:Garage Door Opener: Yes
  • Parking Features Attached2: Yes
  • General Property Info:Garage Spaces: 3.0

Utilities

  • Cooling: Central Air
  • Cooling: Yes
  • Heating: Forced Air, Radiant
  • Heating: Yes
  • Laundry Features: Main Level
  • Security Features: Security System
  • Sewer: Public
  • Utilities: Natural Gas Available, Electricity Available, Cable Available, Natural Gas Connected, Cable Connected
  • Water Source: Public

Condo/Co-op/Association

  • Association Fee: 820.0
  • Association Fee Frequency: Annually
  • Association Phone: 616-610-7859
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Association/Amenities

  • Association Info:Approx Assoc Fee2: 820.0
  • Water Fea Amenities:Private Frontage: Yes
  • Association Info:Assoc Fee Payable: Annually
  • Water Fea Amenities:View: Yes
  • Association Info:Association Phone: 616-610-7859

Fee Information

  • Association Fee Includes: Other

Lot Info

  • Lot Size Acres: 0.51
  • Lot Size Area: 0.51
  • Lot Dimensions: 105 x 135 x 200 x 250
  • Lot Size Sq Ft: 22216.0
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Annual Amount: 5774.0
  • Tax Year: 2024

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 24, 2024
Closed on
Aug 29, 2024
Sold by
Pilger Raymond L and Pilger Judith A
Bought by
Matt J Downs Trust and Deirdre C Downs Trust
Seller's Agent
Steve Bouman
Coldwell Banker Woodland Schmidt
Buyer's Agent
Steve Bouman
Coldwell Banker Woodland Schmidt
List Price
$750,000
Sold Price
$775,000
Premium/Discount to List
$25,000
3.33%
Views
19
Current Estimated Value
$758,723

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$16,277
Avg. Annual Appreciation
-2.38%

Purchase Details

Closed on
May 4, 2006
Sold by
Barense Curtis and Barense Tammy
Bought by
Pilger Raymond L and Pilger Judith A

Purchase Details

Closed on
Sep 6, 2005
Sold by
Gff Holding Co Llc
Bought by
Barense Curtis and Barense Tammy

Home Financials for this Owner

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

Similar Homes in Holland, MI

  • 14921 Creek Edge Dr, Holland, MI 49424

    $759,900

    • 4 Beds
    • 2.5 Baths
    • 2,619 Sq Ft
    • 14921 Creek Edge Dr
    • Holland, MI

    This exceptional 4-bedroom, 2.5 bath custom built Bill Monhollon home is located in the highly sought after Timberline Acres. This stunning property showcases superior craftmanship, timeless design, and an extraordinary outdoor setting that's rarely available. This home is one of the only homes that comes with an extra manicured lot next door with a park like atmosphere. The custom built heated

    Emily Garcia Homes Coldwell Banker Woodland Schmidt

    Section Image
  • 2333 Eagle Dr, Holland, MI 49424

    $625,000

    • 4 Beds
    • 2 Baths
    • 1,922 Sq Ft
    • 2333 Eagle Dr
    • Holland, MI

    Enjoy a private beach association access on Lake Michigan and the best of lakeside living from this beautifully maintained home in Holland's desirable Eagle Crest community. The neighborhood also offers community areas with amenities like a fire pit and kayak/chair storage on the beach, tennis/pickleball courts, a basketball court, and a playground. Inside this Craftsman bi-level, you'll find an

    Andrea Crossman Coldwell Banker Woodland Schmidt

    Section Image
  • 2245 Auburn Ave, Holland, MI 49424

    $899,990

    • 4 Beds
    • 3 Baths
    • 1,704 Sq Ft
    • 2245 Auburn Ave
    • Holland, MI

    Welcome to 2245 Auburn Avenue—where coastal charm meets modern living. Completely remodeled from top to bottom, this stunning home is located in one of Holland's most coveted beach town neighborhoods, just steps from the iconic Ottawa Beach General Store and a short stroll to Holland State Park and the sandy shores of Lake Michigan.Every inch of this home has been thoughtfully updated

    Kyle Geenen Coldwell Banker Woodland Schmidt

    Section Image
  • 1130 S Shore Dr, Holland, MI 49423

    $660,000

    • 4 Beds
    • 2.5 Baths
    • 2,407 Sq Ft
    • 1130 S Shore Dr
    • Holland, MI

    Location, charm, and thoughtful updates—this home offers it all! Upon arrival, you'll notice this home is just steps from Lake Macatawa, two doors down from a neighborhood favorite, boutique grocery store, and a short drive to downtown Holland. Featuring 4 bedrooms, 2.5 bathrooms, a newly finished lower level, and added primary suite, this home boasts the perfect space for a growing family or

    Kyle Geenen Coldwell Banker Woodland Schmidt

    Section Image
  • 1632 Red Stem Dr, Holland, MI 49424

    $650,000

    • 6 Beds
    • 3.5 Baths
    • 4,065 Sq Ft
    • 1632 Red Stem Dr
    • Holland, MI

    This charming, whimsical, and stunning move-in ready home is nestled along the Lakeshore near Lake Michigan, offering easy access to beaches, boating, parks, and more! This quality-built Northside home features 6 bedrooms and 4 bathrooms, including a lower-level apartment or in-law suite. Upon entering, you'll find a flexible office space that leads into the inviting living room, complete with a

    Gina Vis HomeRealty, LLC

    Section Image
  • 401 Erin Isle Ct, Holland, MI 49424

    $609,000

    • 5 Beds
    • 3 Baths
    • 3,570 Sq Ft
    • 401 Erin Isle Ct
    • Holland, MI

    Welcome to 401 Erin Isle Court in the desirable Tiffany Shores neighborhood. The beautifully remodeled kitchen and mudroom to this contemporary farmhouse offers 5 bedrooms, and 3 full bathrooms. The open-concept main floor is ideal for entertaining, with bright and airy rooms throughout. Upstairs, you'll find a large primary suite featuring vaulted ceilings, cozy gas fireplace, and a private

    David Arnoldink West Edge Real Estate

    Section Image
  • 150 Bay Circle Dr, Holland, MI 49424

    $875,000

    • 5 Beds
    • 4 Baths
    • 4,020 Sq Ft
    • 150 Bay Circle Dr
    • Holland, MI

    A rare opportunity to own a meticulously maintained, custom-built home in the prestigious Bay Meadows neighborhood. Located in the award winning West Ottawa schools. Offered for the first time, this stunning Bosgraff-built residence seamlessly blends timeless craftsmanship with modern luxury, nestled on a beautifully landscaped lot overlooking a serene lake. 5 Bedrooms & 4 Full Bathrooms

    Chris Mendels Greenridge Realty

    Section Image
  • 40 Bay Circle Dr, Holland, MI 49424

    $849,900

    • 5 Beds
    • 4.5 Baths
    • 4,547 Sq Ft
    • 40 Bay Circle Dr
    • Holland, MI

    Check out 40 Bay Circle Dr! This beautiful 5 bedroom, 4.5 bath home is well-maintained and ready for its new owners. Great home for entertaining, outdoor enthusiasts and so much more! Enjoy a huge kitchen with tons of work space and natural light open to a cozy breakfast nook with fire place. A mudroom with storage, laundry room and half bath are conveniently located off of garage and kitchen

    Dean Kreps Greenridge Realty Holland

    Section Image
  • 94 Cheyenne Ave, Holland, MI 49424

    $594,900

    • 5 Beds
    • 4.5 Baths
    • 3,847 Sq Ft
    • 94 Cheyenne Ave
    • Holland, MI

    Spacious 5-Bedroom Home Near Tunnel Park & Lake Michigan - Under $600K! Welcome to your dream home located just minutes from Tunnel Park and the shores of Lake Michigan! This beautifully maintained 5-bedroom, 4.5-bathroom home offers the perfect blend of space, comfort, and convenience—all nestled in a quiet, family-friendly neighborhood. Built in 2015, this home features modern updates

    Joannie Bouman Coldwell Banker Woodland Schmidt

    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 Type Sale Price Title Company
Warranty Deed $775,000 Chicago Title
Warranty Deed $105,000 Lighthouse Title Inc
Warranty Deed $103,000 Chicago Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $93,000 Unknown
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/29/2024 08/29/24 Sold $775,000 +3.3% $238 / Sq Ft
07/30/2024 07/30/24 Pending -- -- --
07/24/2024 07/24/24 For Sale $750,000 -- $230 / Sq Ft
Source: Southwestern Michigan Association of REALTORS®

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
2025 $5,831 $290,700 $0 $0
2024 $4,601 $290,700 $0 $0
2023 $4,439 $239,100 $0 $0
2022 $5,237 $230,100 $0 $0
2021 $5,094 $231,700 $0 $0
2020 $5,042 $219,600 $0 $0
2019 $4,986 $205,000 $0 $0
2018 $4,641 $198,700 $0 $0
2017 $4,566 $198,700 $0 $0
2016 $4,540 $177,600 $0 $0
2015 -- $168,100 $0 $0
2014 -- $157,900 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Southwestern Michigan Association of REALTORS®

MLS Number: 24038000

Southwestern Michigan Association of REALTORS®

APN: 70-15-22-226-014