$319,900
$20K PRICE DROP

5007 Sunset Blvd Madison, SD 57042

Estimated payment $2,246/month

Total Views 28,756
2 Beds
2 Baths
1,457 Sq Ft
$220 Price per Sq Ft

Highlights

  • Lake Front
  • Ranch Style House
  • Ground Level Unit
  • Deck
  • Wood Flooring
  • 1 Car Attached Garage

About This Home

Lake Madison here:) Take it easy and enjoy lake life in this 2 bedroom, 2 bath condo in the peaceful Sunset Harbor Addition on Lake Madison. You’ll love the open floor plan, bright paint, and updated granite countertops—but let’s be honest, it’s all about the view. Unwind in the sunroom or kick back on the water with your own boat slip, boat lift, and jet ski lift—all included. The oversized attached single garage is heated and features a clean epoxy floor—perfect for year-round use and extra storage. Maintenance-free living and incredible lake views? Yes, please.

Listing Agent

Travis Laqua

Hegg, REALTORS Listed on: 05/07/2025

Hegg, REALTORS

Co-Listing Agent

Mallory Kuiper

Hegg, REALTORS

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $1,973

Year Built

  • Built in 2008

Lot Details

  • Lake Front
  • Sprinkler System
  • Landscaped with Trees

HOA Fees

  • $330 Monthly HOA Fees

Parking

  • 1 Car Attached Garage
  • Heated Garage
  • Garage Door Opener

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Composition Shingle Roof

Interior Spaces

  • 1,457 Sq Ft Home
  • Tray Ceiling
  • Ceiling Fan

Kitchen

  • Electric Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 2 Main Level Bedrooms

Laundry

  • Laundry on main level
  • Dryer

Home Security

Schools

  • Madison Elementary School
  • Madison Middle School
  • Madison High School

Utilities

  • Central Heating and Cooling System
  • Rural Water
  • Electric Water Heater

Additional Features

  • Deck
  • Ground Level Unit

Listing and Financial Details

  • Assessor Parcel Number 066010010000107

Community Details

Overview

  • Sunset Harbor Subdivision
  • On-Site Maintenance

Recreation

  • Snow Removal

Security

  • Fire and Smoke Detector

Property Details

Home Type

Condominium

Est. Annual Taxes

$1,973

Year Built

Built in 2008

Lot Details

0

HOA Fees

$330 per month

Parking

1

Listing Details

  • Class: RESIDENTIAL
  • Style: Ranch
  • Property Sub Type: Condominium
  • Estimated Finished Sq Ft: 1457
  • Inside City Limits: Yes
  • Legal Description: Lots 1 & 2 Sunset Harbor Addn. Gov't Lot 5, 22-106-52
  • Streets: Asphalt, Private Maintenance
  • Year Built: 2008
  • Is Land Owned Or Leased: Owned
  • Suffix: Boulevard
  • Directions To Property: HWY 19 and Sunset Blvd - East on Sunset Blvd and follow road to home.
  • Elementary School: Madison ES
  • Geo Longitude: -97.06978
  • High School: Madison HS
  • Middle School: Madison MS
  • School District: Madison Central 39-2
  • Subdivision: Sunset Harbor
  • Special Features: None

Interior Features

  • Equipment: Electric Oven/Range, Microwave Oven, Dishwasher, Disposal, Refrigerator, Ceiling Fans, Washer, Dryer, Smoke Detector, Garage Door Opener
  • Floors: Carpet, Tile, Wood
  • Interior Amenities: Master Bed Main Level, Main Floor Laundry, Master Bath, Tray Ceiling
  • Number Of Bedrooms: 2
  • Master Bedroom: Dimensions: 13 x 11, On Level: Main, 3/4 Bath - Walk In closet - Dbl Vanity
  • Bedroom 2: Dimensions: 11 x 11, On Level: Main, Double Closet
  • Main Level Number Bedrooms: 2
  • Total Bathrooms: 2
  • Full Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Main Level Bath Descrip: Full and 3/4
  • Total Rooms: 8
  • Dining Room: Dimensions: 16 x 11, On Level: Main
  • Living Room: Dimensions: 15 x 14, On Level: Main
  • Room 1: Dimensions: 8 x 5, On Level: Main, Entry Way
  • Room 2: Dimensions: 9 x 6, On Level: Main, Laundry
  • Room 3: Dimensions: 13 x 9, On Level: Main, Sunroom
  • Kitchen: Dimensions: 13 x 9, On Level: Main, Large Island!
  • Above Grade Finished Sq Ft: 1457
  • Condominum Level: Upper
  • Main Level Estimated Finished Sq Ft: 1457
  • Price Per Sq Ft: 219.56

Exterior Features

  • Exterior: Part Brick
  • Foundation: Poured
  • Lake Description: Lake Front
  • Lake Name: Madison
  • Roof: Shingle Composition

Garage/Parking

  • Garage Type: Attached
  • Garage Amenities: Garage Heater, Oversized, Water Hook Ups
  • Garage Spaces: 1

Utilities

  • Cooling: One Central Air Unit
  • Heating: Central Natural Gas
  • Sewer: City Sewer
  • Water: Rural Water
  • Water Heater: Electric

Condo/Co-op/Association

  • HOA: Yes
  • Hoa Amenities: Exterior Bldng Maint, Garbage, Lawn Care, Road Maint, Snow Removal, Water/Sewer
  • Monthly HOA Fees: 330

Schools

  • School District: Madison Central 39-2
  • Elementary School: Madison ES
  • Middle School: Madison MS
  • High School: Madison HS

Lot Info

  • Acres: 0.1596
  • Geo Subdivision: SD
  • Lot Description: Irregular
  • Lot Dimensions: Irregular
  • Lot Size Sq Ft: 6950
  • Site Features: Shade Trees, Landscaping, Lawn Sprinkler Ungrd, Deck, Concrete Drive

Tax Info

  • Assessor Parcel Number: 066010010000107
  • Taxes: 1972.8
  • Taxes Reflect: Owner Occupied

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $1,973 $217,100 $0 $217,100
2023 $1,918 $206,800 $0 $206,800
2022 $1,680 $172,300 $0 $172,300
2021 $1,608 $127,600 $0 $127,600
2020 $1,588 $127,600 $0 $127,600
2019 $1,589 $127,600 $0 $127,600
2018 $2,014 $127,600 $0 $127,600
2017 $2,014 $127,600 $0 $127,600
2016 -- $127,600 $0 $127,600
2013 -- $106,800 $0 $106,800
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/25/2025 07/25/25 Price Changed $319,900 -5.9% $220 / Sq Ft
05/07/2025 05/07/25 For Sale $339,900 -- $233 / Sq Ft
Source: REALTOR® Association of the Sioux Empire

About the Listing Agent

Travis Laqua

Hegg, REALTORS

(605) 316-5936

Section Image

Travis believes real estate should be fun and stress-free. Buying or building a home is an exciting time, and home ownership is one of the biggest financial commitments you will make. Travis is committed to providing you with outstanding customer service and making your real estate experience as easy and hassle-free as possible.

Travis has over 14 years of experience in residential, new construction, multi-family, and light commercial real estate. He offers an aggressive marketing plan

Travis' Other Listings

  • 6008 Sunset Blvd, Madison, SD 57042

    $710,000

    • 4 Beds
    • 3.5 Baths
    • 2,910 Sq Ft
    • 6008 Sunset Blvd
    • Madison, SD

    Enjoy lake life just steps from the water in this beautifully maintained and extensively updated 4-bedroom, 4-bathroom walkout twin home. With breathtaking views of Lake Madison from nearly every room—and from two outdoor gathering spaces—this home is designed for relaxation, entertaining, and making memories in every season. The spacious and light-filled interior features 9-foot ceilings on all

    Travis Laqua Hegg, REALTORS

    Section Image
  • 6305 W Valentine St, Sioux Falls, SD 57107

    $469,900 New Construction

    • 5 Beds
    • 3 Baths
    • 2,579 Sq Ft
    • 6305 W Valentine St
    • Sioux Falls, SD

    The Primrose IV by Capstone Homes – A Fan Favorite for Good Reason! This stunning split-entry home from Capstone Homes offers a spacious open-concept layout with vaulted ceilings, granite countertops, and included kitchen appliances—perfect for both everyday living and entertaining. One of the standout features is the luxurious owner's suite, thoughtfully set apart from the other two main-level

    Travis Laqua Hegg, REALTORS

    Section Image
  • 6405 W Valentine St, Sioux Falls, SD 57107

    $394,900 Pending

    • 4 Beds
    • 2.5 Baths
    • 2,087 Sq Ft
    • 6405 W Valentine St
    • Sioux Falls, SD

    Introducing one of Capstone’s most popular Liberty Series floor plans, the Becker. Just the right size at 2087 square feet, the upper level of this floor plan has an owner’s suite, 3 additional bedrooms. The main floor features the kitchen as a focal point with an incredible island, stone countertops, a walk-in pantry, and brand-new kitchen appliances. Every Becker steps out to a large concrete

    Travis Laqua Hegg, REALTORS

    Section Image
  • 6301 W Valentine St, Sioux Falls, SD 57107

    $459,900 New Construction

    • 5 Beds
    • 3 Baths
    • 2,841 Sq Ft
    • 6301 W Valentine St
    • Sioux Falls, SD

    Spacious, Bright, and Designed for Living – Welcome to the Cheyenne by Capstone Homes. Step into a thoughtful design meets everyday functionality. A welcoming foyer with a walk-in closet sets the tone for this beautifully crafted split-level home. The main level features an open-concept layout with vaulted ceilings and oversized windows that flood the kitchen, dining, and great room with natural

    Travis Laqua Hegg, REALTORS

    Section Image
  • 6105 W Valentine St, Sioux Falls, SD 57107

    $459,900 Pending

    • 5 Beds
    • 3 Baths
    • 2,579 Sq Ft
    • 6105 W Valentine St
    • Sioux Falls, SD

    Welcome to Capstone's Primrose III floor plan. The Primrose III is a modified split level boasting a beautiful, vaulted ceiling and a spacious open concept main floor layout. The king-size master suite includes a little extra privacy, a master bathroom with a soaker tub, and a large walk-in closet. Two other bedrooms and a full bathroom complete the main level. The lower level offers an

    Travis Laqua Hegg, REALTORS

    Section Image
  • 6901 W Gresford Place, Sioux Falls, SD 57106

    $249,900 Pending

    • 2 Beds
    • 1.5 Baths
    • 1,312 Sq Ft
    • 6901 W Gresford Place
    • Sioux Falls, SD

    Sought-after end-unit townhome in the desirable Galway Village Development! This two-story Whitfield model offers 2 spacious bedrooms and 1.5 baths. The thoughtfully designed kitchen includes a pantry for added storage. Upstairs, you’ll find a versatile loft area, conveniently located laundry, and a full bathroom. The primary bedroom features a generous walk-in closet. Don’t miss this rare

    Travis Laqua Hegg, REALTORS

    Section Image
  • Unlisted Address

    $299,900 Open Sun 1:30PM - 2:30PM

    • 3 Beds
    • 3 Baths
    • 1,992 Sq Ft

    Tucked away in a tranquil, park-like setting, this stunning townhome offers the perfect blend of comfort, style, and functionality. Soaring ceilings and an abundance of natural light welcome you into the open-concept main level, creating a bright and airy atmosphere throughout. The kitchen is both beautiful and practical, featuring custom maple cabinetry and ceramic tile flooring. The spacious

    Travis Laqua Hegg, REALTORS

    Section Image
  • 2805 S Copper Creek Ave, Sioux Falls, SD 57110

    $489,900 New Construction

    • 5 Beds
    • 3 Baths
    • 2,578 Sq Ft
    • 2805 S Copper Creek Ave
    • Sioux Falls, SD

    Welcome to the Ashton Model by Capstone Homes – Smart, Stylish, and Surprisingly Spacious! This efficient and thoughtfully designed ranch-style home offers exceptional value without compromising on comfort. Step into the open-concept main level, where the great room flows effortlessly into a modern kitchen with updated appliances and a bright dining area—complete with a patio door ready for your

    Travis Laqua Hegg, REALTORS

    Section Image
  • 2905 S Copper Creek Ave, Sioux Falls, SD 57110

    $559,900 New Construction

    • 5 Beds
    • 3.5 Baths
    • 3,080 Sq Ft
    • 2905 S Copper Creek Ave
    • Sioux Falls, SD

    Welcome to Capstone's Waverly floor plan. This two-story home is 3,080 square feet. Featuring an open floor plan, the spacious Waverly kitchen features a kitchen island, walk in pantry and stone countertops. The dining room and great room flow seamlessly while the front flex room is perfect for a home office location. A half bathroom and a mudroom is conveniently located by the garage entry. The

    Travis Laqua Hegg, REALTORS

    Section Image

Source: REALTOR® Association of the Sioux Empire

MLS Number: 22503383

REALTOR® Association of the Sioux Empire

APN: 06601-00100-001-07