Waterfront
Address
2591 S Ramshorn Drive, Fremont, MI
Price
$ 2,500,000
Property Attributes
- MLS#298408
- TypeSingle Family
- Listing Status Active
- CountyNEWAYGO
- CityFremont
- Zip49412
- StyleRanch
- Year Built2005
- Taxes$ 9767
- Price$ 2,500,000
- Bedrooms3
- Full Bathrooms2
- Half Bathrooms0
- Sqr Footage1248
- Lot Size22.5 Acres
Data Source:
Greater Lansing AOR (GLMLS)
Property Description
Built by a horseman for horsemen, this exceptional equestrian facility is designed from the ground up for daily efficiency, with everything a serious training operation needs under one roof. The arena wing is a 100' x 300' space anchored by a 100' x 200' riding area large enough to accommodate any discipline, with the remaining 100' x 100' dedicated to an Equi-ciser brand hot walker and round pen all under one roof for seamless transitions between warm-up, work, and cool-down, and the ability to monitor multiple horses at once. An 80' x 300' outdoor arena adds further training space to work with the seasons. The stall wing houses 32 stalls, a feed room, shoeing bay, sawdust bunk, and hay loft to keep daily operations organized and running smoothly. Five groom bays and two wash racks with hot water make horse care efficient, while multiple tack rooms, a barn office, and tractor storage round out the workspace. Multiple water and electric hookups accommodate trailers with ease, making this a seamless stop for hauling in and out. Radiant in-floor heat runs throughout the stall wing (not the arena wing), keeping daily chores comfortable through the coldest months. A barn lounge with full kitchen, living area, full bath, office, and non-conforming bedroom offers flexible space — ideal as a gathering area for clients, or for extended hours at the barn and overnight accommodations during training or foaling season.This sale includes both Parcel IDs 13-24-100-021 and 13-24-100-022, for a total of 22.5 acres with private frontage on Clarks Lake. Parcel 021 includes a 3-bedroom, 2-full-bath home with a basement and detached garage, offering private living quarters apart from the barn. See attached documents for a full list of amenities.
| Price History | |
|---|---|
| 8/12/2026 | Listed $2,500,000 |
General Features
| Sewer | Septic Tank |
|---|---|
| Heating | Forced Air,Hot Water,Propane,Radiant Floor,Varies by Unit |
| Cooling | Central Air |
| Utilities | Phone Connected,High Speed Internet Available,Electricity Connected,Cable Connected,Propane |
| Roof | Shingle,Steel |
| Appliances | Dishwasher,Dryer,Electric Oven,Electric Range,Free-Standing Refrigerator,Freezer,Gas Water Heater,Microwave,Refrigerator,Stainless Steel Appliance(s),Washer,Water Purifier Rented,Water Softener Owned |
| Garage Spaces | 0.0 |
| Patio/Porch Features | Covered,Front Porch,Patio,Rear Porch |
| Architectural Style | Ranch |
| Construction Materials | Steel Siding,Vinyl Siding,Wood Siding |
| Year Built | 2005 |
| Electric | 200+ Amp Service,220 Volts,Generator |
| View | Lake,Pasture,Rural,Trees/Woods |
| Township | None |
| Levels | One |
| Property Subtype | Single Family Residence |
| Tax Year | 2025 |
| Current Use | Primary,Investment |
| Waterfront Features | Lake,Lake Front |
| County | Newaygo |
| New Construction | No |
| Property Type | Residential |
| Attached Garage | No |
| Subdivision Name | None |
| Garage Y/N | No |
| Other Structures | Arena,Barn(s),Corral(s),Covered Arena,Guest House,Residence,Second Residence,Shed(s),Stable(s),Storage,Pole Barn |
| Total Rooms | 7 |
| Full Baths | 2 |
| Status | Active |
| Directions | South off of West 24th Street. North of West 32nd Street. |
| City | Fremont |
| Body of Water | Clarks Lake |
| Senior Community Y/N | No |
| High School District | None |
| Zoning Description | Zoning |
| Lot Size Units | Acres |
| Lot Size Square Feet | 980100.0 |
| Carport Spaces | 0.0 |
| Carport Y/N | No |
| Land Lease Y/N | No |
| Tax Annual Amount | 9767.0 |
| Home Warranty Y/N | No |
| Lease Renewal Y/N | No |
| Lease Considered Y/N | No |
| Rent Control Y/N | No |
| Standard Status | Active |
| MobileHomeRemainsYN | No |
| Legal Description | N1/2 SW1/4 NW1/4 SEC 24,T13N R14W 20A M/L |
Interior Features
| Interior Amenities | Chandelier,Eat-in Kitchen,High Speed Internet,Kitchen Island,Laminate Counters,Sound System,Storage |
|---|---|
| Basement | Crawl Space |
| Flooring | Carpet,Concrete,Laminate,Vinyl,Wood |
| Basement (Y/N) | No |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Window Features | Double Pane Windows |
| Above Grade Finished Area | 1248.0 |
| Laundry Features | Main Level |
| Total Bedrooms | 3 |
| Below Grade Finished Area | 0.0 |
| Total Baths | 2 |
Exterior Features
| Exterior Amenities | Private Entrance,Private Yard,Rain Gutters,Storage |
|---|---|
| Fencing | Cross Fenced,Fenced,Wire,Wood |
| Parking Features | Additional Parking,Circular Driveway,Driveway,Gravel,Parking Lot |
| Lot Features | Agricultural,Back Yard,Farm,Few Trees,Front Yard,Private,Waterfront,Wooded |
| Water Source | Well |
| Lot Size Area | 22.5 |
| Spa | No |
| Building Area Total | 1248.0 |
| Lot Dimensions | Irregular |
| Lot Size Acres | 22.5 |
| Road Surface Type | Paved |
| Frontage Type | Lakefront |
| Waterfront Y/N | Yes |
| Foundation Area | 0.0 |
| Road Frontage Type | County Road |
| Other Equipment | Farm Equipment,Livestock Equipment |
| Crops Included Y/N | No |
| Horse Y/N | No |
| Irrigation Water Rights Y/N | No |
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 49412
Price
Taxes
Year Built
Visits
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
