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

798 County Road 21
Beulah, ND 58523
Mike Sedgwick with Hayden Outdoors Real Estate, original listing - (970) 674-1990

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,300,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 1800 Square Feet
Agency: Hayden Outdoors Real Estate
Agency Phone: (970) 674-1990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: 2007
Notes: The Hook Line & Sinker is located in Beulah, ND and just 15 miles from the famous Lake Sakakawea on the Missouri River system. This is an outstanding opportunity to own a profitable bait and tackle shop along with restaurant area, gas and diesel pumps, four offices, large shop, owners home, garage, extra trailer home to rent, RV hookups and dry storage area. This property consists of 12 acres zoned commercial, and endless opportunity with Highway Frontage! Highway 200 runs along the south portion and County Road 21 runs west. This property is turnkey. All appliances and furniture for the bait shop and restaurant are included. The owner leases out four offices and the 60 X 40 shop. The tenet has been their for 12 years and pays $1,750/month and is on a month to month basis which includes some of the un-used acres out back to park trucks. The restaurant area is not currently rented out , but comes complete with commercial kitchen, chairs, tables, cooler, sinks, and can seat up to 50 people. The dry storage area is a warehouse that the owner leases out for winter storage of boats, campers, or equipment. They get $250 for a 5 month storage season and could be increased by the new owner. There is more income opportunity to rent out the 10 RV spaces that are located at the backside of the property. MORE FACTS: 12- Acres zoned commercial. 12,500 Sq/ft commercial building. 2-10,000 gal gasoline storage tanks above ground. 1-8,000 gal diesel storage tank above ground. 10 fuel pumps. 2007 - 1,800 sq/ft 3 bed/ 2 bath owner/manage home with new roof and siding, 2 car garage, 10x40 shop and lean-to. Garden shed and 2 bed/ 1 bath single wide trailer that the gets $600/month rent. 10- RV or truck hook ups with own septic system and power. All the LP tanks are owned and transfer with sale. Beer and gambling permit will transfer pending all county and state requirements. All coolers, freezers, shelving, live bait tanks, permits, and equipment except for the coolers that coke and pepsi own will transfer. The lake is named after the female Shoshone guide Sakakawea who led the Lewis & Clark expedition north on the Missouri River during their journeys through this area at the start of the 19th century. Lake Sakakawea and Garrison Dam are located in McLean and Mercer counties, 75 miles north of Bismarck, ND, amongst the rolling prairie and badlands of Western North Dakota. Lake Sakakawea is the third largest man-made lake in the United States at 178 miles long, with over 1,500 miles of shoreline. Impounded by the Garrison Dam on the Missouri River, Lake Sakakawea has a surface area of 307,000 acres, maximum depth of180 feet. There are 12 different species of fish in Lake Sakakawea with the most notable are the Walleye, Northern Pike, Smallmouth Bass, Sauger, Rainbow Trout, Crappie, Perch, Chinock Salmon, and Paddlefish. There is something for every angle of any age. North Dakota has vibrant, wild ring-necked pheasant populations, plus duck and goose hunting in the Central Flyways headwaters can be off the charts. Enjoy the best of both worlds - ravenous ducks and geese decoying by morning and colorful, cussing-while-they-flush ring-neck roosters by afternoon! New development is occurring around the property which will increase traffic to the area. Over the next 3 years should be additional 2,000 workers in town with new natural gas plant projected to be coming to the area. For a private showing , please call the listing agent.
MlsNumber: --
ListingId: 11155685


Listing Provided By: Hayden Outdoors Real Estate, original listing
Phone: (970) 674-1990
Office Phone: (970) 674-1990
Agent Name: Mike Sedgwick
Disclaimer: Copyright © 2024 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.


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 = 2013 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;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App