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 = 1366 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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 = 1366 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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 = 1366 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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;

8841 Basil Road
Swanville Twp, MN 56382
Tina Scepaniak with VoigtJohnson, original listing - (320) 774-2400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $865,000
Beds: 3
Baths: Full: 2, ½: 2, ¾: 1
Status: Active
SqFt: 3180 Square Feet
Agency: VoigtJohnson
Agency Phone: (320) 774-2400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 24 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: A truly rare opportunity to own this thoughtfully designed, custom-built home with premium finishes. Featuring a modern open floor plan, beamed ceilings, and expansive west-facing windows, this home offers breathtaking views of a 600+ acre wildlife marsh. From the moment you step onto the welcoming covered front porch, you'll feel the warmth and elegance of the inviting entryway. The spacious great room, complete with a stunning fireplace, flows seamlessly into the gourmet kitchen, outfitted with GE Wi-Fi-compatible appliances, custom cabinetry, a large center island, and a butler's pantry. The main-level primary suite boasts a luxurious walk-in tiled shower, dual sinks, and a large walk-in closet with custom built-in shelving and dressers. The main level also includes two additional bedrooms, an office, and a laundry room with a porcelain sink. Upstairs, you'll find a cozy family room, a bathroom, and a versatile bonus room, perfect for a 4th bedroom, workout space, or whatever you desire. The attached 3-car heated garage is complemented by a 64x40 shop, which features a 20x40 fully finished "man cave" complete with a wet bar and bathroom. Enjoy the tranquility of this serene setting from the covered back porch or patio. The property is 24 acres with 19 wooded. This showstopper property is packed with exceptional features—be sure to check the supplement list for all the details!
MlsNumber: --
ListingId: 6597069


Listing Provided By: VoigtJohnson, original listing
Phone: (320) 293-8849
Office Phone: (320) 774-2400
Agent Name: Tina Scepaniak
Disclaimer: Copyright © 2024 Regional Multiple Listing Service of Minnesota [NorthStarMLS]. 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