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

515 Harbor Court
Shoreview, MN 55126
Reidell Estey & Associates – Marti Estey with RE/MAX Results, original listing - (651) 251-4800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $895,000
Beds: 5
Baths: Full: 2, ½: 1, ¾: 1
Status: Active
SqFt: 4124 Square Feet
Agency: RE/MAX Results
Agency Phone: (651) 251-4800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1993
Notes: Welcome to this stunning 5-bedroom, 4-bathroom home located in the highly sought-after Snail Lake Landing neighborhood, within the award-winning 621 school district. Recently renovated by Trehaus, this home has been meticulously designed with both style and functionality in mind. The current owners are incredibly sad to leave due to relocation, as this home truly offers everything a modern family could want.<br /> The custom kitchen in this home is truly a dream, featuring a massive island with seating for five, custom cabinetry with numerous roll-out shelves, motorized garbage & numerous other thoughtful extras. Incredible pantry with an appliance shelf for ultimate organization. The kitchen is completed with granite countertops, a stunning tile backsplash, and top-of-the-line stainless steel appliances. Throughout the main floor, you’ll find exquisite lighting and upgraded hardware, enhancing the sophisticated feel. The attention to detail continues with all-new railings, trim, and custom doors leading to the office and both the front and back entries. A custom runner guides you to the second floor, where pristine true hardwood floors continue seamlessly throughout the first and second levels. The second floor houses a beautiful primary suite, complete with a spacious walk-in closet, a cozy separate seating area or office, and a luxurious ceramic bath with a separate tub, shower, and dual sinks. Three additional bedrooms and a full bathroom round out the upper level, offering comfort and style in every corner.<br /> LL includes a recreation room, wet bar, and office area, as well as a 5th BR with walk-in closet with custom organizers and 3/4 ceramic bath with high vanity.<br /> The home also boasts a custom-tiled mudroom with built-in hooks, a bench, and cubbies, plus a second entry door for added convenience. Just off the mudroom, you’ll find the laundry room, equipped with updated front-load washer and dryer, as well as a laundry sink. Outside, the property features an irrigation system to keep your lawn lush and an invisible fence for pets. The insulated 3-car garage is complete with two openers & provides plenty of space for storage and vehicles. Hardie siding, newer roof and gutters, 200 AMP electric and stunning Anderson 400 series windows throughout the entire home, offering both beauty and energy efficiency. The large deck at the back of the house is perfect for entertaining or simply relaxing. With all of these upgrades, this home is truly move-in ready—nothing to do but enjoy!
MlsNumber: --
ListingId: 6697825


Listing Provided By: RE/MAX Results, original listing
Phone: (651) 442-9353
Office Phone: (651) 251-4800
Agent Name: Reidell Estey & Associates – Marti Estey
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 = 1379 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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;
Anthony Rodriguez
ASCIIKeller Williams Realty Integrity Edina
Call Today!: (651) 402-4726

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App