Experience luxury lakefront living in this expansive and beautiful 7-bedroom, 5-bathroom home. The home comes with a heated 3 car garage attached to the house. A second 2 car garage is accessed via a lovely breezeway. The 2-car garage is also heated and includes an impressive workshop and expansive attic storage, all set on 75 feet of the serene shores of Big Spirit Lake. The heart of the home is a chef’s dream kitchen, with elegant Caesarstone quartz countertops and a striking marble mosaic tile backsplash, featuring a new gas cooktop, double wall ovens, refrigerator and dishwasher. The newly refinished cherry hardwood floors flow seamlessly through the kitchen, dining area & living room, complimented by a newly added cherry hardwood floor entryway. Enjoy cozy evenings by the gas fireplace in the lakeside sunroom while watching rain dance across the lake, or gather in the elegant living room or expansive lower level family room, both offering stunning lake views and their own gas fireplace. Catch a sunrise, a day in the sun or a beautiful evening lounging on the boat house patio, which also gives you extra storage for your dock. Entertain your family and guests in the game room while playing pool, shuffle board or just enjoying a glass of wine at the bar. Whether you’re hosting a crowd or seeking peaceful solitude, this extraordinary property delivers it all in one of the area’s most tranquil and coveted lakefront settings! The dock stays with the property. New buyer will need to apply for dock permit (non handicapped) on 1/1/2026 that will comply with DNR regulations. City water will be changed to Iowa Lakes Regional Rural Water in the near future. Furniture and hoists may be purchased outside the sale of the home.
For sale
$2,125,000
13510 240th Ave, Orleans, IA 51360
7beds
5,538sqft
Est.:
Single Family Residence
Built in 2004
0.42 Acres Lot
$-- Zestimate®
$384/sqft
$-- HOA
What's special
Gas fireplaceBoat house patioLakeside sunroomLower level family roomCherry hardwood floorsImpressive workshopDouble wall ovens
- 61 days
- on Zillow |
- 858 |
- 27 |
Zillow last checked: 7 hours ago
Listing updated: July 23, 2025 at 07:48am
Listed by:
Judy Salzwedel PRIM:712-336-3405,
EXIT Realty Midwest
Source: Iowa Great Lakes BOR,MLS#: 250707

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 7
- Bathrooms: 5
- Full bathrooms: 2
- 3/4 bathrooms: 2
- 1/2 bathrooms: 1
Bathroom
- Features: 3/4 Basement, Main Floor 1/2 Bath, Private Master, Upper Level Bath, Whirlpool
Dining room
- Features: Breakfast Bar, Combine Living Room, Combine with Kitchen, Open Floorplan
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Cooktop, Dishwasher, Disposal, Dryer, Exhaust Fan, Microwave, Refrigerator, Oven, Washer, ENERGY STAR Qualified Washer, Humidifier, Water Filtration Sys, Gas Water Heater, Water Osmosis System, Water Softener Owned
- Laundry: Main Level, Washer/Dryer Hkups
Features
- Ceiling Fan(s), Drinking Water System, Wired for Data, Kitchen Island, Main Floor Bedrooms, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar
- Flooring: Hardwood, Tile
- Windows: Window Coverings
- Basement: Daylight,Egress Windows,Finished,Sump Pump,Walk-Out Access,Concrete,Full,Walkout
- Attic: Walk-up
- Has fireplace: Yes
- Fireplace features: Gas
Interior area
- Total structure area: 5,838
- Total interior livable area: 5,538 sqft
- Finished area above ground: 3,781
- Finished area below ground: 1,757
Property
Parking
- Total spaces: 5
- Parking features: Concrete, Shared Driveway, Attached, Garage Door Opener
- Attached garage spaces: 5
- Has uncovered spaces: Yes
Features
- Levels: Three Or More,Two
- Stories: 2
- Patio & porch: Patio
- Exterior features: Dock, In-Grnd Sprklr Sys
- Has spa: Yes
- Spa features: Bath
- Has view: Yes
- View description: Lake
- Has water view: Yes
- Water view: Lake
- Waterfront features: Waterfront, Lake
- Body of water: Big Spirit Lake
- Frontage length: Waterfront Frontage: 75
Lot
- Size: 0.42 Acres
- Dimensions: 75F x 247S x 74R x 247S
- Features: Accessible Shoreline, Landscaped, Paved, Wooded
Details
- Additional structures: Boat House, Storage, Workshop
- Parcel number: 003 03 29 427 001
- Other equipment: Air to Air Exchange, Sump Pump
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Other
- Property subtype: Single Family Residence
- Attached to another structure: Yes
Materials
- Cement Siding, Poured Concrete, Stick Built
- Roof: Asphalt
Condition
- Updated/Remodeled
- New construction: No
- Year built: 2004
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Public Sewer
- Water: Public, Rural/Municipality
- Utilities for property: Underground Utilities, Natural Gas Connected, Cable Connected
Community & HOA
Community
- Security: Smoke Detector(s)
Location
- Region: Orleans
Financial & listing details
- Price per square foot: $384/sqft
- Tax assessed value: $1,484,700
- Annual tax amount: $13,000
- Date on market: 6/9/2025
- Listing terms: Cash,Conventional
- Road surface type: Paved
- Loading
- Loading