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

405 4th Street
Frost, MN 56033

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $225,000
Beds: 5
Baths: 2
Status: Active
SqFt: 2808
Agency: Olson Nelson Realty Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: Prepare to be wowed by this 5 bedroom, 2 bathroom home constructed in 2020 and located on the north edge of Frost. With over 2500 square feet of finished living space, this fabulous property is perfect for those seeking a spacious and comfortable home. The main level features an open concept floor plan, creating a seamless flow between the living, dining, and kitchen areas. This design allows for easy entertaining and a great sense of openness throughout the space. One of the highlights of the main level is the fabulous primary bedroom. It boasts a generous size and includes a large bathroom with a double vanity, a soaking tub, and a spacious walk-in shower providing a perfect retreat for relaxation and pampering. Additionally, the main level offers two more bedrooms, a full bathroom and a convenient laundry room. The lower level features new carpet throughout and offers a huge family room with ample space for various activities and gatherings. There are also two bedrooms on this level, providing additional sleeping quarters or versatile spaces for home offices, fitness rooms, or hobby areas. The lower level bathroom is stubbed in and waiting for its finishing touches, allowing you the opportunity to add your personal style and preferences. The vast backyard of this home offers endless opportunities for outdoor activities and enjoyment. Whether you envision hosting barbecues, playing games, gardening, or simply relaxing, with over half an acre it provides plenty of room to bring your ideas to life. There is a detached 30’ x 40’ garage with 10' ceilings, built in 2023, and is fully insulated. The oversize garage offers ample space for parking multiple vehicles or storing larger items such as recreational vehicles, boats, or workshop equipment.
MlsNumber: 7034930


Listing Provided By: Olson Nelson Realty Inc, original listing
Name: Olson Nelson Realty Inc
Phone: (507) 526-7304
Office Name: OLSON NELSON REALTY
Office Phone: (507) 526-7304
Agent Name: KARA DRAKE
Disclaimer: Copyright © 2024 Realtor Association of Southern Minnesota. 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