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

1579 Rivercrest Lane Sw
Bemidji, MN 56601
Noemi Aylesworth with Better Homes and Gardens Real Estate First Choice, original listing - (218) 751-2511

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,000
Beds: 5
Baths: Full: 3, ½: 2
Status: Active
SqFt: 4604 Square Feet
Agency: Better Homes and Gardens Real Estate First Choice
Agency Phone: (218) 751-2511

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1980
Notes: Fabulous 5 bd, 5 ba home on the Mississippi River. You will fall in love with this spacious home as it has everything thing you need from your private office to the large outside entertaining patio. You can live on the main level with 3 bedrooms, office, living room, formal dining room, informal dining area, 4 season porch, sun porch, plus laundry area. In the main floor entertaining area, you will find a wine bar & a Wilkening wood burning fireplace, a perfect place to unwind at the end of the day. The lower level has 2 bedrooms, one includes a 1/2 bath, large family room, bar area with sink and mini fridge, full bath, storage rooms, utility room with a wood storage room w/wood shoot for easy access. As you step outside the walk out you will be greeted with a variety of beautiful flowers (including Zinnia blooming throughout the season) along the patio which leads to the Mississippi River. Enjoy a paddle on the river or sit and read a book in the back yard private oasis. There is a fenced area for your pets to run free & even a clothesline. Homeowners have made many updates including light fixtures 2024, installed new carpeting in 3 main floor rooms 2024, newer roof 2020, new septic 2021, seal coated driveway 2024, newer washer & dryer 2022 and the ductwork has been cleaned. The oak wood flooring by expert John McDonald. Heated floor was added to 4 season sunroom. Furnace and AC has been cleaned and serviced. It will be obvious when you tour the home that it has been loved and well maintained. The location is exceptional, minutes from downtown, shopping and schools. Call for your private tour and fall in love with this amazing home!
MlsNumber: --
ListingId: 6585057


Listing Provided By: Better Homes and Gardens Real Estate First Choice, original listing
Phone: (218) 760-4689
Office Phone: (218) 751-2511
Agent Name: Noemi Aylesworth
Disclaimer: Copyright © 2024 Better Homes and Gardens Real Estate. 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