Skip main navigation
Sold for $885,000
  • $885,000

    404 N Piper Dr, Sioux Falls, SD 57110

    5beds
    3,600sqft
    Single Family Residence
    Built in 2023
    0.31 Acres Lot
    $893,100 Zestimate®
    $246/sqft
    $3,978 Estimated rent

    Home value

    $893,100

    $831,000 - $956,000

    $3,978/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,978/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,978/mo

    Rent Zestimate®

    Refinance and save

    $4,590/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $4,590/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Cozy fireplaceWalk-in pantrySpacious family roomWet barWalk-in tile showerOver the top finishesFinished basement
    Stunning 5-Bedroom Luxury Home with No Immediate Backyard Neighbors! Welcome to this beautiful 2023-built home offering over-the-top comfort, space, and style! Featuring 5 spacious bedrooms, 3.5 bathrooms, and a heated finished 3-stall garage, this home has everything your family needs and more. Step inside to an open-concept main level that’s perfect for entertaining. The kitchen is a showstopper with a massive island, walk-in pantry, and over the top finishes. The living room boasts large windows that flood the space with natural light and a cozy fireplace for those relaxing evenings. Enjoy the convenience of main floor laundry/mudroom, 3 bedrooms on the main level, including a luxurious primary suite. The primary en-suite offers a walk-in closet, dual vanities, a walk-in tile shower, and a relaxing soaker tub. Head downstairs to a finished basement where entertaining shines. You’ll find a spacious family room w/fireplace, wet bar, and 2 additional bedrooms and a recreation room perfect for an exercise room, toy room, or a home office setup. All of this, plus no immediate backyard neighbors, giving you added privacy and serenity in your outdoor space to enjoy the screened in porch w/fireplace or the great grilling and entertaining deck with pergola. Don’t miss your chance to own this exceptional home!

    Zillow last checked:

    Listing updated:

    Listed by:

    TJ Barthman,

    Hegg, REALTORS,

    Lee A Schelling,

    Hegg, REALTORS

    Bought with:

    Dick H Hahn

    Source: Realtor Association of the Sioux Empire,MLS#: 22502550MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    • Main level bedrooms: 3
    Primary bedroom
    • Description: Walk in closet w/ full bath
    • Level: Main
    • Area: 195
    • Dimensions: 13 x 15
    Bedroom 2
    • Level: Main
    • Area: 132
    • Dimensions: 11 x 12
    Bedroom 3
    • Level: Main
    • Area: 132
    • Dimensions: 11 x 12
    Bedroom 4
    • Level: Basement
    • Area: 150
    • Dimensions: 10 x 15
    Bedroom 5
    • Level: Basement
    • Area: 169
    • Dimensions: 13 x 13
    Dining room
    • Description: Sliding door to screened in deck w/FP
    • Level: Main
    • Area: 156
    • Dimensions: 12 x 13
    Family room
    • Description: Wet Bar, fireplace
    • Level: Basement
    • Area: 345
    • Dimensions: 15 x 23
    Kitchen
    • Description: Large Island, walk in pantry
    • Level: Main
    • Area: 187
    • Dimensions: 11 x 17
    Living room
    • Description: Open concept w/ fireplace
    • Level: Main
    • Area: 304
    • Dimensions: 16 x 19
    Heating
    • 90% Efficient, Natural Gas
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Disposal, Dryer, Range, Microwave, Refrigerator, Washer
    Features
    • 3+ Bedrooms Same Level, Master Downstairs, Main Floor Laundry, Master Bath, Wet Bar
    • Flooring: Carpet, Heated, Tile, Wood
    • Basement: Full
    • Number of fireplaces: 2
    • Fireplace features: Gas
    Interior area
    • Total interior livable area: 3,600 sqft
    • Finished area above ground: 2,030
    • Finished area below ground: 1,570

    Property

    Parking
    • Total spaces: 3
    • Parking features: Concrete
    • Garage spaces: 3
    Features
    • Patio & porch: Porch
    Lot
    • Size: 0.31 Acres
    • Features: Walk-Out
    Details
    • Parcel number: 94591

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Ranch
    • Property subtype: Single Family Residence
    Materials
    • Hard Board, Brick, Wood Siding
    • Roof: Composition
    Condition
    • Year built: 2023

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public

    Community & HOA

    Community
    • Subdivision: Mystic Heights at Foss Fields Addition
    HOA
    • Has HOA: No
    Location
    • Region: Sioux Falls

    Financial & listing details

    • Price per square foot: $246/sqft
    • Tax assessed value: $769,400
    • Annual tax amount: $10,811
    • Date on market: 7/23/2025
    • Listing terms: Cash
    • Road surface type: Curb and Gutter

    Price history

    DateEventPrice
    5/21/2025Sold$885,000-0.4%$246/sqft
    Source: Realtor Association of the Sioux Empire #22502550 Report a problem
    4/24/2025Listed for sale$889,000$247/sqft
    Source: Realtor Association of the Sioux Empire #22502550 Report a problem
    4/14/2025Listing removed$889,000$247/sqft
    Source: Realtor Association of the Sioux Empire #22502550 Report a problem
    4/10/2025Listed for sale$889,000+5.8%$247/sqft
    Source: Realtor Association of the Sioux Empire #22502550 Report a problem
    6/22/2023Sold$840,000-15.6%$233/sqft
    Source: Public Record Report a problem
    6/8/2022Sold$995,000$276/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$10,055 -5.1%$769,400 -4.6%
    2024$10,600 +125.2%$806,200 +201.2%
    2023$4,707 +211.1%$267,700 +236.7%
    2022$1,513 $79,500
    2021-- --
    Find assessor info on the county website

    Neighborhood: 57110

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Fred Assam ES
    • Middle: Brandon Valley MS
    • High: Brandon Valley HS
    • District: Brandon Valley 49-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.

    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.