Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1999 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1999 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1999 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

3501 Sandpiper Trail
Mandan, ND 58544
SHARI ANHORN with KW Inspire Realty, original listing - (701) 838-6800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $479,900
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 1422 Square Feet
Agency: KW Inspire Realty
Agency Phone: (701) 838-6800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Welcome home to 3501 Sandpiper Trail SE! This 5 bedroom, 3 bath showstopper is tucked away and centrally located in the Lakewood development in SE Mandan. Upon arrival you'll immediately notice the curb appeal with green siding accented by cultured stone and covered entry with maintenance-free steps and soffit lights. This home sits on a 90x125 corner lot on the perimeter of Borden Harbor Park [which features playset, basketball court, skating rink & covered picnic areas]! Shingles, gutters, gutter shields and downspouts new in 2024. Landscaping wraps the exterior of the home with perennials, rocks, boulders and a sprinkler system. Inside, you'll be warmly welcomed with a smartly designed floorplan geared for entertaining and everyday living. The kitchen has vinyl plank flooring, is lined with custom oak cabinetry and offers sleek countertops, updated sink/faucet, island, pantry and four-piece black stainless steel appliance ensemble. Savor your meals inside or head out to the oversized maintenance-free deck for outdoor dining or to sip your beverage of choice and enjoy the sunset from the hot tub. Inside, natural light is abundant with windows a plenty and don't worry as custom blinds throughout provide shade control. The living room has plush carpeting with picture window. Take note of the neutral finishes, modern millwork and updated fixtures throughout. The primary suite has carpeting, ceiling fan, walk-in closet and private en suite featuring dual sinks and window. Continuing on you’ll find bedrooms 2 & 3 with carpeting and convenient access to a full bath. Rounding out the main level is a laundry room with utility sink, cabinetry and in-hall storage closets. The daylight basement is fully finished with a HUGE family room featuring recessed lighting – PLENTY of space to situate furnishings to your liking. Bedrooms 4 & 5 are both good sized and there's a third bathroom space with linen closet. Storage space galore with mechanical room and under foyer space – stow ALL the clutter! The attached garage is impressively fully finished with epoxied floor, floor drain, gas heater, ceiling fan, h/c water, utility sink, extra lighting, storage closets and two convenient walk-through doors. Need space for a boat, camper? Don’t forget about the extra parking pad! The backyard is vinyl privacy fenced with mature trees, shed, hot tub, apple tree & plum tree. Convenient location with quick access to boat ramps, restaurants, Family Wellness Center, Raging Rivers Waterpark, Lakewood Elementary School, walking paths and major thoroughfares. If you're looking for a NEXT-to-NEW & move-in ready home, this is your turn-key ticket – check it out today!
MlsNumber: --
ListingId: 250167


Listing Provided By: KW Inspire Realty, original listing
Phone: (701) 720-8697
Office Phone: (701) 838-6800
Agent Name: SHARI ANHORN
Disclaimer: Copyright © 2025 Minot Board of REALTORS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1999 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App