$2,900,000
    5315 Hodgson Road
    Shoreview, MN 55126
    MLS# 6648237
    Status: Closed
    5 beds  |  5 baths  |  6413 sqft
    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.
      1 / 57  
    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. 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. 3.6 + acres of parklike yard. 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. 5315 Hodgson Road Floor Plan-1.jpg 5315 Hodgson Road Floor Plan-2.jpg 5315 Hodgson Road Floor Plan-3.jpg

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

    Details
    Maps
    Contract Information
    Owner is an Agent?: No
    Auction?: No
    Status: Closed
    Off Market Date: 2025-07-24
    Contingency: None
    Current Price: $2,900,000
    Closed Date: 2025-08-18
    Original List Price: 3200000
    Sales Close Price: 2900000
    ListPrice: 3200000
    List Date: 2025-05-08
    Office/Member Info
    Association: SPAAR
    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
    Lot Dimensions: 177x250
    Acres: 3.67
    Bath Three Quarters: 0
    Bath Half: 2
    Lake/Waterfront Name: Turtle
    Bath Quarter: 0
    Main Floor Total SqFt: 2624
    Above Grd Total SqFt: 3789
    Below Grd Total SqFt: 2624
    Total Finished Sqft: 6125.00
    FireplaceYN: Yes
    Foundation Size: 2624
    Style: (SF) Single Family
    Garage Stalls: 3
    Power Company: Xcel Energy
    Association Fee: 0
    Bedrooms: 5
    Baths Total: 5
    Bath Full: 3
    Total SqFt: 6413
    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: 1
    Air Conditioning
    Central Air: 1
    Amenities Unit
    Ceiling Fan(s): 1
    Deck: 1
    Exercise Room: 1
    In-Ground Sprinkler: 1
    Kitchen Center Island: 1
    Kitchen Window: 1
    Paneled Doors: 1
    Primary Bedroom Walk-In Closet: 1
    Tile Floors: 1
    Vaulted Ceiling(s): 1
    Walk-In Closet: 1
    Appliances
    Air-To-Air Exchanger: 1
    Dishwasher: 1
    Disposal: 1
    Dryer: 1
    Freezer: 1
    Microwave: 1
    Range: 1
    Refrigerator: 1
    Washer: 1
    Water Filtration System: 1
    Assessments
    Assessment Balance: 105
    Tax With Assessments: 34040
    Basement
    Drain Tiled: 1
    Sump Pump: 1
    Bath Description
    Double Sink: 1
    Main Floor 1/2 Bath: 1
    Upper Level Full Bath: 1
    Full Primary: 1
    Private Primary: 1
    1/2 Basement: 1
    Full Basement: 1
    Separate Tub & Shower: 1
    Building Information
    Finished SqFt Above Ground: 3789
    Finished SqFt Below Ground: 2336
    Construction Status
    Previously Owned: 1
    Dining Room Description
    Informal Dining Room: 1
    Separate/Formal Dining Room: 1
    Exterior
    Brick/Stone: 1
    Engineered Wood: 1
    Family Room Characteristics
    Lower Level: 1
    Main Level: 1
    Fencing
    None: 1
    Financing Terms
    Conventional: 1
    Fireplace Characteristics
    Family Room: 1
    Gas Burning: 1
    Living Room: 1
    Primary Bedroom: 1
    Other: 1
    Fuel
    Natural Gas: 1
    Heating
    Forced Air: 1
    In-Floor Heating: 1
    Insurance Fee
    Insurance Fee: 0
    Lake Details
    Lake Acres: 450
    Lake Depth: 28
    Sand: 1
    Laundry
    Laundry Room: 1
    Main Level: 1
    Sink: 1
    Lease Details
    Land Leased: Not Applicable
    Lock Box Type
    Lock Box Source: SPAAR
    Supra: 1
    Lot Description
    Accessible Shoreline: 1
    Tree Coverage - Heavy: 1
    Miscellaneous Information
    Homestead: Yes
    Ownership
    Fractional Ownership: No
    Parking Characteristics
    Garage Dimensions: 35x26
    Garage Square Feet: 910
    Heated Garage: 1
    Insulated Garage: 1
    Patio, Porch and Deck Features
    Deck: 1
    Porch: 1
    Screened: 1
    Pool Description
    None: 1
    Public Survey Info
    Range#: 23
    Section#: 11
    Township#: 30
    Road Frontage
    City Street: 1
    Roof
    Age Over 8 Years: 1
    Shake: 1
    Sellers Terms
    Cash: 1
    Conventional: 1
    Sewer
    City Sewer/Connected: 1
    Special Search
    3 BR on One Level: 1
    All Living Facilities on One Level: 1
    Main Floor Laundry: 1
    Main Floor Primary: 1
    Primary Bdr Suite: 1
    Stories
    Two: 1
    Water
    Private: 1
    Well: 1
    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
    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
    Room Information
    Room Name Dimensions Level
    Exercise Room12x14Lower
    Recreation Room20x30Lower
    Office11x13Main
    Family Room17x18Lower
    Family Room13x20Main
    Second Kitchen16x17Lower
    Fourth (4th) Bedroom13x14Upper
    Third (3rd) Bedroom13x16Upper
    Fifth (5th) Bedroom14x17Lower
    Kitchen18x22Main
    Second (2nd) Bedroom13x14Upper
    First (1st) Bedroom17x18Main
    Dining Room12x14Main
    Living Room16x19Main
    IDX
    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.

    Search powered by FBS Products