$317,900

5007 Sunset Blvd Madison, SD 57042

Estimated payment $2,145/month

Total Views 44,421
2 Beds
2 Baths
1,457 Sq Ft
$218 Price per Sq Ft

Highlights

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

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 Listed on: 08/27/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, Tray Ceiling, Master Bath, Main Floor Laundry
  • 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
  • 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
  • Price Per Sq Ft: 218.19

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: Garbage, Snow Removal, Lawn Care, Exterior Bldng Maint, Road Maint, Water/Sewer
  • Monthly HOA Fees: 330

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

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
08/27/2025 08/27/25 For Sale $317,900 -- $218 / Sq Ft
Source: REALTOR® Association of the Sioux Empire

About the Listing Agent

Travis Laqua

Hegg, REALTORS

(605) 307-3870

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

    $289,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 Open Sat 3PM - 4PM

    • 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
  • 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

    $460,000 Open Sun 12PM - 1PM

    • 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
  • 6013 Sunset Blvd, Madison, SD 57042

    $600,000 Sold Jul 25, 2025

    • 4 Beds
    • 3.5 Baths
    • 2,560 Sq Ft
    • 6013 Sunset Blvd
    • Madison, SD

    Experience the best of lake living in this stunning 4-bedroom, 4-bath twin home located in the highly sought-after Sunset Harbor community on Lake Madison. This bright and airy two-story walkout is designed to impress with its modern finishes, open-concept layout, and expansive windows that capture breathtaking lake views. The gourmet kitchen features stainless steel appliances, a blend of

    Travis Laqua Hegg, REALTORS

Source: REALTOR® Association of the Sioux Empire

MLS Number: 22506611

REALTOR® Association of the Sioux Empire

APN: 06601-00100-001-07