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

35497 Blackfoot Street Nw
Cambridge, MN 55008
Carrie L Gibbs with Century 21 Moline Realty Inc, original listing - (763) 689-3593

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $795,000
Beds: 3
Baths: Full: 1, ½: 1, ¾: 1
Status: Active
SqFt: 2869 Square Feet
Agency: Century 21 Moline Realty Inc
Agency Phone: (763) 689-3593

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2015
Notes: Simply gorgeous describes this modern industrial farmhouse estate on 20 acres. This property offers one level living at its finest, featuring a main floor primary bedroom and ensuite with stunning bath and tiled walk-in shower, soak tub, and gorgeous built-in cabinetry. The main level also offers a gourmet kitchen and fantastic walk-in pantry with Corian solid surface countertops, soft close cabinetry, large center island, and beautiful appliances. The open concept design offers amazing views from the kitchen and living room and provides access to one of the two tiled outdoor covered patios. The main floor laundry, additional half bath, and amazing foyer with access to the other covered patio complete this one level living experience. Upstairs you’ll find a family room loft, two additional bedrooms, and a tiled three-quarter bath. The three-car attached garage is in-floor heated and insulated and offers convenient no step access to the house. Outside you’ll enjoy the 36x48 pole building that is half heated and insulated with a 10x9 overhead door, and the other half is cold storage with 16x9 overhead door. Both the house and pole building are wired with ECE fiber optic internet too! Other features include in-floor heat with three zones (primary ensuite, rest of main level, and attached garage), forced air heat with central air conditioning, steel roof, LP SmartSide exterior siding, Marvin double hung windows, on demand hot water, rustic cherry trim throughout, custom steel beam stairwell, and more! Enjoy the 3D virtual tour and schedule your private showing today!
MlsNumber: --
ListingId: 6672018


Listing Provided By: Century 21 Moline Realty Inc, original listing
Phone: (763) 245-6431
Office Phone: (763) 689-3593
Agent Name: Carrie L Gibbs
Disclaimer: Copyright © 2025 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.


Local Real Estate Expert

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 = 1347 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;
Real Estate Expert Photo for Carol Nelson
Carol Nelson
ASCIIEdina Realty, Inc
Direct: (612) 964-7984

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App