Spacious and beautifully updated, this exceptional home offers over 7,000 square feet of thoughtfully designed living space with modern finishes throughout. Filled with abundant natural light, the expansive layout features multiple gathering areas ideal for both entertaining and everyday living. The impressive additional living quarters include a full kitchen, creating endless possibilities for guests, multi-generational living, private quarters, or extended entertaining space. Built with quality and comfort in mind, the home features concrete subfloors separating the main and lower levels, providing added durability and sound separation. Enjoy the convenience of a dedicated weight room for at-home fitness, while the large outdoor patio deck showcases breathtaking views overlooking Mandan. Car enthusiasts, hobbyists, and anyone in need of extra space will appreciate the heated 8-stall garage (over 3,000 square feet), complete with a large 16x10 garage door and perfectly suited for use as an attached shop, workspace, or additional storage. Adding to its appeal, this property is zoned Downtown Fringe, offering incredible flexibility and endless possibilities. Whether you're looking for a luxury primary residence, an income-producing rental, a short-term vacation rental, or a unique live/work opportunity, the versatile zoning provides exceptional potential for a variety of future uses. Combining luxury, functionality, and investment potential, this one-of-a-kind property presents an extraordinary opportunity in a truly exceptional setting.