Waterfront - Primary on Main
Address
2452 Holtman Drive Ne, Grand Rapids, MI
Price
$ 1,200,000
Property Attributes
- MLS#26045880
- TypeSingle Family
- Listing Status Pending
- CountyKent
- CityGrand Rapids
- NeighborhoodNA
- Zip49525
- StyleMid-Century Modern, Ranch
- Year Built1977
- Taxes$ 20075
- Price$ 1,200,000
- Bedrooms3
- Full Bathrooms3
- Half Bathrooms2
- Sqr Footage4040
- Lot Size0.92 Acres
Data Source:
Michigan Regional Information Center (MICHRIC)
Property Description
Welcome to 2452 Holtman Dr., one of the most iconic waterfront homes on all sports Dean Lake. Custom built by renowned builder Jordan Shepherd, the home itself is a work of art. Perfectly positioned on one of the lake's largest lots, this exceptional property is also one of the few to feature a private in-ground pool, creating the ultimate setting for lakeside living and entertaining. 6 Skylights were thoughtfully woven into the home's design to maximize natural light. The back of the home is a wall of windows offering breathtaking water views from nearly every room. Extensive decking and a large patio provides the perfect spot for both relaxing and entertaining. Dual furnaces, as well as dual A/C units, (2022), and a 65 gallon water heater (2012) assures comfort for everyone. Many updates have been done over the years including an extensive kitchen remodel, and new carpeting. The 1 acre lot is a gardener's paradise with immaculate landscaping combined with smaller areas to add color with annuals. Head down to the lake on a perfect set of stairs to relax at the firepit. Many lake residents hold memories of how that area has doubled as a helicopter landing pad over the years. Commercial grade seawall was recently installed to ensure a perfect shoreline for years to come. Don't miss this opportunity to enjoy lake life at its finest.
| Price History | |
|---|---|
| 8/28/2026 | Listed $1,200,000 |
General Features
| Sewer | Public |
|---|---|
| Heating | Forced Air |
| Cooling | Central Air |
| Utilities | Phone Available,Electricity Available,Cable Available,Natural Gas Connected |
| Possession | Close Of Escrow |
| Roof | Flat |
| Appliances | Cooktop,Dishwasher,Disposal,Double Oven,Dryer,Microwave,Refrigerator,Water Softener Owned |
| HOA Fee | 75 |
| Garage Spaces | 2 |
| Association Fee Includes | Other |
| Architectural Style | Mid-Century Modern,Ranch |
| Pool Features | In Ground,Outdoor/Above |
| Security Features | Smoke Detector(s),Security System |
| Construction Materials | Brick,Wood Siding |
| Exclusions | None |
| Year Built | 1977 |
| Stories Count | 2 |
| Township | Plainfield Twp |
| Property Subtype | Single Family Residence |
| Tax Year | 2026 |
| Ownership | Private Owned |
| Waterfront Features | Lake |
| Accessibility | Accessible M Flr Half Bath,Accessible Mn Flr Bedroom,Accessible Mn Flr Full Bath |
| Assoc Fee Paid Per | Annually |
| County | Kent |
| New Construction | false |
| Property Type | Residential |
| Association Amenities | Boat Launch |
| HOA | true |
| Attached Garage | false |
| Subdivision Name | NA |
| Garage Y/N | true |
| Other Structures | Shed(s) |
| Total Rooms | 9 |
| Full Baths | 3 |
| Status | Pending |
| Directions | Plainfield Ave to Northville Dr. Turn right on Lakehurst Dr., then left on Kearny. Kearny will end at Holtman Dr. Turn left and home will be on RH side. |
| City | Grand Rapids |
| Body of Water | Dean Lake |
| High School District | Northview |
| Zoning Description | Residential |
| Lot Size Units | Acres |
| Lot Size Square Feet | 39945 |
| Carport Y/N | No |
| Listing Terms | Cash,Conventional |
| Land Lease Y/N | No |
| Tax Annual Amount | 20075 |
| Home Warranty Y/N | No |
| Lease Renewal Y/N | No |
| Additional Parcels Y/N | No |
| Rent Control Y/N | No |
| Builder Name | Jordan Shepard |
| Standard Status | Pending |
| Occupancy Type | Vacant |
| Tax Assessed Value | 356775 |
| MobileHomeRemainsYN | No |
| Legal Description | LOT 37 * LAKEVIEW ESTATES NO.2 |
| Senior Community | None |
Interior Features
| Interior Amenities | Broadband,Central Vacuum,Garage Door Opener,Hot Tub Spa,Wet Bar,Center Island,Eat-in Kitchen,Pantry |
|---|---|
| Basement | Full,Walk-Out Access |
| Flooring | Carpet,Ceramic Tile,Linoleum |
| Total Fireplaces | 2 |
| Fireplace Features | Family Room,Gas Log,Living Room,Wood Burning |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Skylight(s),Screens,Insulated Windows,Bay/Bow,Window Treatments |
| Fireplace Y/N | true |
| Half Baths | 2 |
| Laundry Features | Laundry Room,Main Level |
| Total Bedrooms | 3 |
| Main Level Bedrooms | 1 |
| Total Baths | 5 |
| Pantry | true |
Exterior Features
| Exterior Amenities | Balcony,Scrn Porch |
|---|---|
| Parking Features | Garage Faces Front,Garage Door Opener |
| Water Source | Public |
| Lot Size Area | 0.92 |
| Spa | No |
| Building Area Total | 2287 |
| Lot Dimensions | 73 x 212 x 263 x 290 |
| BuyerOfficeFax | 000-000-0000 |
| OwnerPhone | NA |
| Lot Size Acres | 0.92 |
| Road Surface Type | Paved |
| Waterfront Y/N | true |
| Other Equipment | Dehumidifier,Intercom |
| Crops Included Y/N | No |
| Horse Y/N | No |
| Irrigation Water Rights Y/N | No |
| Dock | true |
| Private Frontage | true |
| View | true |
| All Sports | true |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in 49525
Price
Taxes
Year Built
Listing information is provided by Participants of the MichRIC MLS. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed. ©: MichRIC MLS. Last Update September 23, 2026 9:45 PM UTC
Midwest Real Estate Data (MRED) All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the Multiple Listing Service. Real estate listings held by brokerage firms other than Berkshire Hathaway HomeServices Michigan Real Estate - Grand Rapids may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. Copyright ©2026 All rights reserved.Based on information submitted to the MLS GRID as of September 23, 2026 9:18 PM UTC All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice.
Data is updated as of September 23, 2026 9:18 PM UTC
Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource.
The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary
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. Data is deemed reliable but is not guaranteed accurate by the MLS. IDX information is provided by the Indiana Regional MLS.
Information last updated on September 23, 2026 9:44 PM UTC
The content relating to real estate for sale and/or lease on this Web site comes in part from
the Internet Data eXchange ("IDX") program of the Northwest Indiana REALTORS® Association Multiple Listing Service ("NIRA MLS"). and is communicated verbatim, without change, as filed by its members. This information is being provided for the consumers' personal, noncommercial use and may not be used for any other purpose other than to identify prospective properties consumers may be interested in purchasing
Bay County REALTOR® Association All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested
Midland Board of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested
Water Wonderland Board of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested
Greater Lansing Association of Realtors® (GLAR) All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers
Northern Michigan MLS; All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
