Title Page Background
DEBUG FN args: Array ( [0] => 2024 [1] => [2] => [3] => agent ) BEFORE: Site: 2024 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2024 Igate: njhud LocID: 2024 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2024 AND i.igate IN ('dehud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'dehud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2024 [1] => [2] => [3] => lender ) BEFORE: Site: 2024 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2024 Igate: njhud LocID: 2024 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2024 AND i.igate IN ('dehud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'dehud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2024 [1] => [2] => [3] => other ) BEFORE: Site: 2024 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2024 Igate: njhud LocID: 2024 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2024 AND i.igate IN ('dehud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'dehud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

417 7th Ave Ne
Rolla, ND 58367
Jessie Mickelson with Grace Realty LLC, original listing - (701) 477-2204

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $322,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1390 Square Feet
Agency: Grace Realty LLC
Agency Phone: (701) 477-2204

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1964
Notes: This wonderful ranch home has been fully updated within the last 7 years. As you enter, you will find an open floor plan. The large floor-to-ceiling propane fireplace is the centerpiece of the living room. Adjacent to your living space is the generous dining area with built-in cabinetry, great natural light & flows effortlessly onto the back deck. The fully upgraded kitchen boasts an elegant backsplash, soft close-fully adjustable cabinets and new appliances. Off the living area, you'll find the full 5 piece bath with a freestanding tub & beautifully tiled shower. The spacious master bedroom has 2 large closets, one is a walk-in! The 2nd main floor bedroom is a great size too with a large closet. On your lower level is a 3rd bedroom, family room, flex space, and a 3/4 bath! This level also houses a mechanical room with lots of storage space. The double attached garage is 22X21 with an entrance to the home's mudroom/laundry and also has the hot tub room. This home has a great location close to parks and the local school. It is situated on a large corner lot, has a 12X14 garden shed, and mature trees. New shingles were done in 2017 with the siding, windows and doors being replaced in 2018. With decks on the front and back you'll find your favorite outdoor spot any time of the day. This home has been upgraded from top to bottom! Upgrades include: Forced air furnace/AC (electric or propane) in 2022, triple-pane double hung windows in 2018, siding & doors in 2018, full kitchen remodel in 2018, flooring 2018, propane fireplace 2018, water heater 2017 and new concrete in 2020. A lender preapproval letter required before showings.
MlsNumber: --
ListingId: 11436347


Listing Provided By: Grace Realty LLC, original listing
Phone: (701) 477-2204
Office Phone: (701) 477-2204
Agent Name: Jessie Mickelson
Disclaimer: Copyright © 2025 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App