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

318 Wolf Pointe Trail
Long Lake, MN 55356
Emily Olson with Redfin Corporation, original listing - (612) 998-5674

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,025,000
Beds: 4
Baths: Full: 1, ½: 1, ¾: 2
Status: Active
SqFt: 3683 Square Feet
Agency: Redfin Corporation
Agency Phone: (612) 998-5674

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Welcome to this stunning Long Lake home! Walkout Rambler with 4 bedrooms and 3.5 bathrooms – on .46 acre, located on a quiet cul-de-sac. Built in 2001 – original owner since built, non-smoking and no pets. Heated driveway and front walkway. Located in the Orono School District. Fantastic neighborhood consisting of 11 single family homes in Wolf Pointe Woods Homeowners Association. HOA annual dues $2560, include lawn mowing, fertilizing, fall clean-up, snow removal and maintenance of private road, landscaped berm, boat slips and insurance for the Association. Homeowners have water access to 4 boat slips and on Long Lake. Enter the main level foyer and be welcomed to this gorgeous home. American Cherry wood floors throughout the large entryway with high ceilings and columns, hallway and kitchen. <br /> Off of the foyer is a formal dining room with a built-in hutch and enclosed upper glass cabinets. The spacious kitchen features a center island, dine-in area, two ovens, stainless steel appliance, quartz counter tops and tiled back splash. Ample cabinets for storage- including pull out drawers and shelves, along with a built in desk. Off of the kitchen is access to wet bar featuring built-in wine storage, cabinets, sink, wine and beverage refrigerator. Large deck with beautiful views of the backyard is accessed thr door off the kitchen area – (also accessed from door located in the back of the garage). Living room features a gas fireplace, wall of built-in cabinets and shelves, large windows with UV film and views of the landscaped backyard with mature trees that offer privacy. Home hosts a main level Primary Suite – bedroom features large windows with UV film and a view of the backyard. Walk-in closet and en-suite bathroom featuring a heated floor and Jacuzzi tub with separate shower. Main level also includes an office off the front entryway with french doors, built-in desk and cabinets. Half bath located down the hallway from the front door. Main level mudroom and laundry room have heated floors – mudroom has access to the garage. Laundry room has 2 windows overlooking the front yard, washer, dryer, tub sink, upper and lower cabinets for storage. Three car garage with in-floor heating, epoxy coated floors and two floor drain tiles for washing cars. Garage doors and walls are insulated (with thermostat), sky light, tub sink with hot/cold and softened water. Overhead storage and motorized storage unit to hang/store bikes and other items in the air. Lower level walk-out has heated wooden floors and forced air through out. Large family room with gas fireplace and built-in cabinets. Bar area with high top counter seating, built-in wine storage, cabinets, refrigerator, microwave and sink. Three bedrooms, including one with French doors and a walk-in closet. Two bathrooms with showers – one with a large walk-in shower with dual shower heads. Access to back yard patio - beautiful landscaped outdoor space, thru patio door and double sliding glass door. Utility room on lower level with furnace, 2 boilers – one for heated floors and other for heated driveway and walkway (serviced annually). Also water heater and Kinetico water softener. Sump pump (Installed - never needed to use). Additional home features include – gas heat, alarm system, surround sound on main, lower level and deck. In-ground sprinkler system, forced air and a central vacuum system through out the house. Lots of built-in storage through out the house. Front and backyard landscaped – terraced backyard with large boulders and view of mature trees and wetlands area for privacy (sprayed for mosquitoes). Brand new AC and furnace (June 2024), water heater (2019) . Don’t miss out – make this home yours today!
MlsNumber: --
ListingId: 6599334


Listing Provided By: Redfin Corporation, original listing
Phone: (507) 382-8398
Office Phone: (612) 998-5674
Agent Name: Emily Olson
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.


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 = 1344 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;
Dan Winters
ASCIIThe Winters Real Estate Group
Call Today!: (612) 200-0808

Local Mortgage Pro

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 = 1344 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;
Bryan Bentley NMLS#400911
ASCIICrossCountry Mortgage
Call Today!: (612) 212-4798

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App