5315 Hodgson Road, Shoreview, MN 55126 (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