Seller's Agent in 2025
TJ Barthman
Hegg, REALTORS
(605) 351-4950
9 in this area
112 Total Sales
404 N Piper Dr Sioux Falls, SD 57110
Northeast Sioux Falls NeighborhoodEstimated Value: $874,940 - $948,000
5
Beds
3.5
Baths
3,600
Sq Ft
$251/Sq Ft
Est. Value
Highlights
- Heated Floors
- Family Room with Fireplace
- Porch
- Fred Assam Elementary School Rated A
- Ranch Style House
- 3 Car Attached Garage
About This Home
As of May 2025Stunning 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!
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $10,812
Year Built
- Built in 2023
Lot Details
- 13,603 Sq Ft Lot
- Landscaped
- Sprinkler System
Parking
- 3 Car Attached Garage
- Garage Door Opener
Home Design
- Ranch Style House
- Brick Exterior Construction
- Composition Shingle Roof
- Hardboard
Interior Spaces
- 3,600 Sq Ft Home
- Wet Bar
- Ceiling Fan
- Gas Fireplace
- Family Room with Fireplace
- 2 Fireplaces
- Fire and Smoke Detector
Kitchen
- Gas Oven or Range
- Microwave
- Dishwasher
- Disposal
Flooring
- Wood
- Carpet
- Heated Floors
- Tile
Bedrooms and Bathrooms
- 5 Bedrooms | 3 Main Level Bedrooms
Laundry
- Laundry on main level
- Dryer
Basement
- Basement Fills Entire Space Under The House
- Fireplace in Basement
- Bedroom in Basement
Outdoor Features
- Covered Deck
- Fireplace in Patio
- Porch
Schools
- Fred Assam Elementary School
- Brandon Valley Middle School
- Brandon Valley High School
Utilities
- 90% Forced Air Heating and Cooling System
- Electric Water Heater
- Cable TV Available
Community Details
- Mystic Heights At Foss Fields Addition Subdivision
Listing and Financial Details
- Assessor Parcel Number 94591
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 10, 2025
Closed on
May 21, 2025
Sold by
Seller's Agent
TJ Barthman
Hegg, REALTORS
Buyer's Agent
Dick Hahn
RE/MAX Professionals Inc
List Price
$889,000
Sold Price
$885,000
Premium/Discount to List
-$4,000
-0.45%
Views
48
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$17,485
Avg. Annual Appreciation
1.78%
Purchase Details
Closed on
Oct 30, 2023
Sold by
Bought by
Purchase Details
Closed on
Jun 14, 2023
Sold by
Bought by
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
Average Home Value in this Area
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $885,000 | -- | ||
| -- | -- | ||
| $840,000 | -- | ||
| $840,000 | -- |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 05/21/2025 05/21/25 | Sold | $885,000 | -0.4% | $246 / Sq Ft |
| 04/29/2025 04/29/25 | Pending | -- | -- | -- |
| 04/24/2025 04/24/25 | For Sale | $889,000 | 0.0% | $247 / Sq Ft |
| 04/13/2025 04/13/25 | Pending | -- | -- | -- |
| 04/10/2025 04/10/25 | For Sale | $889,000 | -- | $247 / Sq Ft |
Source: REALTOR® Association of the Sioux Empire
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 | $10,272 | $769,400 | $95,900 | $673,500 |
| 2024 | $10,272 | $806,200 | $95,900 | $710,300 |
| 2023 | $4,707 | $267,700 | $79,500 | $188,200 |
| 2022 | $1,513 | $79,500 | $79,500 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
TJ Barthman
-
Lee Schelling
Seller Co-Listing Agent in 2025
Lee Schelling
Hegg, REALTORS
(605) 254-3632
9 in this area
94 Total Sales
-
Dick Hahn
Buyer's Agent in 2025
Dick Hahn
RE/MAX
(605) 940-5100
7 in this area
80 Total Sales
Map
Source: REALTOR® Association of the Sioux Empire
MLS Number: 22502550
APN: 94591
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of the REALTOR® Association of the Sioux Empire, Inc., Multiple Listing Service. Real estate listings held by brokerage firms other than Ten-X are marked with the Internet Data Exchange™ logo or the Internet Data Exchange thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers.
Information is deemed reliable but not guaranteed.
Copyright 2026 REALTOR® Association of the Sioux Empire, Inc., Inc. Multiple Listing Service. All rights reserved.
Nearby Homes
- 500 N Corsair Cir
- 6708 E Cir
- 6704 E Spitfire Cir
- 207 N Pine Lake Dr
- 501 N Corsair Cir
- 204 N Piper Dr
- 6701 E Spitfire Cir
- 112 N Piper Dr
- 501 N Wildcat Dr
- 6605 E Hawker Cir
- 205 N Wildcat Dr
- 105 N Tumble Creek Cir
- 7301 E Palomino Rd
- 205 N Autumnwood Ct
- 300 S Tumble Creek Ave
- 316 S Willow Spring Dr
- 325 S Willow Spring Dr
- 333 S Willow Spring Dr
- 7329 E Twin Pines Ct
- 7413 E Twin Pines Ct
- 400 N Piper Dr
- 6716 N Roddel Cir
- 6716 E Roddel Cir
- 412 N Piper Dr
- 308 N Piper Dr
- 6800 E Pine Lake Dr
- 6709 E Corsair Dr
- 6712 E Roddel Cir
- 501 N Piper Cir
- 6713 E Roddel Cir
- 0 E Roddel Circle Cir E Unit 22400747
- 6900 E Pine Lake Dr
- 300 N Piper Dr
- 6701 E Corsair Dr
- 6709 E Roddel Cir
- 305 E Pine Lake Dr
- 6700 E Corsair Dr
- 404 E Pine Lake Dr
- 505 N Piper Cir
- 305 N Pine Lake Dr
Your Personal Tour Guide
Ask me questions while you tour the home.