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

816 Western Avenue
Madison, MN 56256

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $209,500
Beds: 3
Baths: ¾: 2
Status: Active
SqFt: 1962 Square Feet
Agency: Peterson Team Realty
Agency Phone: (320) 226-5021

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1962
Notes: WESTERN AVE IS WHERE IT IS AT! PEACEFUL QUIET STREET AND THE WHOLE NEIGHBORHOOD IS WELL CARED FOR! THIS IS A RAMBLER THAT OFFERS MAIN FLOOR LIVING. KITCHEN, DINING, LIVINGROOM, 3 BEDROOMS, LAUNDRY AND BATH! <br /> MAIN FLOOR BATHROOM OFFERS A DOUBLE SINK AND LARGE WALK IN SHOWER. THE HARDWOOD FLOORS THROUGHOUT ARE BEAUTIFULLY REFINISHED! BEDROOMS OFER LARGE CLOSETS. KITCHEN OFFERS A BREAKFAST BAR AND AMPLE CABINETS AND COUNTER SPACE, BEAUTIFUL OAK CABINETS. BAY WINDOW IN DINING AREA. BACK DECK IS MAINTENANCE FREE AND WALKS OUT TO THE BACK STREET AND GARAGE AREA. WONDERFUL BACK YARD WITH PERRENIALS AND MATURE TREES, TO GIVE YOU SO MUCH SHADE! ONE STALL DETATCHED GARAGE AND STORAGE SHED. THERE IS ROOM FOR A LARGER GARAGE IF WANTED. 4 SEASON PORCH OFF THE BACK, CURRENTY HOUSING THE LAUNDRY, BUT THE LAUNDRY CAN GO BACK IN THE BASEMENT IF YOU WISH. METAL SIDING ON HOUSE AND GARAGE. NEWER FURNACE AND HOT WATER HEATER. THE BASEMENT OFFERS A LARGE FAMILY ROOM, THE 4TH BEDROOM (NON CONFORMING, NO EGRESS WINDOW) A ROOM WITH HOOKUPS FOR LAUNDRY, AND A 3/4 BATH. BEAVER SYSTEM. NO SHOWINGS ON SATURDAY AND SUNDAY FAMILY IS STILL REMOVING PERSONAL ITEMS FROM THE HOME. GUTTERS WITH LEAF GAURD. MORE PICTURES WILL BE ADDED NEXT WEEK.
MlsNumber: --
ListingId: 6594595


Listing Provided By: Peterson Team Realty, original listing
Phone: (320) 226-5021
Office Phone: (320) 226-5021
Agent Name: Dawn G Peterson
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