Incredible opportunity to own a private, resort-style estate on coveted Turtle Lake in Shoreview. This 5 bed, 5 bath home offers over 6,100 sq ft of refined living on 3.6+ acres with 177 ft of sandy, west-facing shoreline for breathtaking sunsets. Enjoy soaring vaulted ceilings, walls of windows, and panoramic lake views. The main-level owner's suite includes a spa-like bath and executive office with custom built-ins. The gourmet kitchen features Wolf, Sub-Zero, and LaCanche appliances, hand-scraped French oak floors, and shiplap ceilings. The lower level is built for entertainment with a full kitchen, horseshoe bar, and game room. Outdoors, the park-like setting includes a spacious deck, screened porch, patio, and lakeside firepit. This extraordinary estate offers unmatched privacy, elegance, and year-round enjoyment.
Pending
$3,200,000
5315 Hodgson Rd, Shoreview, MN 55126
5beds
6,413sqft
Est.:
Single Family Residence
Built in 1997
3.67 Acres Lot
$-- Zestimate®
$499/sqft
$-- HOA
What's special
- 88 days
- on Zillow |
- 1,734 |
- 43 |
Zillow last checked: 7 hours ago
Listing updated: July 24, 2025 at 07:23am
Listed by:
Jim Diffley 612-986-6418,
Edina Realty, Inc.,
Shelley Diffley 612-730-1015
Source: NorthstarMLS as distributed by MLS GRID,MLS#: 6648237

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 3
- 1/2 bathrooms: 2
Rooms
- Room types: Living Room, Dining Room, Family Room, Kitchen, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Office, Recreation Room, Kitchen- 2nd, Exercise Room
Bedroom 1
- Level: Main
- Area: 306 Square Feet
- Dimensions: 17x18
Bedroom 2
- Level: Upper
- Area: 182 Square Feet
- Dimensions: 13x14
Bedroom 3
- Level: Upper
- Area: 208 Square Feet
- Dimensions: 13x16
Bedroom 4
- Level: Upper
- Area: 182 Square Feet
- Dimensions: 13x14
Bedroom 5
- Level: Lower
- Area: 238 Square Feet
- Dimensions: 14x17
Dining room
- Level: Main
- Area: 168 Square Feet
- Dimensions: 12x14
Exercise room
- Level: Lower
- Area: 168 Square Feet
- Dimensions: 12x14
Family room
- Level: Main
- Area: 260 Square Feet
- Dimensions: 13x20
Family room
- Level: Lower
- Area: 306 Square Feet
- Dimensions: 17x18
Kitchen
- Level: Main
- Area: 396 Square Feet
- Dimensions: 18x22
Kitchen 2nd
- Level: Lower
- Area: 272 Square Feet
- Dimensions: 16x17
Living room
- Level: Main
- Area: 304 Square Feet
- Dimensions: 16x19
Office
- Level: Main
- Area: 143 Square Feet
- Dimensions: 11x13
Recreation room
- Level: Lower
- Area: 600 Square Feet
- Dimensions: 20x30
Heating
- Forced Air, Fireplace(s), Radiant Floor
Cooling
- Central Air
Appliances
- Included: Air-To-Air Exchanger, Dishwasher, Disposal, Dryer, Exhaust Fan, Freezer, Humidifier, Water Filtration System, Microwave, Range, Refrigerator, Stainless Steel Appliance(s), Washer, Water Softener Owned
Features
- Basement: Drain Tiled,Finished,Concrete,Sump Pump,Walk-Out Access
- Number of fireplaces: 4
- Fireplace features: Family Room, Gas, Living Room, Primary Bedroom
Interior area
- Total structure area: 6,413
- Total interior livable area: 6,413 sqft
- Finished area above ground: 3,789
- Finished area below ground: 2,336
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Attached, Asphalt, Heated Garage, Insulated Garage
- Attached garage spaces: 3
- Details: Garage Dimensions (35x26)
Accessibility
- Accessibility features: None
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Porch, Screened
- Pool features: None
- Fencing: None
- Waterfront features: Lake Front, Waterfront Num(62006100), Lake Bottom(Sand), Lake Acres(450), Lake Depth(28)
- Body of water: Turtle
- Frontage length: Water Frontage: 177
Lot
- Size: 3.67 Acres
- Dimensions: 177 x 250
- Features: Accessible Shoreline, Many Trees
Details
- Foundation area: 2624
- Parcel number: 113023140008
- Zoning description: Residential-Single Family
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Brick/Stone, Engineered Wood
- Roof: Shake,Age Over 8 Years
Condition
- Age of Property: 28
- New construction: No
- Year built: 1997
Utilities & green energy
- Electric: Power Company: Xcel Energy
- Gas: Natural Gas
- Sewer: City Sewer/Connected
- Water: Private, Well
Community & HOA
Community
- Subdivision: Section 11 Town 30 Range 23
HOA
- Has HOA: No
Location
- Region: Shoreview
Financial & listing details
- Price per square foot: $499/sqft
- Tax assessed value: $2,250,800
- Annual tax amount: $33,935
- Date on market: 5/8/2025
- Loading