$315,900

5007 Sunset Blvd Madison, SD 57042

Estimated payment $1,792/month

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

Highlights

  • Lake Front
  • Ranch Style House
  • Wood Flooring
  • Deck

About This Home

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.

Listing Agent

Travis Laqua

Hegg, REALTORS Brokerage Phone: 605-336-2100 Listed on: 02/24/2026

Hegg, REALTORS

Co-Listing Agent

Mallory Kuiper

Hegg, REALTORS Brokerage Phone: 605-336-2100

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $1,973

Year Built

  • Built in 2008

Parking

  • 1 Car Garage

Home Design

  • 1,457 Sq Ft Home
  • Ranch Style House
  • Brick Exterior Construction
  • Composition Roof

Kitchen

  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 2 Bedrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Schools

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

Additional Features

  • Deck
  • Lake Front
  • Heating System Uses Natural Gas

Community Details

Overview

  • Property has a Home Owners Association
  • Sunset Harbor Subdivision

Recreation

  • Snow Removal

Property Details

Home Type

Condominium

Est. Annual Taxes

$1,973

Year Built

Built in 2008

Lot Details

6,952 Sq Ft Lot

Parking

1

Listing Details

  • Property Sub Type: Condominium
  • Year Built: 2008
  • Elementary School: Madison ES
  • High School: Madison HS
  • Property Type: Residential
  • Lot Features: Irregular Lot
  • LotSizeAcres: 0.1596
  • Lot Size: Irregular
  • Road Surface Type: Asphalt
  • Water Body Name: Madison
  • Association Amenities: Maintenance Structure, Trash, Maintenance Grounds, Other, Road Maint, Snow Removal, Water
  • Association Fees: 330.0
  • Has HOA?: Yes
  • Co List Office Mls Id: 765530022
  • Co List Office Mls Id: 765530022
  • Subdivision Name: Sunset Harbor
  • Directions: HWY 19 and Sunset Blvd - East on Sunset Blvd and follow road to home.
  • Above Grade Finished Sq Ft: 1457.0
  • Architectural Style: Ranch
  • Living Area: 1457.0
  • Special Features: VirtualTour

Interior Features

  • Interior Amenities: Master Downstairs, Tray Ceiling(s), Master Bath, Main Floor Laundry
  • Appliances: Electric Range, Microwave, Dishwasher, Disposal, Refrigerator, Washer, Dryer
  • Basement: None
  • Full Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 2
  • Flooring: Carpet, Tile, Wood
  • Main Level Bedrooms: 2
  • Total Bedrooms: 8

Exterior Features

  • Roof: Composition
  • Waterfront Features: Lake Front
  • Construction Type: Brick
  • Foundation Details: Poured
  • Patio And Porch Features: Deck

Garage/Parking

  • Garage Spaces: 1.0
  • Parking Features: Concrete

Utilities

  • Cooling: Central Air
  • Heating: Natural Gas
  • Sewer: Public Sewer
  • Water Source: Rural Water

Schools

  • Junior High Dist: MadisonCen
  • Middle Or Junior School: Madison MS

Lot Info

  • Lot Size Sq Ft: 6950.0

Tax Info

  • Tax Annual Amount: 1972.8

Map

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

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
2025 $2,219 $217,100 $0 $217,100
2024 $2,219 $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 List to Sale Price per Sq Ft
02/24/2026 02/24/26 For Sale $315,900 -- $217 / Sq Ft
Source: REALTOR® Association of the Sioux Empire

About the Listing Agent

Travis Laqua

Hegg, REALTORS

(605) 777-7860

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

    $685,000

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

    Enjoy Lake Madison living in this beautifully updated 4-bedroom, 4-bath walkout twin home just steps from the water! Nearly every room offers stunning lake views, plus two outdoor spaces perfect for relaxing or entertaining. Inside, you’ll love the 9-foot ceilings, hardwood floors, hickory cabinets, and two fireplaces. Recent upgrades include granite countertops, a custom bar, refreshed primary

    Travis Laqua Hegg, REALTORS

    Section Image
  • 211 SE 4th St, Madison, SD 57042

    $650,000

    • Land
    • 1.78 Acres
    • $365,169 per Acre
    • 211 SE 4th St
    • Madison, SD

    Discover the opportunity to build in a great Madison location! This 1.78-acre residential-zoned lot offers ample space and endless possibilities. This property provides flexibility rarely found within city limits. Conveniently situated near local amenities, schools, and parks, it’s an ideal setting for those looking to create something truly their own. Bring your vision—this spacious lot is full

    Travis Laqua Hegg, REALTORS

    Section Image
  • 9238 W Norma Trail, Sioux Falls, SD 57106

    $279,900

    • 3 Beds
    • 2.5 Baths
    • 1,666 Sq Ft
    • 9238 W Norma Trail
    • Sioux Falls, SD

    Loft-style townhome featuring a desirable main-floor primary suite and an open, airy floor plan. This well-maintained home offers 3 bedrooms, 2.5 bathrooms, attached double garage with epoxy floors and water spigot, a spacious living room with vaulted ceilings, and a versatile loft ideal for a home office or flex space. The main level includes both the primary suite and convenient main-floor

    Travis Laqua Hegg, REALTORS

    Section Image
  • 1016 N Mable Cir, Sioux Falls, SD 57103

    $479,900

    • 5 Beds
    • 3 Baths
    • 2,075 Sq Ft
    • 1016 N Mable Cir
    • Sioux Falls, SD

    Well-maintained ranch walkout featuring 5 bedrooms, 3 bathrooms, and a 3-stall garage, plus a fully fenced yard. The primary suite offers a walk-in closet and private bath. The kitchen is equipped with custom maple cabinetry, granite countertops, a center island, a corner pantry, vinyl plank flooring, and stainless steel appliances. The dining area opens to a 10×12 covered deck, perfect for

    Travis Laqua Hegg, REALTORS

    Section Image
  • 2545 E Meadowside Place, Sioux Falls, SD 57108

    $199,900 Pending

    • 1 Bed
    • 1 Bath
    • 912 Sq Ft
    • 2545 E Meadowside Place
    • Sioux Falls, SD

    This 1-bedroom, 1-bathroom home offers efficient and comfortable living in a highly desirable location. The kitchen is thoughtfully designed with a center island, pantry, and sleek black appliances. The spacious bedroom features a large walk-in closet with convenient access to the full bath. Enjoy being close to walking paths, shopping, dining, and all the action!

    Travis Laqua Hegg, REALTORS

    Section Image
  • 1006 Birch St, Harrisburg, SD 57032

    $465,000

    • 4 Beds
    • 3 Baths
    • 2,351 Sq Ft
    • 1006 Birch St
    • Harrisburg, SD

    South-Facing Ranch by Northstar Builders!2,351 finished sq ft featuring 4 bedrooms + 5th non-legal bedroom, 3 bathrooms, and a 3-stall garage. Full landscaping included—sod, sprinklers, and rock.The main level offers vaulted ceilings, a tray ceiling in the primary suite, main-floor laundry, and a beautifully finished kitchen with custom cabinetry, breakfast island, and stainless steel

    Travis Laqua Hegg, REALTORS

    Section Image
  • 1014 Birch St, Harrisburg, SD 57032

    $469,900

    • 5 Beds
    • 3 Baths
    • 2,330 Sq Ft
    • 1014 Birch St
    • Harrisburg, SD

    South-facing ranch home built by NorthStar Builders with 2,330 finished sq ft. This thoughtfully designed home offers 5 bedrooms, 3 bathrooms, two spacious living areas, and an oversized 3-stall garage. The main level features 1,247 sq ft with 2 bedrooms, 2 bathrooms, main floor laundry, vaulted ceilings, solid panel doors, tile walk-in shower, double sinks in the primary suite, a walk-in closet,

    Travis Laqua Hegg, REALTORS

    Section Image
  • 1008 Birch St, Harrisburg, SD 57032

    $465,000

    • 4 Beds
    • 3 Baths
    • 2,351 Sq Ft
    • 1008 Birch St
    • Harrisburg, SD

    South-Facing Ranch Home by Northstar Builders! Enjoy this thoughtfully designed 2,351 sq ft ranch home. This home features 4 bedrooms, a 5th non-legal bedroom, 3 bathrooms, a spacious 3-stall garage, and full landscaping (sod, sprinkler and landscape rock). The main level offers 1,282 sq ft of finished space, including 2 bedrooms, 2 bathrooms, main floor laundry, vaulted ceilings, solid panel

    Travis Laqua Hegg, REALTORS

    Section Image
  • 28174 441st Ave, Freeman, SD 57029

    $429,900

    • 4 Beds
    • 1.5 Baths
    • 1,512 Sq Ft
    • 28174 441st Ave
    • Freeman, SD

    Charming Farmhouse on 8.4 Acres Near Freeman!This classic farmhouse features 4 bedrooms, 1.5 baths, and a 2-stall detached garage, offering the space and freedom of country living. Outbuildings include a 24×48 shop with covered lean-to for additional storage and a 32×50 barn in solid condition. The main floor offers a bright living room, dining area, kitchen, and a convenient half-bath off

    Travis Laqua Hegg, REALTORS

    Section Image

Source: REALTOR® Association of the Sioux Empire

MLS Number: 22601222

REALTOR® Association of the Sioux Empire

APN: 06601-00100-001-07

Your Personal Tour Guide

Ask me questions while you tour the home.