Skip main navigation
Pending
  • $3,200,000

    5315 Hodgson Rd, Shoreview, MN 55126

    5beds
    6,413sqft
    : 
    Single Family Residence
    Built in 1997
    3.67 Acres Lot
    $-- Zestimate®
    $499/sqft
    $-- HOA

    What's special

    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.
    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#: 6648237MLS Logo
    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