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

9876 County Road 58 Nw
Brandon, MN 56315
Todd J Whiting with First Realty, Inc., original listing - (320) 252-4908

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $627,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2582 Square Feet
Agency: First Realty, Inc.
Agency Phone: (320) 252-4908

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 19 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1974
Notes: Discover the ultimate in country living with this breathtaking 20-acre private retreat, featuring your very own lake and a wealth of amenities! This beautifully updated 3-bedroom, 3-bath home is move-in ready, offering a perfect blend of comfort and elegance.<br /> <br /> Step inside to soaring vaulted ceilings and a show stopping kitchen, complete with custom alder cabinetry, granite countertops, a spacious center island, stainless steel appliances, bamboo flooring, task lighting, and a pantry. The dining area, illuminated by a new bay window, showcases stunning views, while the living room invites you to unwind by the cozy fireplace or step out onto the expansive 38-foot deck overlooking your serene Burrs Lake.<br /> <br /> The luxurious owner’s suite features a walk-in closet, a tiled shower, and a granite double-sink vanity. Three fireplaces throughout the home create warmth and ambiance, while in-floor heating in the kitchen, living, and dining areas adds extra comfort. The walkout lower level opens to a sprawling front yard and a heated outdoor swimming pool, ideal for entertaining or relaxing.<br /> <br /> Beyond the home, this property boasts incredible outbuildings, including a 38' x 48' insulated shop with three oversized garage doors, an 18' x 38' heated workshop, a 12' x 20' guest cabin, and a 56' x 15' chicken coop—perfect for hobby farming or additional storage. A paved driveway adds convenience.<br /> <br /> Outdoor enthusiasts will love the mile-and-a-half shoreline of Burrs Lake, teeming with bass, sunfish, and northern pike for exceptional fishing. Whether you're seeking luxury living, recreational paradise, or a peaceful nature escape, this extraordinary property has it all.<br /> <br /> A brand-new septic system was installed in fall 2024.
MlsNumber: --
ListingId: 6670338


Listing Provided By: First Realty, Inc., original listing
Phone: (320) 766-2200
Office Phone: (320) 252-4908
Agent Name: Todd J Whiting
Disclaimer: Copyright © 2025 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