Lake Homes Realty
Enter City or Zip

5315 hodgson road

Shoreview, MN 55126

$3,200,000

5 BEDS 5 BATHS
6,125 SQFT3.67 AC LOT
Residential - Single Family
Waterfront
Image 1
Image 2
Image 3
Image 4
Bedrooms 5
Total Baths 5
Full Baths 3
Square Feet 6125
Acreage 3.67
Status Active
MLS # 6648237
County Ramsey
More Info
Category Residential - Single Family
Status Active
Square Feet 6125
Acreage 3.67
MLS # 6648237
County Ramsey
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.
Location not available

Exterior Features

  • Construction Single Family Residence
  • Siding Brick/Stone, Engineered Wood
  • Roof Shake, Age Over 8 Years
  • Garage Yes
  • Garage Description Attached Garage, Asphalt, Heated Garage, Insulated Garage
  • Water Private, Well
  • Sewer City Sewer/Connected
  • Lot Dimensions 177x250
  • Lot Description Accessible Shoreline, Many Trees

Interior Features

  • Appliances Air-To-Air Exchanger, Dishwasher, Disposal, Dryer, Exhaust Fan, Freezer, Humidifier, Water Filtration System, Microwave, Range, Refrigerator, Stainless Steel Appliances, Washer, Water Softener Owned
  • Heating Forced Air, Fireplace(s), Radiant Floor
  • Cooling Central Air
  • Basement Drain Tiled, Finished, Concrete, Sump Pump, Walkout
  • Fireplaces 1
  • Fireplaces Description Family Room, Gas, Living Room, Primary Bedroom, Other
  • Living Area 6,125 SQFT
  • Year Built 1997

Neighborhood & Schools

  • Subdivision Section 11 Town 30 Range 23

Financial Information

  • Parcel ID 113023140008
  • Zoning Residential-Single Family

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of Edina Realty, Inc. - (651) 483-8500
Listings provided courtesy of the Northstar MLS as distributed by MLS GRID.

Information is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant's applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.

Based on information submitted to the MLS GRID as of 07/02/2025 12:03:44 UTC. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Regional Multiple Listing Service of Minnesota, Inc. Real estate listings held by brokerage firms other than Lake Homes Realty are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (little black house) and detailed information about them includes the name of the listing brokers.
Copyright 2025 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved. By searching Northstar MLS listings you agree to the Northstar MLS End User License Agreement.
Listing data is current as of 07/02/2025.

Contact our Agent !

By clicking “Submit”, you agree that Lake Homes Realty, its affiliates, and real estate professionals may contact you by phone, text, or email to any phone number and email address you provided, including by automated means, even if your number is on a federal, state, or our internal Do Not Call list. You also agree to our Terms of Use and Privacy Policy.