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

403 Sullivan Avenue S
Hinckley, MN 55037
Audrey W. Wirkus with Real Estate Masters, LTD, original listing - (651) 484-4818

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $245,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1439 Square Feet
Agency: Real Estate Masters, LTD
Agency Phone: (651) 484-4818

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Welcome to 403 Sullivan Ave. S. A must see. Spacious 3 BR/2BA 1439 sq ft. New Manufactured home on a corner lot with trees and a large parking area to build a 2 car garage and have space for addl' parking. This 1 level home offers 3 BR and 2 Full baths one BA adjoining the Master BR. Double Sinks, Large Vanity with spacious cabinetry plus a separate Linen closet and a built in locker style cabinetry. See pictures for details. Walk-in closet with shelving installed. Window push up & down Blinds. Kitchen offers Stainless Steel Appliances, Gas Range with overhead Exhaust Fan, lookout kitchen window, A fabulous Center Island with pull out drawers great for Pots and Pan & more. Ctr. Is side electrical outlet to use perfect for entertaining and family gatherings. There's the Dining Area with a Large window with push up & down Blinds. The Refrigerator surrounded by cabinets and counter space. The kitchen/DR area has recessed lighting. Kitchen door walk out to Utility Room, has Washer/Dryer hookups, entryway walkout to deck.<br /> 2 Panel style Doors through out. LR, BR carpeted. Kitchen, DR, BA's and utility Rms have Luxury Vinyl Planking flooring. LR 19'5" carpeted, has a Fan light & Entry Closet. Window Blinds push up & Down. Lots of electrical Outlets. 2 Bedrooms & 2nd full bath opposite end of house. Ideal location and easy access for commuting to Highways and local amenities. Don't miss the chance to make this exceptional property your own!
MlsNumber: --
ListingId: 6626632


Listing Provided By: Real Estate Masters, LTD, original listing
Phone: (612) 940-0145
Office Phone: (651) 484-4818
Agent Name: Audrey W. Wirkus
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