Find Your Dream Home: Search 10,000+ Homes for Sale

5315 Hodgson Road, Shoreview, MN 55126

$2,900,000

Welcome to lakeside luxury on prestigious Turtle Lake—this exceptional 6,000+ sq ft estate sits on 3.6 private acres with 177 feet of pristine sandy shoreline, offering unmatched serenity and elegance.

Virtual Tour

https://wellcomemat.com/embed/54sn479ad9f21m4qg?mls=1

177' of hard prime sand on this west facing lot- perfect for incredible sunsets.

Grab the ropes, start up the boat and get ready for fun this summer on the lake.

Enjoy your favorite beverage at the end of the day while watching the sunset.

Play water volleyball, swim with family and friends and host parties all summer.

Grab the kayaks and paddleboards and go out for a morning paddle around the lake. The cleanest lake in Ramsey County!

Sundrenched living room with expansive walls of windows offers stunning views of Turtle Lake—an unforgettable first impression the moment you step inside.

Stunning living room with a wall of windows showcasing breathtaking Turtle Lake views. Postcard worthy sunsets every night.

Beautiful living room featuring a wall of windows with panoramic lake views, custom built-ins, and a gas-burning fireplace for cozy yet elegant living.

From the living room, enjoy a stunning view back toward the formal dining room, grand foyer and executive office—an open, flowing layout perfect for both everyday living and elegant entertaining.

Elegant gas fireplace flanked by custom built-ins anchors the living room, while expansive windows frame spectacular views of Turtle Lake.

Spectacular, fully updated kitchen featuring custom cabinetry, premium countertops, Wolfe, LaCanche, and SubZero appliances, and hand-scraped French oak floors—luxury and function in perfect harmony.

Expansive center island offers seating for casual meals, morning coffee, or reading the paper—surrounded by extensive countertops and abundant custom cabinetry.

Incredible kitchen seamlessly flows into the cozy hearth room, featuring a floor-to-ceiling gas fireplace and walls of windows that offer serene lake views and direct access to the oversized deck.

Updated kitchen with hand-scraped French oak floors, fresh paint, modern light fixtures, and breathtaking views of Turtle Lake. Large center island perfect for buffet style entertaining and casual conversation.

Large center island with seating for breakfast, reading the paper or enjoying your morning coffee. Invite family and friends to help prepare the meal around this gathering spot.

Walls of windows create the feeling of being on the bow of a boat, offering panoramic views of the tranquil and fun waters of Turtle Lake.

Large patio doors open seamlessly to the oversized deck, making al fresco entertaining effortless while enjoying lakefront living at its finest.

Spacious, oversized deck with multiple areas designed for relaxation—whether you're dining, enjoying casual conversation, or soaking up the sun, this outdoor space is perfect for every occasion.

From the deck, take in the expansive park-like yard, offering lush greenery and plenty of space for outdoor activities and relaxation.

Open and airy view from the hearth room toward the kitchen, dinette, and living room—an incredible floor plan designed for seamless entertaining and effortless flow.

Spacious dining room, conveniently located near the kitchen, is perfect for more formal entertaining. Host your next holiday gathering in this elegant space overlooking the beautiful yard.

Main floor owner's suite with breathtaking lake views, custom built-ins, and freshly updated with new carpet and paint—your private retreat awaits.

Custom built-ins and a gas fireplace add warmth and charm to the owner's suite, creating the perfect ambiance for cozy winter nights by the lake.

Indulge in relaxation in this oversized primary bathroom, featuring a separate bath and shower, along with double sinks for effortless preparation—perfect for your morning routine.

Enjoy tranquil views of the private/treed yard through the window over the soaking tub—your own private oasis for relaxation and reflection.

Main floor executive office with custom built-ins, a serene view of the yard, and French doors—perfect for quiet conversations or focused work.

Grand staircase leads upstairs to three spacious bedrooms, a bathroom, and a loft- new carpet and fresh paint. A large catwalk offers stunning views of the lake, enhancing the home's open, airy feel.

Breathtaking view from the upper level overlooking the catwalk and soaring two-story living room—framed by walls of windows with panoramic views of Turtle Lake.

One of three spacious bedrooms upstairs with all new carpet, paint and light fixture.

Spacious bedroom featuring a walk-in closet and stunning lake views—also has new carpet, paint and light fixture.

Oversized full bathroom with double sinks and a separate tub/commode area—ideal for multiple people getting ready at once, offering both convenience and privacy.

The third of three spacious bedrooms on the upper floor, featuring a large walk-in closet, new carpet, fresh paint, and an updated light fixture—perfect for comfort and style.

Wow! An incredible horseshoe bar in the lower level, perfect for hosting large parties and gatherings—an entertainer's dream come true. Easily host six people around the bar and more room for those standing.

Invite the team over for a carbo load, host Fourth of July or just watch the big game in this incredible space.

Lower-level family room with stunning lake views—ideal for watching the big game or your favorite movie, creating a cozy yet expansive space for relaxation.

From the family room, enjoy the open layout leading to the card playing area and large horseshoe bar—perfect for entertaining and casual gatherings.

Grab a group of friends and plan poker night while enjoying the warmth and coziness of the family room and bar area—perfect for memorable nights in.

Cozy up to the fireplace in the lower-level hearth room on cold winter nights. Double patio doors provide easy access to the outdoors.

Incredible screened porch with breathtaking lake views—perfect for a nap, reading a book, or enjoying a chat with a friend. This will be your summer destination spot.

Another stunning view of the screened porch, where you can unwind and enjoy the serene beauty of the lake—your private sanctuary for relaxation and tranquility.

View from the lower-level hearth area looking toward the pool table, half bathroom, and bar—creating a perfect flow for both relaxation and entertainment. Heated floors provide for warm toes all winter!

Billiards area with heated floors throughout the lower level—game night just got a whole lot more fun and comfortable.

Another angle of the billiards area, with a seamless view into the family room and bar area—each space perfectly positioned to take in stunning lake views.

Charming phone booth bathroom—perfectly sized for guests and lake visitors, offering a unique and functional touch.

Lower-level bedroom with beautiful lake views, a spacious walk-in closet, and convenient access to the full bathroom- perfect for older family members and guests.

No need for a gym membership with this well-equipped exercise room featuring cork flooring and plenty of space to move around, plus a large storage closet for added convenience.

Beautiful park-like yard with views of the home’s stunning exterior, patio, deck, and screened porch—complete with a meandering trail leading down to the lake for the ultimate in outdoor living.

Extensive landscaping, a cozy firepit area, and more enhance the estate-like quality of this home and property, located on the cleanest lake in Ramsey County for the ultimate in lakeside living.

Hard sand bottom with lots of room to play in the water and a gentle drop for waterskiing off the dock.

Additional flat yard space perfect for kicking a ball, throwing a pitch, or playing a game of bags—enjoy beautiful green space throughout this expansive property.

Ideal setting on Turtle Lake, west facing for sunsets, hard sand bottom, perfect drop off for water sports and more.

Storybook charm and updates galore make this home move-in ready.

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
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; 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

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

Fuel

Natural Gas: Yes

Heating

Forced Air: Yes
In-Floor Heating: Yes

Insurance Fee

Insurance Fee: 0

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

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

Listing Office: Edina Realty, Inc.

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.