Skip main navigation
Sold
  • Price Unknown

    3801 Bay Shore Bnd SE, Mandan, ND 58554

    5beds
    7,505sqft
    Single Family Residence
    Built in 2013
    0.55 Acres Lot
    $1,801,700 Zestimate®
    $--/sqft
    $4,582 Estimated rent

    Home value

    $1,801,700

    $1.64M - $2.00M

    $4,582/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,582/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

    $4,582/mo

    Rent Zestimate®

    Refinance and save

    $850/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

    $850/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

    Great roomFunctional in-law suiteFormal dining roomWalk-in pantryHalf bathroomCustom steam showerGranite countertops
    Presenting an extraordinary waterfront residence that epitomizes unparalleled luxury and craftsmanship. Prepare to be captivated from the moment you arrive, as the striking globular front turrets and majestic 22' stone encased pillars flank the entrance, leading you to the grandeur of an 8' tall solid Birch front door. This one-of-a-kind property rests on a half-acre lot, offering an abundance of space and privacy. Indulge in over 7,500 square feet of meticulously designed living space, encompassing five bedrooms and five bathrooms. Step into the awe-inspiring 22 ft Foyer, where inspiration and elegance seamlessly merge. The main floor welcomes you with a great room, a thoughtfully appointed half bathroom, and a formal dining room comfortably accommodating up to 10 guests. Experience the meticulous details throughout, including hand-applied Santa Fe wall texture, a stunning stone feature wall, and exquisite wood ceiling inlays. Every chef's dream, the kitchen leaves no desire unfulfilled. Discover granite countertops, a spacious prep island, dual wall ovens, dual dishwashers, and a 48' gas cooktop. The walk-in pantry provides ample storage, while the outdoor/indoor kitchen boasts a built-in grill and beverage cooler, perfect for entertaining friends and family. The primary suite is a haven of luxury, boasting a well-thought-out layout and breathtaking views. Enjoy the warmth of a fireplace, his and her closets, and an exquisite primary bath. This spa-like oasis features 20ft ceilings, in-floor heating, a therapeutic whirlpool tub, a custom steam shower, makeup vanity, and dual vanity with bespoke cabinetry. As you gaze into the mirrored surfaces, a hidden TV adds a touch of modern convenience. Ascending upstairs, you'll discover two guest suites, one of which features a private balcony, and a magnificent home theater. The lower level presents a wealth of entertainment options, including a wine cellar adorned with faux cave rock, a welcoming bar, a home gym, two home offices, and a functional in-law suite with a separate living area and an elevator connecting it to the main level. The backyard is for outdoor enthusiasts and entertainment lovers alike. Revel in the dream-like setting, complete with an outdoor/indoor kitchen, a spacious covered patio, a cozy hot tub alcove, 155ft of sandy beach, and a private dock. This remarkable residence encompasses numerous additional features and amenities that truly set it apart. Don't miss the opportunity to experience the epitome of waterfront luxury living. Contact your favorite realtor today to arrange a private showing of this exceptional property.

    Zillow last checked:

    Listing updated:

    Listed by:

    Frankie Sue Pierson,

    Luxxe Realty

    Bought with:

    Frankie Sue Pierson, 9562

    Luxxe Realty

    Source: Great North MLS,MLS#: 4007711

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 5
    • Full bathrooms: 3
    • 3/4 bathrooms: 1
    • 1/2 bathrooms: 1
    Primary bedroom
    • Features: His and Hers Closets
    • Level: Main
    Bedroom 2
    • Description: Guest Suite with Balcony
    • Level: Upper
    Bedroom 3
    • Description: Guest Suite 2
    • Level: Upper
    Bedroom 5
    • Description: In Law Suite with Bathroom and Elevator
    • Level: Basement
    Primary bathroom
    • Features: Granite Counters, High Ceilings, Natural Woodwork
    • Level: Main
    Bathroom 1
    • Description: Half Bath
    • Level: Main
    Bathroom 3
    • Description: Guest Suite 1 Bath
    • Level: Upper
    Bathroom 4
    • Description: Guest Suite Bath 2
    • Level: Upper
    Dining room
    • Level: Main
    Other
    • Level: Main
    Family room
    • Level: Main
    Kitchen
    • Features: Breakfast Bar, Granite Counters, Kitchen Island, Pantry
    • Level: Main
    Laundry
    • Level: Main
    Media room
    • Description: Home Theater
    • Level: Upper
    Other
    • Level: Main
    Office
    • Level: Basement
    Office
    • Description: Enter from Gym
    • Level: Basement
    Other
    • Description: Wine Cellar
    • Features: Wet Bar
    • Level: Basement
    Other
    • Description: Gym
    • Level: Basement
    Recreation room
    • Features: Wet Bar
    • Level: Basement
    Heating
    • Fireplace(s), Forced Air, Geothermal, Natural Gas
    Cooling
    • Ceiling Fan(s), Central Air, ENERGY STAR Qualified Equipment, Geothermal
    Appliances
    • Included: Dishwasher, Disposal, Double Oven, Dryer, Exhaust Fan, Gas Cooktop, Microwave, Refrigerator, Trash Compactor, Washer
    • Laundry: Main Level
    Features
    • Audio Visual System, Cathedral Ceiling(s), Ceiling Fan(s), Elevator, Main Floor Bedroom, Pantry, Primary Bath, TV Mounts and Hardware, Walk-In Closet(s), Wet Bar
    • Flooring: Tile, Carpet, Hardwood
    • Windows: Window Treatments
    • Basement: Daylight,Finished,Full,Sump Pump,See Remarks
    • Number of fireplaces: 3
    • Fireplace features: Family Room, Gas, Primary Bedroom, Recreation Room
    Interior area
    • Total structure area: 7,505
    • Total interior livable area: 7,505 sqft
    • Finished area above ground: 4,798
    • Finished area below ground: 2,707

    Property

    Parking
    • Total spaces: 3
    • Parking features: Garage Door Opener, Heated Garage, Insulated, Lighted, Oversized, Parking Pad, Water, Triple+ Driveway, Garage Faces Side, Floor Drain, Additional Parking, Attached
    • Attached garage spaces: 3
    Accessibility
    • Accessibility features: Accessible Elevator Installed, Therapeutic Whirlpool
    Features
    • Levels: Three Or More,Two
    • Stories: 3
    • Patio & porch: Deck, Patio, Other
    • Exterior features: Rain Gutters, Outdoor Kitchen, Balcony, Dog Run, Lighting, Outdoor Grill
    • Spa features: Hot Tub, Whirlpool Tub
    • Has view: Yes
    • View description: Water
    • Has water view: Yes
    • Water view: Water
    • Waterfront features: Water Access, Waterfront
    Lot
    • Size: 0.55 Acres
    • Dimensions: 23958sqft
    • Features: Views, Sprinklers In Rear, Sprinklers In Front, Irregular Lot, Landscaped, Lot - Owned
    Details
    • Additional structures: Kennel/Dog Run, Other
    • Parcel number: 651811870
    • Other equipment: Home Theater

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Frame, Stone, Stucco
    • Foundation: Concrete Perimeter
    • Roof: Shingle
    Condition
    • New construction: No
    • Year built: 2013

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Sewer Connected, Natural Gas Connected, Water Connected, Trash Pickup - Public, Cable Connected, Electricity Connected

    Community & HOA

    Community
    • Security: Smoke Detector(s), Security System
    • Subdivision: Lakewood Harbor
    HOA
    • Has HOA: Yes
    • Services included: Common Area Maintenance
    • HOA fee: $850 annually
    Location
    • Region: Mandan

    Financial & listing details

    • Tax assessed value: $1,502,700
    • Annual tax amount: $18,467
    • Date on market: 5/24/2023
    • Electric utility on property: Yes
    • Road surface type: Asphalt

    Price history

    DateEventPrice
    10/2/2023Sold--
    Source: Great North MLS #4007711 Report a problem
    7/3/2023Pending sale$1,600,000$213/sqft
    Source: Great North MLS #4007711 Report a problem
    6/7/2023Price change$1,600,000-20%$213/sqft
    Source: Great North MLS #4007711 Report a problem
    5/24/2023Listed for sale$2,000,000-9.1%$266/sqft
    Source: Great North MLS #4007711 Report a problem
    8/11/2022Listing removed--
    Source: Great North MLS #4001396 Report a problem
    5/6/2022Listed for sale$2,200,000$293/sqft
    Source: Great North MLS #4001396 Report a problem
    3/14/2022Listing removed--
    Source: Great North MLS #3411502 Report a problem
    2/22/2022Price change$2,200,000+18.9%$293/sqft
    Source: Great North MLS #3411502 Report a problem
    7/13/2021Listed for sale$1,850,000+12.1%$247/sqft
    Source: BMMLS #411502 Report a problem
    7/13/2020Listing removed$1,650,000$220/sqft
    Source: White House Realty #407321 Report a problem
    6/18/2020Listed for sale$1,650,000+26.9%$220/sqft
    Source: White House Realty #407321 Report a problem
    12/3/2019Listing removed$1,299,990$173/sqft
    Source: TRADEMARK REALTY #403699 Report a problem
    8/5/2019Price change$1,299,990-21.2%$173/sqft
    Source: TRADEMARK REALTY #403699 Report a problem
    7/24/2019Listed for sale$1,650,000+3.1%$220/sqft
    Source: TRADEMARK REALTY #403699 Report a problem
    9/13/2018Listing removed$1,600,000$213/sqft
    Source: CENTURY 21 Morrison Realty #335668 Report a problem
    9/13/2017Listed for sale$1,600,000$213/sqft
    Source: TRADEMARK REALTY #335668 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025-- $67,622 +3.2%
    2024$18,778 +10%$65,547 +10.5%
    2023$17,071 -9.7%$59,312 -7.7%
    2022$18,910 +21.6%$64,267 +20.5%
    2021$15,545 +32.8%$53,330 +9.8%
    2020$11,703 $48,591 -89.8%
    2019-- $475,050
    2018-- $475,050 +2%
    2017-- $465,950
    2016$9,712 $465,950 +11.2%
    2015$9,712 +20%$419,050
    2014$8,092 --
    Find assessor info on the county website

    Neighborhood: 58554

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Fort Lincoln
    • Middle: Mandan
    • High: Mandan High

    Source: Great North MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.