Bridge Realty
Veterans United Homefront
70 Photos

5315 Hodgson Road, Shoreview, MN 55126

$3,495,000 Asking Price

5 beds
5 baths
6,140  sqft
Built in 1997

Rare opportunity to own a private, scenic and resort style estate on Turtle Lake in Shoreview. Very private 3.6+ acre setting ,177 feet of pristine sandy shoreline & west facing for postcard sunsets. 6100+ sqft, 5+ bedrooms, 5 bathrooms, main floor executive office with custom built-ins & exercise room. 3+ heated garage with epoxy floors, meticulously maintained park like yard & gardens. Wonderful outdoor living areas with deck, patio, screen porch & firepit area. Main level owner’s suite with private bath. Soaring vaulted ceilings & large windows for lots of natural light & picturesque lake views. Updated with high end finishes top to bottom. Gourmet kitchen with high end appliances (Wolfe, Subzero & Lacanche), hand scraped European wood floors, ship lapped ceilings. Amazing lower-level entertainment area with horseshoe bar, kitchen & game room. You will have a lifetime of entertaining and making memories in this resort-style home. Move in ready… THINK SUMMER 2024!!


Listing Status:
Active
Date Added:
February 2, 2024 — 105 days ago
Listing Office:
Coldwell Banker Realty
Office Phone:
651-483-1200
MLS ID:
6484409

Features & Amenities

Interior

Rooms:
Living Room, Dining Room, Family Room, Kitchen, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Office, Recreation Room, Kitchen- 2nd, Informal Dining Room, Exercise Room
Master Bath:
Two Basement Baths,Full Primary,Main Floor 1/2 Bath,Main Floor Full Bath,Upper Level Full Bath
Appliances:
Dishwasher, Disposal, Exhaust Fan, Water Filtration System, Range, Refrigerator
Dining:
Breakfast Area,Eat In Kitchen,Informal Dining Room,Separate/Formal Dining Room
Basement:
Finished, Full
A/C:
Central Air
Heating:
Forced Air
Fireplace:
Amusement Room, Family Room, Living Room, Fireplace, Fireplaces: 3

Exterior

Parking:
Asphalt, Garage Door Opener, Heated Garage, Insulated Garage

Construction

Roofing:
Shake, Age Over 8 Years
General:
Two

Location

Road/Access:
City Street
HOA Amenities:
0.0
Originating MLS:
northstar
School District:
Mounds View
County:
Ramsey

Lot

Zoning:
113023140008
View:
Lake, West
Waterfront:
177

Utilities

Water:
Private,Well
Sewer:
City Sewer/Connected

Financial

Source:
northstar
Listing Agent Compensation:
0.0000 %
Buyers Agent Compensation:
2.70 %

This listing courtesy of:
Coldwell Banker Realty

About Saint Paul, MN

Housing

Number of Units
349,531
Median Home Value
$277,855
Median Rent
$1,059

36.15% of housing units are renter occupied.

4.06% are vacant.

Commute

Car
62.84%
Public Transportation
3.99%
Walk to Work
1.67%
Work from Home
30.51%
Other
0.47%

The median travel time to work is 18 minutes.

People

Population
818,272
Median Age
37.40
Median Household Size
2.67

Education

High School
19.32%
Associate’s Degree
9.12%
Bachelor’s Degree
28.18%
Graduate Degree
17.52%

Disclaimer: Community and Demographic information uses data from the U.S. Census Bureau but is not endorsed or certified by the Census Bureau.

Veterans United Homefront

IDX Broker Reciprocity Copyright © 2024 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved.

By searching, you agree to the EULA Terms Agreement.

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 this broker are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Some or all of the property listings above may have been submitted to the Regional Multiple Listing Service (RMLS) by the listing broker for distribution to cooperating brokers through Broker reciprocity. Attribution of the listing broker may be found on the detail page for all properties. The broker providing these data believes them to be correct, but advises interested parties to confirm them before relying on them in a purchase decision.

Any use of search facilities of data on this site, other than by a consumer looking to purchase real estate, is prohibited. No part of this search utility may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise. Home sale information is not an appraisal, competitive or comparative market analysis, CMA or home valuation.

DMCA Data displayed may be a portion of, and not a complete set of all listings published in the MLS. The listing broker's offer of compensation is made only to participants of the MLS where the listing is filed. Last Updated: May 16, 2024 2:39 pm.

Copyright © 2024 Bridge Realty and Did You Serve, LLC. Homefront.com is NOT affiliated with any government agencies, including the VA. Homefront.com is a service of Did You Serve, LLC. Veterans United and the Veterans United House logo are registered trademarks of Mortgage Research Center, LLC, used under license agreement. Terms of Use.

Message

Interested in this home?

Request more information: