NOT LISTED FOR SALE

15010 Sundown Dr Bismarck, ND 58503

Estimated Value: $1,162,000 - $1,240,339

4 Beds
3.5 Baths
3,469 Sq Ft
$344/Sq Ft Est. Value

Last Sold November 06, 2023

Current estimated payment $7,211/month

92 Days on Market

Highlights

  • Water Access
  • River Front
  • Private Lot
  • Grimsrud Elementary School Rated 9+
  • Deck
  • Wooded Lot

About This Home

As of November 2023

Are you looking for that perfect ''lake home feel'' without that weekend commute? If so, welcome to your new private oasis! This amazing home is situated on 3 + acres along the Missouri River in NW RURAL Bismarck and offers a lake like retreat only minutes from town!

This stunning home is perfectly situated on the Bismarck riverfront, providing breathtaking sunset views every evening. The large acreage surrounding the home offers privacy and tranquility, making it the perfect oasis for nature lovers and outdoor enthusiasts alike.

Step inside and experience the luxury of this stunning home. The open-concept design allows natural light to flow throughout, creating an inviting atmosphere. The kitchen is a chef's dream, including custom cabinetry, a pantry, and granite countertops. The spacious living room boasts expansive views of the riverfront, creating the perfect setting for cozy nights in with family and friends.

The home features 3+ bedrooms with plenty of space for guests. The primary bedroom offers a spa-like retreat, with a walk-in shower, custom cabinetry, double sinks, large walk-in closet, and a makeup counter area. The home office on the lower level is ONE-OF-A-KIND, with custom cabinetry and amazing RIVERFRONT VIEWS. The home also includes an updated GEO-thermal heating system.

The property also includes a luxurious finished entertainment cottage with a full kitchen/bar setup, a full bathroom, and guests sleeping quarters, all within steps of the main house.

Step outside onto the expansive deck to enjoy the sounds of the river and the stunning sunset views. Spend your days kayaking or fishing on the river, or simply take a stroll through the serene acreage surrounding the property, including an additional utility shed and black-top driveway. With its prime waterfront location and luxurious amenities, this property is an absolute must-see. Don't miss your chance to own this piece of paradise!

Last Agent to Sell the Property

Patrick Koski

Realty One Group - Encore License #8121 Listed on: 06/09/2023

Realty One Group - Encore

Last Buyer's Agent

PATRICK KOSKI

TRADEMARK REALTY

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,053

Year Built

  • Built in 1999

Lot Details

  • 3.29 Acre Lot
  • Lot Dimensions are 150x950
  • River Front
  • Property fronts a county road
  • Landscaped
  • Private Lot
  • Rectangular Lot
  • Front and Back Yard Sprinklers
  • Wooded Lot

Parking

  • 2 Car Garage
  • Driveway
  • Additional Parking

Home Design

  • Asphalt Roof
  • Metal Roof
  • Concrete Perimeter Foundation
  • Stucco

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Central Vacuum
  • Sound System
  • Ceiling Fan
  • 3 Fireplaces
  • Propane Fireplace
  • Window Treatments
  • Home Office
  • Water Views

Kitchen

  • Electric Cooktop
  • Dishwasher

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom on Main
  • Walk-In Closet

Laundry

  • Laundry Room
  • Laundry on main level

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Basement Window Egress

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Water Access
  • Balcony
  • Deck

Schools

  • Elk Ridge Elementary School
  • Horizon Middle School
  • Century High School

Utilities

  • Central Air
  • Heating System Uses Propane
  • Geothermal Heating and Cooling
  • Natural Gas Connected
  • Rural Water
  • Septic System

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 23-140-81-83-00-040

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,053

Year Built

Built in 1999

Lot Details

0

Parking

2

Listing Details

  • Architectural Style: Two-Story
  • Directions: North on Hwy 1804. East on 149th Ave NW. North on Sundown Dr.
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Road Frontage Type: County Road
  • Road Surface Type: Gravel
  • Year Built: 1999
  • Above Grade Finished Sq Ft: 2333.0
  • Fireplace: Yes
  • Garage Yn: Yes
  • Utilities Electricity Connected: Yes
  • Utilities Natural Gas Connected: Yes
  • Utilities Sewer Connected: Yes
  • Utilities Water Connected: Yes
  • Roof Asphalt2: Yes
  • Cooling Central Air: Yes
  • Flooring Carpet: Yes
  • Foundation:Concrete Perimeter: Yes
  • Appliances Refrigerators: Yes
  • Rooms:Bedroom 2: Yes
  • Rooms:Bedroom 3: Yes
  • Rooms:Laundry: Yes
  • Architectural Style Two-Story: Yes
  • Flooring Tile: Yes
  • Water Source Rural: Yes
  • Sewer Septic System: Yes
  • Road Frontage Type County Road: Yes
  • Special Features: None

Interior Features

  • Has Basement: Egress Windows, Finished, Full, Walk-Out Access, See Remarks
  • Flooring: Tile, Carpet
  • Appliances: Dishwasher, Electric Cooktop, Electric Range, Microwave Hood, Refrigerator
  • Total Bedrooms: 4
  • Fireplace Features: Propane
  • FireplaceFeaturesNumberOfFireplaces: 3
  • Interior Amenities: See Remarks, Ceiling Fan(s), Central Vacuum, Main Floor Bedroom, Main Floor Laundry, Pantry, Primary Bath, Security System, Smoke Detector(s), Sound System, Walk-In Closet(s), Wet Bar, Window Treatments
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 2
  • Below Grade Sq Ft: 1136.0
  • Fireplaces: 3
  • Total Bedrooms: 10
  • Appliances Dishwasher: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features Main Floor Bedroom: Yes
  • Interior Features Main Floor Laundry: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Interior Features Window Treatments: Yes
  • Basement Finished: Yes
  • Full Basement: Yes
  • Appliances:Electric Range: Yes
  • Appliances:Electric Cooktop: Yes
  • Interior Features:Security System: Yes
  • Interior Features:Pantry: Yes
  • Basement:Egress Windows: Yes
  • Other Rooms:Office: Yes
  • Basement:Walk-Out Access: Yes
  • Interior Features:Wet Bar: Yes
  • Interior Features:See Remarks10: Yes
  • Fireplace Features:Propane: Yes
  • Interior Features:Central Vacuum: Yes
  • Interior Features:Sound System: Yes

Exterior Features

  • Construction Type: Stucco
  • Exterior Features: Other, Balcony
  • Lot Features: Water View, Sprinklers In Rear, Sprinklers In Front, Wooded, See Remarks, Landscaped, Lot - Owned, Private, Rectangular Lot
  • Other Structures: Second Garage, Guest House
  • Patio And Porch Features: Deck
  • Roof: Asphalt, Metal
  • Waterfront Features: River Front, Water Access, Waterfront
  • Acres: 3.29
  • Waterfront: Yes
  • Foundation Details: Concrete Perimeter
  • General Property Information:Accessibility Features: No
  • Lot Features:See Remarks11: Yes
  • Lot Features:Rectangular Lot: Yes
  • Lot Features:Sprinklers in Front: Yes
  • Patio And Porch Features:Deck: Yes
  • ConstructionSiding:Roof Metal: Yes
  • Lot Features:Landscaped: Yes
  • Construction Materials:Stucco: Yes
  • Lot Features:Sprinklers In Rear: Yes
  • Lot Features:Private: Yes
  • Waterfront Features:River Front: Yes
  • Lot Features:Wooded: Yes
  • Exterior Features:Balcony: Yes
  • Lot Features:Water View: Yes
  • Waterfront Features:Water Access: Yes
  • WaterfrontFeaturesWaterfront: Yes

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Detached, See Remarks, Storage, Paved, Driveway, Additional Parking, Attached
  • Attached Garage: Yes
  • General Property Information:Garage: Yes
  • General Property Information:Garage Spaces: 2.0
  • Parking Features:Attached: Yes
  • Parking Features:Driveway: Yes
  • Parking Features:Detached: Yes
  • Parking Features:Additional Parking: Yes
  • Parking Features:Storage4: Yes
  • Parking Features:Paved: Yes
  • Other Structures:Second Garage: Yes

Utilities

  • Cooling: Central Air
  • Heating: Geothermal, Propane
  • Sewer: Septic System
  • Utilities: Sewer Connected, Natural Gas Connected, Water Connected, Electricity Connected
  • Water Source: Rural, Rural Water Membership
  • Cooling Y N: Yes
  • HeatingYN: Yes
  • Heating:Propane2: Yes
  • Heating:Geothermal: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • General Property Information:Association: No

Fee Information

  • Association Fee Includes: None

Schools

  • Elementary School: Elk Ridge
  • High School: Century High
  • Middle Or Junior School: Horizon

Lot Info

  • Lot Dimensions: 150x950
  • Lot Size Sq Ft: 143312.0
  • ResoLotSizeUnits: Acres
  • Parcel #: 23-140-81-83-00-040
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Year: 2022
  • Tax Annual Amount: 5053.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 9, 2023
Closed on
Nov 6, 2023
Sold by
Hoggarth Tonia L
Bought by
Rampton Joshua and Rampton Karen
Seller's Agent
Patrick Koski
Realty One Group - Encore
Buyer's Agent
PATRICK KOSKI
TRADEMARK REALTY
List Price
$1,249,500
Views
471
Current Estimated Value
$1,192,780

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
0.57%
Original Mortgage
$960,000
Outstanding Balance
$946,635
Interest Rate
7.25%
Mortgage Type
New Conventional
Estimated Equity
$265,981

Purchase Details

Closed on
Jun 2, 2023
Sold by
Hoggarth Monte D
Bought by
Hoggarth Tonia L

Purchase Details

Closed on
May 26, 2023
Sold by
Storms Abe L and Storms Catherine B
Bought by
Storms Living Trust and Storms

Purchase Details

Closed on
Jul 31, 2017
Sold by
Scott Brad J
Bought by
Hoggarth Monte D and Hoggarth Tonia L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$675,000
Interest Rate
2.99%
Mortgage Type
Adjustable Rate Mortgage/ARM
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Rampton Joshua $1,200,000 Quality Title
Hoggarth Tonia L -- None Listed On Document
Storms Living Trust -- None Listed On Document
Hoggarth Monte D -- Bismarck Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Rampton Joshua $960,000
Previous Owner Hoggarth Tonia L $175,201
Previous Owner Hoggarth Tonia L $316,252
Previous Owner Hoggarth Monte D $675,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/06/2023 11/06/23 Sold -- -- --
06/09/2023 06/09/23 For Sale $1,249,500 -- $360 / Sq Ft
Source: Bismarck Mandan Board of REALTORS®

Tax History Compared to Growth

Source: Public Records

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
2024 $8,695 $531,050 $0 $0
2023 $5,896 $356,750 $0 $0
2022 $5,053 $317,850 $0 $0
2021 $4,741 $298,550 $0 $0
2020 $4,616 $289,050 $0 $0
2019 $4,665 $289,050 $0 $0
2018 $4,270 $289,050 $28,850 $260,200
2017 $4,164 $260,200 $260,200 $0
2016 $4,164 $289,050 $28,850 $260,200
2014 $3,460 $394,200 $82,400 $311,800
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Bismarck Mandan Board of REALTORS®

MLS Number: 4008059

APN: 23-140-81-83-00-040