COMING SOON 10/17/26 on one of Big Green Lake’s most prestigious shores! This exceptional Sandstone property offers the combination lake buyers dream about: 1.7 acres, 100+ feet of flat, level frontage and beautiful swimming water. The 5-bedroom, 3-bath home provides plenty of space for family, friends and unforgettable lake weekends. An attached 2-car garage plus an incredible detached 3+ car garage means room for boats, lake toys, golf carts and all the extras that come with Green Lake living. With gorgeous frontage, generous acreage, wonderful privacy and a premier location, this is a truly special opportunity on Big Green Lake. More details and photos coming soon!
Coming soon
$2,899,000
W1510 Sandstone Ave, Ripon, WI 54971
5beds
3,060sqft
Single Family Residence
Built in 1987
1.7 Acres Lot
$1,752,300 Zestimate®
$947/sqft
$-- HOA
What's special
- --
- on Zillow
- 888
- views
- 40
- saves
Zillow last checked:
Listing updated:
Listed by:
Sarah Loberg,
Better Homes and Gardens Real Estate Special Properties,
Jeffrey Shadick,
Better Homes and Gardens Real Estate Special Properties
Source: SCWMLS,MLS#: 2031961
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 3
- Main level bathrooms: 1
Primary bedroom
- Level: Upper
- Area: 252
- Dimensions: 18 x 14
Bedroom 2
- Level: Upper
- Area: 345
- Dimensions: 23 x 15
Bedroom 3
- Level: Main
- Area: 224
- Dimensions: 16 x 14
Bedroom 4
- Level: Lower
- Area: 195
- Dimensions: 13 x 15
Bedroom 5
- Level: Lower
- Area: 195
- Dimensions: 13 x 15
Dining room
- Level: Main
- Area: 168
- Dimensions: 12 x 14
Family room
- Area: 459
- Dimensions: 27 x 17
Kitchen
- Features: Breakfast Bar, Pantry, Kitchen Island, Range/Oven, Refrigerator, Dishwasher, Microwave, Disposal
- Level: Main
- Area: 168
- Dimensions: 14 x 12
Living room
- Level: Main
- Area: 364
- Dimensions: 14 x 26
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Washer, Dryer
- Laundry: Lower Level
Features
- Great room, Vaulted Ceiling(s), Jetted bathtub, At Least 1 tub, Walk thru bedroom, Beamed Ceilings, Ceiling Fan(s), Entrance Foyer, Primary Bath, Loft, Den/Office, Foyer
- Windows: Window Coverings
- Basement: Full,Full Size Windows/Exposed,Walk-Out Access,Finished,Storage Space
- Number of fireplaces: 1
- Fireplace features: Wood Burning, Free Standing, 1 fireplace
Interior area
- Total structure area: 3,060
- Total interior livable area: 3,060 sqft
- Finished area above ground: 2,060
Property
Parking
- Total spaces: 4
- Parking features: Attached, Detached, Heated Garage, Garage Door Opener, 4+ car, Additional Garage, Keyless Entry, Workshop in Garage
- Has attached garage: Yes
- Has uncovered spaces: Yes
Features
- Levels: One and One Half
- Stories: 1.5
- Patio & porch: Deck, Patio, Front Porch, Porch
- On waterfront: Yes
- Waterfront features: Waterfront, Lake Front, Dock/Pier, Water ski lake
- Body of water: Big Green
- Frontage length: Waterfront: 100
Lot
- Size: 1.7 Acres
- Dimensions: 100X774X115X720
- Features: Subject Shoreland Zoning
- Residential vegetation: Wooded
Details
- Additional structures: Storage
- Parcel number: 006015950000
- Zoning: r1 shore
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Other
- Property subtype: Single Family Residence
Materials
- Wood Siding
- Foundation: Poured concrete foundatn
Condition
- Year built: 1987
Utilities & green energy
- Sewer: Non-Municipal/Prvt dispos
- Water: Well
- Utilities for property: Cable Available
Community & HOA
Community
- Security: Smoke Detector(s)
Location
- Region: Ripon
Financial & listing details
- Price per square foot: $947/sqft
- Tax assessed value: $1,936,400
- Annual tax amount: $16,721
- Date on market: 9/3/2026
- Inclusions: range, microwave, dishwasher, 2 refrigerators, washer and dryer,
- Exclusions: Sellers personal property
Estimated market value
$1,752,300
$1.49M - $2.09M
$2,679/mo
Price history
Price history is unavailable.
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $13,793 +3.7% | $749,600 |
| 2023 | $13,296 +6.4% | $749,600 |
| 2022 | $12,502 +16.7% | $749,600 |
| 2021 | $10,710 +6.7% | $749,600 |
| 2020 | $10,041 -1.8% | $749,600 |
| 2019 | $10,230 +8.8% | $749,600 |
| 2017 | $9,400 -5.4% | $749,600 |
| 2016 | $9,940 -13% | $749,600 |
| 2015 | $11,427 +17.7% | $749,600 |
| 2014 | $9,710 +0.7% | $749,600 |
| 2013 | $9,647 -23.1% | $749,600 -9.9% |
| 2012 | $12,553 -14.9% | $832,300 -52.4% |
| 2010 | $14,746 | $1,749,800 +100% |
| 2009 | -- | $874,900 |
| 2008 | -- | $874,900 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 54971
Nearby schools
Schools provided by the listing agent
- Elementary: Green Lake
- Middle: Green Lake
- High: Green Lake
- District: Green Lake
Source: SCWMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.





