29 Sherman Avenue 24, Grand Haven, MI 49417 (MLS# 26037714)

29 Sherman Avenue 24, Grand Haven, MI 49417

New Listing

$995,000

Virtual Tour

https://www.propertypanorama.com/instaview/wmlar/26037714

Property Type: Residential Bedrooms: 2 Baths: 3 Square Footage: 1,184 Status: Active

Current Price: $995,000 List Date: 7/22/2026 Last Modified: 7/22/2026

Overview

Description

Welcome to 29 Sherman! Located in the most sought-after Condominium development in Grand Haven. This exquisitely remodeled/updated Sandpiper condo boasts unobstructed views of the Harbor Chanel, Dewey Hill, Musical Fountain, and Grand Haven's Annual Fireworks. Just a short walk to the YMCA, pickleball courts, beaches, boardwalk, restaurants, and downtown Grand Haven. From the moment you walk in, you are drawn to the clean, uncluttered, and calming structural lines of this home. Large Italian earth tone tiles throughout create a seamless and luminous feel ideal for entertaining. Main floor includes a large dining area, half bath, main floor laundry, along with a newly renovated custom open Ergonomic kitchen with elevated appliances, large granite counter-tops and center island. As you continue into the open gathering space, you'll appreciate the large windows showing off the lovely water views. Main floor primary suite has a convenient large step-in tile/stone shower and again more

Supplements: incredible views of the Chanel. The custom glass staircase continues the calming design with a large family room, 2nd bedroom, full bathroom, large cedar-lined inspiring art studio with commercial glass door. Lower-level also leads to a lower deck ,adjacent to a large grassy area, perfect for enjoying your morning coffee, watching the boats, and oc ... (Read more)

Listing Details MLS# 26037714

Location Property Info

County: Ottawa
Street #: 29
Street Name: Sherman
Suffix: Avenue
State: MI
Zip Code: 49417
Zip (4): 1782

General Property Info

New Construction: No
Lot Measurement: Acres
Year Built: 1982
Garage Y/N: Yes
Garage Spaces: 2
Fireplace: No
Income Property: No
Condo Proj Name: Sandpiper Villa
Total Rooms AG: 7
Total Fin SqFt All Levels: 2053
SqFt Above Grade: 1184
Below Grade Finished SqFt: 903
Below Grade Unfinished SqFt: 176
Building Total SqFt: 2158
Total Beds Above Grade: Yes
Total Bedrooms: 2
Full Baths: 2
Half Baths: Yes
Total Baths: 3
Main Level Primary: Yes
Stories: 2
School District: Grand Haven
Pets Y/N: No
Association Contact: Ken Terpstra
Association YN: Yes
Waterfront: No
Lot Dimensions: No
Road Frontage: 0
Basement: Yes
# of Outbuildings: 0

Tax Info

Tax ID #: 70-03-20-398-049
Taxable Value: 194330
SEV: 340600
For Tax Year: 2025
Seller's Annual Property Tax: 6686.98
Tax Year: 2025
Homestead %: 100
Spec Assessment & Type: none known

Remarks Misc

Directions: US 31 to Franklin West to Harbor Ave South to Sand Dr. left then a right onto Sherman Ave.

Access Feat

Accessibility Features: No

More Information

Upper Rooms

Total Baths Above Grade: 2
Upper Level Square Feet: 0

Main Rooms

Main Bedrooms: Yes
Main Full Baths: Yes
Main Half Baths: Yes
Main Level SQFT: 1079

Manufactured

Manufactured Y/N: No

Location & Property Info

Unit #: 24
Cross Streets: Leggat & Harbor
Property Sub-Type: Condominium
Municipality: Grand Haven City

Office/Contract Info

Auction or For Sale: For Sale
List Price/SqFt: 840.37

Remarks & Misc

Public Remarks: Welcome to 29 Sherman! Located in the most sought-after Condominium development in Grand Haven. This exquisitely remodeled/updated Sandpiper condo boasts unobstructed views of the Harbor Chanel, Dewey Hill, Musical Fountain, and Grand Haven's Annual Fireworks. Just a short walk to the YMCA, pickleball courts, beaches, boardwalk, restaurants, and downtown Grand Haven. From the moment you walk in, you are drawn to the clean, uncluttered, and calming structural lines of this home. Large Italian earth tone tiles throughout create a seamless and luminous feel ideal for entertaining. Main floor includes a large dining area, half bath, main floor laundry, along with a newly renovated custom open Ergonomic kitchen with elevated appliances, large granite counter-tops and center island. As you continue into the open gathering space, you'll appreciate the large windows showing off the lovely water views. Main floor primary suite has a convenient large step-in tile/stone shower and again more
Legal: UNIT 24. SANDPIPER VILLA CONDOMINIUM, AS AMENDED, MASTER DEED RECORDED IN OTTAWA COUNTY REGISTER OF DEEDS LIBER 942 PAGE 1, CONDOMINIUM SUBDIVISION PLAN NO. 54. SEC 20 T8N R16W

Water Type

Channel: Yes

Water Fea. Amenities

Channel: Yes
Public Access 1 Mile or Less: Yes
View: Yes

Lot Description

Site Condo: Yes

Street Type

Private: Yes

Util Avail at Street

High Speed Internet: Yes
Natural Gas Available: Yes

Sewer

Public Sewer: Yes

Water

Public: Yes

Terms Available

Cash: Yes
Conventional: Yes

Mineral Rights

Unknown: Yes

Association Info.

Approx. Assoc Fee: 375
Assoc. Fee Payable: Monthly
Association Phone: 616-638-1089

Laundry Features

Main Level: Yes

Exterior Material

Vinyl Siding: Yes

Assoc. Fee Incl.

Lawn/Yard Care: Yes
Snow Removal: Yes
Trash: Yes
Other: Yes

Roofing

Flat: Yes
Rubber: Yes
Stone: Yes

Parking Features

Garage Faces Front: Yes

Heat Source

Natural Gas: Yes

Sale Conditions

None: Yes

Heat Type

Forced Air: Yes

Air Conditioning

Central Air: Yes

Lower Rooms

Lower Bedrooms: Yes
Lower Full Baths: Yes
Lower Finished SQFT: 974
Total Lower SQFT: 1079

Basement Rooms

Basement Finished SQFT: 0
Total Basement SQFT: 0

Driveway

Concrete: Yes

Substructure

Full: Yes
Walk-Out Access: Yes

Windows

Insulated Windows: Yes

Kitchen Features

Center Island: Yes
Pantry: Yes

Appliances

Dishwasher: Yes
Dryer: Yes
Microwave: Yes
Oven: Yes
Refrigerator: Yes
Washer: Yes

Water Heater

Natural Gas: Yes

Exterior Features

Other: Yes

Patio and Porch Features

Deck: Yes
Enclosed: Yes

Flooring

Ceramic Tile: Yes
Stone: Yes
Tile: Yes

Landscape

Flower Garden: Yes
Ground Cover: Yes
Shrubs/Hedges: Yes
Underground Sprinkler: Yes

Architectural Style

Traditional: Yes

Possession

Close Plus 30 Days: Yes

Property Features

Water Type: Channel Laundry Features: Main Level Exterior Material: Vinyl Siding Roofing: Flat; Rubber; Stone Windows: Insulated Windows Substructure: Full; Walk-Out Access Lot Description: Site Condo Sewer: Public Sewer Water: Public Util Avail at Street: High Speed Internet; Natural Gas Available Kitchen Features: Center Island; Pantry Appliances: Dishwasher; Dryer; Microwave; Oven; Refrigerator; Washer Heat Source: Natural Gas Heat Type: Forced Air Air Conditioning: Central Air Water Heater: Natural Gas Exterior Features: Other Flooring: Ceramic Tile; Stone; Tile Patio and Porch Features: Deck; Enclosed Landscape: Flower Garden; Ground Cover; Shrubs/Hedges; Underground Sprinkler Parking Features: Garage Faces Front Architectural Style: Traditional Driveway: Concrete Street Type: Private Mineral Rights: Unknown Terms Available: Cash; Conventional Possession: Close Plus 30 Days Sale Conditions: None

Documents

Floor Plan ›

Listing Office: Greenridge Realty

Listing Agent: Chris Mendels

Last Updated: July - 22 - 2026

The data relating to real estate on this web site comes in part from the Internet Data Exchange program of the MLS of MICHRIC , and site contains live data. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.