Property Attributes
- MLS#26027299
- TypeSingle Family
- Listing Status Active
- CountyKENT
- CityComstock Park
- AreaPlainfield Twp
- NeighborhoodPlainfield Twp
- Zip49321
- StyleTraditional
- Year Built2003
- Taxes$ 10393
- Price$ 1,640,000
- Bedrooms5
- Full Bathrooms4
- Half Bathrooms1
- Sqr Footage4800
- Lot Size2 Acres
Data Source:
Michigan Regional Information Center (MICHRIC)
Property Description
Rare opportunity on 2 private acres with exceptional frontage on all-sports Freska Lake in sought-after Rockford Schools, just minutes from downtown Rockford and less than 20 minutes to downtown Grand Rapids. This custom luxury home offers breathtaking sunrise views and is designed to maximize privacy while capturing beautiful lake views. Features include a new roof, covered wraparound Spancrete deck, screened porch, elevator shaft, dumbwaiter, custom closet built-ins, whole-home lighting and audio controls, geothermal, generator, RO system, central vac, and extensive garage space, including a lakeside garage with instant hot water shower. Enjoy a private dock, swim area, and excellent fishing. The main floor includes an office, mudroom, kitchen, dining, and living areas. Upstairs are 4 bedrooms, including 3 ensuites with lake views. The walkout level offers a kitchenette, family room, bedroom, flex guest room, bath, storage, and lower-level garage. A truly unique lakefront retreat.
| Elementary School | Middle School | High School |
|---|---|---|
| Belmont Elementary School | North Rockford Middle School | Rockford High School |
| Price History | |
|---|---|
| 6/5/2026 | Listed $1,800,000 |
| 6/25/2026 | 6$1,699,000 |
| 8/22/2026 | 4$1,640,000 |
General Features
| Sewer | Septic Tank |
|---|---|
| Heating | Forced Air,Radiant |
| Cooling | Central Air |
| Possession | See Remarks |
| Appliances | Humidifier,Built-In Electric Oven,Cooktop,Dishwasher,Dryer,Microwave,Refrigerator,Washer |
| HOA Fee | 300.0 |
| Garage Spaces | 5.0 |
| Association Fee Includes | Snow Removal |
| Architectural Style | Traditional |
| Construction Materials | HardiPlank Type,Stone |
| Year Built | 2003 |
| Stories Count | 2 |
| Township | Plainfield Twp |
| Property Subtype | Single Family Residence |
| Tax Year | 2025 |
| Waterfront Features | Lake |
| Assoc Fee Paid Per | Annually |
| County | Kent |
| New Construction | No |
| Property Type | Residential |
| HOA | Yes |
| Attached Garage | Yes |
| Garage Y/N | Yes |
| Total Rooms | 15 |
| Full Baths | 4 |
| Status | Active |
| Directions | US 131 to 10 Mile,West on 10 Mile,South on Freska Lake Drive. |
| City | Comstock Park |
| Body of Water | Freska Lake |
| High School District | Rockford |
| Zoning Description | R |
| Lot Size Units | Acres |
| Lot Size Square Feet | 87120.0 |
| Carport Y/N | No |
| Listing Terms | Cash,VA Loan,Conventional |
| Land Lease Y/N | No |
| Tax Annual Amount | 10393.3 |
| Home Warranty Y/N | No |
| Lease Renewal Y/N | No |
| Additional Parcels Y/N | No |
| Rent Control Y/N | No |
| Virtual Tour | https://listings.teamhorizonmedia.com/sites/eppozlnd/unbranded |
| Standard Status | Active |
| Tax Assessed Value | 318462 |
| MobileHomeRemainsYN | No |
| Legal Description | PART NWFRL 1/4 COM AT SW COR OF SEC 32 T9N R11W TH S 89D 51M 23S E 1414.67 FT TH S 00D 10M 32S W 108.81 FT TH S 10D 14M 15S E 289.19 FT TH S 00D 20M 04S E 173.60 FT TH S 11D 45M 25S E 210.42 FT TH S |
| Senior Community | None |
Interior Features
| Interior Amenities | Central Vacuum |
|---|---|
| Basement | Walk-Out Access |
| Flooring | Wood |
| Total Fireplaces | 2 |
| Fireplace Features | Family Room,Gas Log,Living Room |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Half Baths | 1 |
| Laundry Features | Upper Level |
| Total Bedrooms | 5 |
| Below Grade Finished Area | 0.0 |
| Total Baths | 5 |
Exterior Features
| Exterior Amenities | Scrn Porch |
|---|---|
| Parking Features | Garage Door Opener,Attached |
| Lot Features | Cul-De-Sac |
| Water Source | Private Water,Public |
| Lot Size Area | 2.0 |
| Spa | No |
| Building Area Total | 3752.0 |
| Lot Dimensions | Irr |
| Lot Size Acres | 2.0 |
| Road Surface Type | Paved |
| Waterfront Y/N | Yes |
| Road Frontage Type | Private Road |
| Other Equipment | Generator |
| 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 49321
In The Neighborhood
Rockford
$ 425,000
- Type
- Single Family
- Size
- 2,164 SqFt
- Rooms
- 4 Beds + 2.5 Baths
Comstock Park
$ 575,000
- Type
- Single Family
- Size
- 3,600 SqFt
- Rooms
- 6 Beds + 3 Baths
Belmont
$ 289,900
- Type
- Single Family
- Size
- 1,014 SqFt
- Rooms
- 2 Beds + 1 Baths
Grand Rapids
$ 500,000
- Type
- Single Family
- Size
- 2,237 SqFt
- Rooms
- 4 Beds + 2 Baths
Grand Rapids
$ 299,900
- Type
- Single Family
- Size
- 1,201 SqFt
- Rooms
- 3 Beds + 1 Baths
Belmont
$ 599,900
- Type
- Single Family
- Size
- 3,414 SqFt
- Rooms
- 5 Beds + 3.5 Baths
Belmont
$ 619,900
- Type
- Single Family
- Size
- 2,457 SqFt
- Rooms
- 3 Beds + 3.5 Baths
Rockford
$ 789,900
- Type
- Single Family
- Size
- 2,710 SqFt
- Rooms
- 4 Beds + 2.5 Baths
Rockford
$ 569,900
- Type
- Single Family
- Size
- 3,100 SqFt
- Rooms
- 4 Beds + 3.5 Baths
Belmont
$ 599,900
- Type
- Single Family
- Size
- 3,394 SqFt
- Rooms
- 5 Beds + 3.5 Baths
Rockford
$ 890,000
- Type
- Single Family
- Size
- 3,127 SqFt
- Rooms
- 4 Beds + 3 Baths
Belmont
$ 365,000
- Type
- Single Family
- Size
- 1,611 SqFt
- Rooms
- 3 Beds + 1 Baths
Grand Rapids
$ 650,000
- Type
- Single Family
- Size
- 6,055 SqFt
- Rooms
- 5 Beds + 4.5 Baths
Grand Rapids
$ 229,876
- Type
- Single Family
- Size
- 912 SqFt
- Rooms
- 3 Beds + 1 Baths
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 17, 2026 3:15 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 17, 2026 2:24 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 17, 2026 2:24 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 17, 2026 3:24 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.