Refine Your Search

Change the location, price range, bedrooms, or bathrooms below.

5315 Hodgson Road, Shoreview, MN 55126

$2,900,000
Property Type: Residential Bedrooms: 5 Baths: 5 Square Footage: 6,413 Lot Size (sq. ft.): 159,865 Status: Closed
Current Price: $2,900,000 List Date: 5/12/2025 Last Modified: 8/19/2026

Overview

Description

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.

Listing Details MLS# 6648237

General Property Information

Common Wall
No
Lot Measurement
Acres
Manufactured Home?
No
Multiple PIDs?
No
New Development
No
Number of Fireplaces
4
Road Btwn WF & Home?
No
Waterfront Frontage
177
Waterfront YN
Yes
Year Built
1997
Yearly/Seasonal
Yearly
Zoning
Residential-Single Family
Bath Full
3
Bath Half
2
Main Floor Total SqFt
2624
Above Grd Total SqFt
3789
Below Grd Total SqFt
2624
Total SqFt
6413
Total Finished Sqft
6125.00
FireplaceYN
Yes
Lake/Waterfront Name
Turtle
Style
(SF) Single Family
Foundation Size
2624
Power Company
Xcel Energy
Garage Stalls
3
Lot Dimensions
177x250
Acres
3.67
Assessment Pending
No

Property Features

Accessible: None Air Conditioning: Central Air Amenities Unit: Ceiling Fan(s); Deck; Exercise Room; In-Ground Sprinkler; Kitchen Center Island; Kitchen Window; Paneled Doors; Primary Bedroom Walk-In Closet; Tile Floors; Vaulted Ceiling(s); Walk-In Closet Appliances: Air-To-Air Exchanger; Dishwasher; Disposal; Dryer; Freezer; Microwave; Range; Refrigerator; Washer; Water Filtration System Basement: Drain Tiled; Sump Pump Bath Description: Double Sink; Main Floor 1/2 Bath; Upper Level Full Bath; Full Primary; Private Primary; 1/2 Basement; Full Basement; Separate Tub & Shower Construction Status: Previously Owned Dining Room Description: Informal Dining Room; Separate/Formal Dining Room Exterior: Brick/Stone; Engineered Wood Family Room Characteristics: Lower Level; Main Level Fencing: None Financing Terms: Conventional Fireplace Characteristics: Family Room; Gas Burning; Living Room; Primary Bedroom; Other Fuel: Natural Gas Heating: Forced Air; In-Floor Heating Lake Details: Sand Laundry: Laundry Room; Main Level; Sink Lock Box Type: Supra Lot Description: Accessible Shoreline; Tree Coverage - Heavy Parking Characteristics: Heated Garage; Insulated Garage Pool Description: None Road Frontage: City Street Roof: Age Over 8 Years; Shake Sellers Terms: Cash; Conventional Sewer: City Sewer/Connected Special Search: 3 BR on One Level; All Living Facilities on One Level; Main Floor Laundry; Main Floor Primary; Primary Bdr Suite Stories: Two Water: Private; Well Waterfront Type: Lake Front

Contract Information

Off Market Date
2025-07-24
Contingency
None
Closed Date
2025-08-18
Original List Price
3200000
Sales Close Price
2900000
ListPrice
3200000
Owner is an Agent?
No
Auction?
No

Location Tax and Other Information

House Number
5315
Street Name
Hodgson
Street Suffix
Road
Postal City
Shoreview
County
Ramsey
State
MN
Zip Code
55126
Complex/Dev/Subdivision
Section 11 Town 30 Range 23

Assessments

Assessment Balance
105
Tax With Assessments
34040

Building Information

Finished SqFt Above Ground
3789
Finished SqFt Below Ground
2336

More Information

Lake Details

Lake Acres
450
Lake Depth
28

Lease Details

Land Leased
Not Applicable

Lock Box Type

Lock Box Source
SPAAR

Miscellaneous Information

Homestead
Yes

Ownership

Fractional Ownership
No

Parking Characteristics

Garage Dimensions
35x26
Garage Square Feet
910

Public Survey Info

Range#
23
Section#
11
Township#
30

Room Information

Room Name Dimensions Level
Exercise Room 12x14 Lower
Recreation Room 20x30 Lower
Office 11x13 Main
Family Room 17x18 Lower
Family Room 13x20 Main
Second Kitchen 16x17 Lower
Fourth (4th) Bedroom 13x14 Upper
Third (3rd) Bedroom 13x16 Upper
Fifth (5th) Bedroom 14x17 Lower
Kitchen 18x22 Main
Second (2nd) Bedroom 13x14 Upper
First (1st) Bedroom 17x18 Main
Dining Room 12x14 Main
Living Room 16x19 Main
IDX
Listing Office: Edina Realty, Inc.
Last Updated: August - 19 - 2026
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity SM Program of the Regional Multiple Listing Service of Minnesota, Inc. The information provided is deemed reliable but not guaranteed. Properties subject to prior sale, change or withdrawal. ©2026 Regional Multiple Listing Service of Minnesota, Inc All rights reserved.

Starts in :

00
Days
00
Hours
00
Minutes
00
Seconds