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/18/2025

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 Present
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
Bath Three Quarters
0
Bath Quarter
0
Association Fee
0

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; Poured Concrete; 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 Foundation: 8 ft+ Pour 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

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
Sand
Yes

Lease Details

Land Leased
Not Applicable

Lock Box Type

Lock Box Source
SPAAR
Supra
Yes

Miscellaneous Information

Homestead
Yes

Ownership

Fractional Ownership
No

Parking Characteristics

Garage Dimensions
35x26
Garage Square Feet
910
Heated Garage
Yes
Insulated Garage
Yes

Public Survey Info

Range#
23
Section#
11
Township#
30

Office/Member Info

Association
SPAAR

Location, Tax and Other Information

AssocFeeYN
No
Legal Description
SECTION 11 TOWN 30 RANGE 23 EX STH 49/126 THE N 177 FT OF S 467 FT OF GOVT LOT 6 IN SEC 11 TN 30 RN 23
Listing City
Shoreview
Map Page
80
Municipality
Shoreview
School District
Mounds View
School District Phone
651-621-6001
DNR Lake ID#
62006100
DNR Lake Classification
General Development
Zip Plus 4
1234
Property ID Number
113023140008
Tax Year
2025
Tax Amount
33935
In Foreclosure?
No
Potential Short Sale?
No
Lender Owned?
No

Directions & Remarks

Public Remarks
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.
Directions
Hwy 96 to Hodgson Road. North to home on the left.

Accessible

None
Yes

Air Conditioning

Central Air
Yes

Amenities Unit

Ceiling Fan(s)
Yes
Deck
Yes
Exercise Room
Yes
In-Ground Sprinkler
Yes
Kitchen Center Island
Yes
Kitchen Window
Yes
Paneled Doors
Yes
Primary Bedroom Walk-In Closet
Yes
Tile Floors
Yes
Vaulted Ceiling(s)
Yes
Walk-In Closet
Yes

Appliances

Air-To-Air Exchanger
Yes
Dishwasher
Yes
Disposal
Yes
Dryer
Yes
Freezer
Yes
Microwave
Yes
Range
Yes
Refrigerator
Yes
Washer
Yes
Water Filtration System
Yes

Basement

Drain Tiled
Yes
Poured Concrete
Yes
Sump Pump
Yes

Bath Description

Double Sink
Yes
Main Floor 1/2 Bath
Yes
Upper Level Full Bath
Yes
Full Primary
Yes
Private Primary
Yes
1/2 Basement
Yes
Full Basement
Yes
Separate Tub & Shower
Yes

Construction Status

Previously Owned
Yes

Dining Room Description

Informal Dining Room
Yes
Separate/Formal Dining Room
Yes

Exterior

Brick/Stone
Yes
Engineered Wood
Yes

Family Room Characteristics

Lower Level
Yes
Main Level
Yes

Fencing

None
Yes

Financing Terms

Conventional
Yes

Fireplace Characteristics

Family Room
Yes
Gas Burning
Yes
Living Room
Yes
Primary Bedroom
Yes
Other
Yes

Foundation

8 ft+ Pour
Yes

Fuel

Natural Gas
Yes

Heating

Forced Air
Yes
In-Floor Heating
Yes

Insurance Fee

Insurance Fee
0

Lake/Waterfront

Lake Front
Yes

Laundry

Laundry Room
Yes
Main Level
Yes
Sink
Yes

Lot Description

Accessible Shoreline
Yes
Tree Coverage - Heavy
Yes

Patio, Porch and Deck Features

Deck
Yes
Porch
Yes
Screened
Yes

Pool Description

None
Yes

Road Frontage

City Street
Yes

Roof

Age Over 8 Years
Yes
Shake
Yes

Sellers Terms

Cash
Yes
Conventional
Yes

Sewer

City Sewer/Connected
Yes

Special Search

3 BR on One Level
Yes
All Living Facilities on One Level
Yes
Main Floor Laundry
Yes
Main Floor Primary
Yes
Primary Bdr Suite
Yes

Stories

Two
Yes

Water

Private
Yes
Well
Yes

Room Information

Exercise Room Dimensions: 12x14 Level: Lower Recreation Room Dimensions: 20x30 Level: Lower Office Dimensions: 11x13 Level: Main Family Room Dimensions: 17x18 Level: Lower Family Room Dimensions: 13x20 Level: Main Second Kitchen Dimensions: 16x17 Level: Lower Fourth (4th) Bedroom Dimensions: 13x14 Level: Upper Third (3rd) Bedroom Dimensions: 13x16 Level: Upper Fifth (5th) Bedroom Dimensions: 14x17 Level: Lower Kitchen Dimensions: 18x22 Level: Main Second (2nd) Bedroom Dimensions: 13x14 Level: Upper First (1st) Bedroom Dimensions: 17x18 Level: Main Dining Room Dimensions: 12x14 Level: Main Living Room Dimensions: 16x19 Level: Main
Listing Office: Edina Realty, Inc.
IDX
Last Updated: August - 18 - 2025
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. ©2024 Regional Multiple Listing Service of Minnesota, Inc All rights reserved.