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

4536 368th Avenue
Stony Run Twp, MN 56265
Janell Welling with Hughes Real Estate and Auction, original listing - (320) 815-0460

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $444,999
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2559 Square Feet
Agency: Hughes Real Estate and Auction
Agency Phone: (320) 815-0460

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1978
Notes: This beautiful 3 bedroom/2 bath home with 4 car garage is truly a treasure! From the moment you arrive, you are greeted by a lovely front yard with fully paved horseshoe driveway, raised perennial beds, a private back yard with walkout patio & firepit, a walkout deck, and a beautiful front door that leads you to the private front foyer, Step in and enjoy the abundant storage space in the custom built cabinets with pullout shelves and built-in bench. The warmth and cozy feel of this home can be felt all throughout the home, including the 3 season porch with gas stove, vaulted ceiling and fan. The main floor also offers a large living room, three bedrooms, and a full bath with step-in shower. The fully finished basement includes a large family room with gas fireplace, built-in bar and walkout patio.; plus a full bath, large storage room and laundry room. The mudroom connects you to an attached heated two car garage that is fully cemented and insulated. Right next door is the additional detached two car garage, that is also fully cemented! Need more storage? - Check out the additional storage shed located on the west edge of the property. Well maintained and move-in ready this home offers numerous quality upgrades made in the last 5 years by the current sellers; including: New shingles, siding & gutters, new 4" drain tile between the garages, new storage shed, new seal coat on the driveway, new outside lights, new garage door openers with remotes, new "Hot Dawg" garage heater, new screen door, new oven door, new refrigerator, garbage disposal & microwave, 2 brand new sump pumps with back-up batteries, new washer & dryer, new living room carpet and a new gas fireplace stove in the 3 season porch! Living on the edge (of town) never felt so good! If you are looking for a lovely spacious home set upon 1.3 acres with all the amenities - this is it! Call for your showing today! This is truly a MUST SEE!
MlsNumber: --
ListingId: 6598898


Listing Provided By: Hughes Real Estate and Auction, original listing
Phone: (320) 226-5586
Office Phone: (320) 815-0460
Agent Name: Janell Welling
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