Welcome to easy living on Lake Madison! This 2-bedroom, 2-bath condo in the peaceful Sunset Harbor Addition offers an open floor plan, fresh paint, and updated granite countertops. Enjoy stunning lake views from the bright sunroom or head straight to the water with your own boat slip, boat lift, and jet ski lift—all included. The oversized heated garage with epoxy floor provides year-round convenience and extra storage. With maintenance-free living and unbeatable lake views, this condo is the perfect blend of comfort and relaxation.
For sale
$317,900
5007 Sunset Blvd, Madison, SD 57042
2beds
1,457sqft
Est.:
Condominium
Built in 2008
-- sqft lot
$-- Zestimate®
$218/sqft
$330/mo HOA
What's special
- 105 days |
- 190 |
- 4 |
Zillow last checked: 8 hours ago
Listing updated: August 27, 2025 at 12:03pm
Listed by:
Travis G LaQua,
Hegg, REALTORS,
Mallory S Kuiper,
Hegg, REALTORS
Source: Realtor Association of the Sioux Empire,MLS#: 22506611
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 1
- 3/4 bathrooms: 1
- Main level bedrooms: 2
Primary bedroom
- Description: 3/4 Bath - Walk In closet - Dbl Vanity
- Level: Main
- Area: 143
- Dimensions: 13 x 11
Bedroom 2
- Description: Double Closet
- Level: Main
- Area: 121
- Dimensions: 11 x 11
Dining room
- Level: Main
- Area: 176
- Dimensions: 16 x 11
Kitchen
- Description: Large Island!
- Level: Main
- Area: 117
- Dimensions: 13 x 9
Living room
- Level: Main
- Area: 210
- Dimensions: 15 x 14
Heating
- Natural Gas
Cooling
- Central Air
Appliances
- Included: Electric Range, Microwave, Dishwasher, Disposal, Refrigerator, Washer, Dryer
Features
- Master Downstairs, Tray Ceiling(s), Master Bath, Main Floor Laundry
- Flooring: Carpet, Tile, Wood
- Basement: None
Interior area
- Total interior livable area: 1,457 sqft
- Finished area above ground: 1,457
- Finished area below ground: 0
Property
Parking
- Total spaces: 1
- Parking features: Concrete
- Garage spaces: 1
Features
- Patio & porch: Deck
- On waterfront: Yes
- Waterfront features: Lake Front
- Body of water: Madison
Lot
- Size: 6,952.18 Square Feet
- Features: Irregular Lot
Details
- Parcel number: 066010010000107
Construction
Type & style
- Home type: Condo
- Architectural style: Ranch
- Property subtype: Condominium
Materials
- Brick
- Roof: Composition
Condition
- Year built: 2008
Utilities & green energy
- Sewer: Public Sewer
- Water: Rural Water
Community & HOA
Community
- Subdivision: Sunset Harbor
HOA
- Has HOA: Yes
- Amenities included: Trash, Snow Removal, Maintenance Grounds, Maintenance Structure, Road Maint, Water, Other
- HOA fee: $330 monthly
Location
- Region: Madison
Financial & listing details
- Price per square foot: $218/sqft
- Tax assessed value: $217,100
- Annual tax amount: $1,972
- Date on market: 8/27/2025
- Road surface type: Asphalt
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 8/27/2025 | Price change | $317,900-0.6%$218/sqft |
Source:  Realtor Association of the Sioux Empire #22506611 Report a problem | ||
| 7/25/2025 | Price change | $319,900-5.9%$220/sqft |
Source: Realtor Association of the Sioux Empire #22503383 Report a problem | ||
| 5/7/2025 | Listed for sale | $339,900+115.8%$233/sqft |
Source: Realtor Association of the Sioux Empire #22503383 Report a problem | ||
| 9/11/2015 | Sold | $157,500+6.6%$108/sqft |
Source: Realtor Association of the Sioux Empire #21413888 Report a problem | ||
| 8/13/2012 | Sold | $147,815$101/sqft |
Source: Realtor Association of the Sioux Empire #21200979 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $2,019 +2.3% | $217,100 +0.1% |
| 2024 | $1,973 +2.9% | $216,883 +4.9% |
| 2023 | $1,918 +14.2% | $206,800 +20% |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$2,279/mo
Principal & interest
$1555
HOA Fees
$330
Other costs
$395
Climate risks
Neighborhood: 57042
Nearby schools
GreatSchools rating
- 8/10Madison Elementary School - 07Grades: K-5Distance: 4.1 mi
- 6/10Madison Middle School - 02Grades: 6-8Distance: 3.5 mi
- 6/10Madison High School - 01Grades: 9-12Distance: 3.5 mi
Schools provided by the listing agent
- Elementary: Madison ES
- Middle: Madison MS
- High: Madison HS
- District: Madison Central 39-2
Source: Realtor Association of the Sioux Empire. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- Loading
- Loading
