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 = 1992 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 = 1992 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 = 1992 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;

904 Cody Drive
Bismarck, ND 58503

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $719,900
Beds: 5
Baths: 5
Status: Active
SqFt: 4333
Agency: NextHome, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2002
Notes: Experience luxury living in this custom-built ranch home located on a corner lot in the desirable North Bismarck. It boasts an double deep 3-stall garage spanning an impressive 1,406 square feet, with space for 6 cars, is heated and insulated, and has a drain and closet. Step inside to discover an expansive open-concept layout featuring a grand living room with a cozy fireplace, high vaulted ceilings, and a chef's dream kitchen with quartz countertops, ample wood cabinets, a sprawling eat-in island, beautiful glossy backsplash, and stainless steel appliances. The adjacent private dining area and walkout deck offer the perfect space for entertaining guests. The main floor laundry and an additional Bathroom #1 are near the garage entrance and kitchen. The main floor also houses a massive primary suite, Bedroom #1, with trey ceilings, a walk-in closet, and a luxurious full Bathroom #2 with a jet tub and separate shower. Enjoy a second living room with a wet bar and access to a beautiful front porch, ideal for relaxing evenings. This area leads to a second bedroom with a deep walk-in closet and an en-suite bathroom. You'll find gorgeous wood trim, light neutral wall spaces, laminate flooring ceramic tile, and an abundance of natural light flooding through the expansive windows on this level. This area is currently use as an In Law Suite or it could also be an office. Venture downstairs to the daylight lower level, where you'll find a third living room with patio access, a second wet bar, an office with beautiful cabinetry, and a spacious bonus room. Nearby is Full Bathroom #3, Bedroom #3, Bedroom #4, and Bedroom #5, with a sizable walk-in closet (attached is a private Bathroom #5). Outside, the fully fenced yard boasts scenic views, a rock garden, and meticulous landscaping. Sit back and enjoy the sunset from the big and beautiful front porch. Exterior is brick and steel siding ensuring elegance and durability. This upscale and well-maintained property offers endless possibilities for relaxation and entertainment. (Only one homeowner)! It's time to elevate your lifestyle! Don't miss your opportunity to call this stunning masterpiece your next home. Schedule a tour with a Realtor today.
MlsNumber: 4012913


Listing Provided By: NextHome, Inc, original listing
Name: NextHome, Inc
Office Name: NextHome Legendary Properties
Office Phone: (701) 712-8900
Agent Name: Pam J Hanson
Disclaimer: Copyright © 2024 NextHome, Inc. 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 = 1992 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;
Jane Thoele
ASCIIBianco Realty
Call Today!: (701) 226-1464

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App