mike@minnesotarealestatesales.com
Phone: 218-821-4775
- Mille Lacs Lake Homes
- Mille Lacs Lake Lots
- Newest Listings
- Aitkin County
- Crow Wing County
- Mille Lacs County
- Estimate Request
- About Team
- Sellers
- Buyers
- Daily Hotsheets
- DNR Lake Information
- Best Mille Lacs Lake Resorts
Contact me here...
$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Coldwell Banker Realty is the brokerage office representing the seller for this listing.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this 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 are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this 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 are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":589227,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7108120","MLSAGENTID":"NST506096678","MLSOFFICEID":"NST8230","ADDRESS":"5059 Alameda Street","ACRES":0.409,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Partially Finished,Walkout","BATHSTOTAL":2.0,"BEDROOMS":2.0,"CITY":"Shoreview","CONTINGENCY":"Inspection","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LAKEACRES":450.02,"LAKEDEPTH":"28","LAKEWATERFRONT":"Lake Front","LASTPRICE":825000.0,"LASTPRICEDATE":"2026-07-22T14:13:07.47","LATITUDE":45.094271,"LENDEROWNED":"No","LISTDATE":"2026-07-22T05:00:00","LISTPRICE":825000.0,"LIVINGAREA":2204.0,"LONGITUDE":-93.130627,"LOTDESCRIPTION":"Tree Coverage - Heavy","MODIFICATIONTIMESTAMP":"2026-07-22T14:18:07.52","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":17,"POSTALCODE":"55126","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Unique Turtle Lake home with wonderful west facing sunset views. Perfect urban cabin in the cities.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"621-Mounds View","SCHOOLDISTRICTPHONE":"6516216001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-07-22T14:13:07.47","LASTSTATUS":"Active","STREETNAME":"Alameda","STREETNUMBER":"5059","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"Private","WATERFRONTNAME":"Turtle","WATERFRONTNUM":"62006100","WATERFRONTPRESENT":true,"WATERFRONTVIEW":"Lake Front","YEARBUILT":1965,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-07-22T14:16:09.562","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7933348","NST_AboveGradeSqFtTotal":"1528","AboveGradeFinishedArea":"1528","AccessibilityFeatures":"Other","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Natural Woodwork,Vaulted Ceiling(s)","Appliances":"Gas Water Heater,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","AttributionContact":"6518950916","NST_AttributionName":"Guy R. Nelson","Basement":"Finished,Partially Finished,Walkout","BasementYN":"True","NST_BathDesc":"3/4 Basement,Main Floor 3/4 Bath","BathroomsFull":"0","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"2","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"800","BelowGradeFinishedArea":"676","CumulativeDaysOnMarket":"0","City":"Shoreview","NewConstructionYN":"False","Contingency":"Inspection","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Informal Dining Room,Kitchen/Dining Room","Directions":"Hodgson to Birch to Alameda","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-07-22T14:08:10.123Z","DaysOnMarket":"0","ExteriorFeatures":"Wood","FireplaceFeatures":"Gas,Living Room","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1371","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"775","NST_GarageDimensions":"31x25","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Mounds View","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.094271","LaundryFeatures":"Main Level","NST_LenderOwned":"No","Levels":"Two","ListPrice":"825000","ListingContractDate":"2026-07-22T05:00:00Z","ListingId":"NST7108120","LivingArea":"2204","LockBoxType":"Supra","Longitude":"-93.130627","LotFeatures":"Tree Coverage - Heavy","LotSizeArea":"0.409","LotSizeDimensions":"68x262","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1371","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-07-22T09:07:14Z","ParcelNumber":"113023440030","ParkingFeatures":"Attached Garage,Asphalt,Finished Garage","PhotosCount":"17","PhotosChangeTimestamp":"2026-07-22T14:16:09.562Z","PostalCity":"Saint Paul","PostalCode":"55126","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Unique Turtle Lake home with wonderful west facing sunset views. Perfect urban cabin in the cities.","PublicSurveyRange":"23","PublicSurveySection":"11","PublicSurveyTownship":"30","RoadFrontageType":"City Street","Roof":"Asphalt","NST_SchoolDistrictFullName":"621 - Mounds View","NST_SchoolDistrictNumber":"621","NST_SchoolDistrictPhone":"6516216001","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Main Floor Laundry","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Alameda","StreetNumber":"5059","StreetNumberNumeric":"5059","StreetSuffix":"Street","SubdivisionName":"Birch Lane, Ramsey Co, Minn","TaxAnnualAmount":"15276","NST_TaxWithAssessments":"0","TaxYear":"2025","NST_TotalArea":"2328","BuildingAreaTotal":"2328","Township":"Shoreview","VideosCount":"0","WaterSource":"Private","WaterfrontFeatures":"Lake Front","WaterfrontYN":"True","YearBuilt":"1965","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST65855","ListAgentMlsId":"NST506096678","ListOfficeMlsId":"NST8230","ListOfficeName":"Coldwell Banker Realty","ListOfficeKey":"NST16459","ModificationTimestamp":"2026-07-22T14:18:07.52Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/c3324192-9549-4e8e-a4db-ee4a7a76b305.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.601Z\",\"MediaKey\":\"NST123753042\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/c874c2e2-1625-4f7e-bce3-99d05f35661a.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.614Z\",\"MediaKey\":\"NST123753288\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/5d6a13e6-8ab0-4ad1-a40f-27da72a7b8b9.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.649Z\",\"MediaKey\":\"NST123753059\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/fdb6989f-e583-40ee-8228-ea8755374df7.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.601Z\",\"MediaKey\":\"NST123753105\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/bc34248e-b79b-4c23-a5da-da6fa3f8fb7f.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.646Z\",\"MediaKey\":\"NST123753267\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/871b3fbc-bce6-4305-9a60-04c38249f845.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.626Z\",\"MediaKey\":\"NST123753112\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/0214960f-a6a5-4715-a293-b894e6f0f71e.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.629Z\",\"MediaKey\":\"NST123753107\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/7445a879-96b9-4337-94ec-88ad135e46bf.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.627Z\",\"MediaKey\":\"NST123753118\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/8328f507-6c47-4d97-a1e3-e4f20fe1631b.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.617Z\",\"MediaKey\":\"NST123753265\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/cc3f891f-3210-4b6f-9bfc-b302f81980c7.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.626Z\",\"MediaKey\":\"NST123753275\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/b7a415c6-2729-4961-a664-3edeac4c092f.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.612Z\",\"MediaKey\":\"NST123753113\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/8a6a14ae-a62b-41fb-a178-53925ac8e175.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:14:05.807Z\",\"MediaKey\":\"NST123753038\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/c1ecbb26-8751-4642-91d8-7599ae7a8d1c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.634Z\",\"MediaKey\":\"NST123753187\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/3f7ebdc7-e7d1-4a9a-b724-bb80b60583bf.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.673Z\",\"MediaKey\":\"NST123753020\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/9b6d5039-1d3a-4dfe-8433-556a05a5942d.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.692Z\",\"MediaKey\":\"NST123753022\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/d48f07ba-fbd9-47fe-98ac-a7ff83f3bfd0.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.638Z\",\"MediaKey\":\"NST123753035\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7933348\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7933348/285a04c5-121a-42e1-ba9c-03b634a4add3.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-22T14:15:20.672Z\",\"MediaKey\":\"NST123753019\"}]","Media__Order":"9","Media__MediaObjectID":"NST9","Media__ResourceRecordKey":"NST7933348","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7933348/c3324192-9549-4e8e-a4db-ee4a7a76b305.jpeg","Media__ImageWidth":"2080","Media__ImageHeight":"1386","Media__ImageSizeDescription":"2080x1386","Media__MediaModificationTimestamp":"7/22/2026 2:15:20 PM","Media__MediaKey":"NST123753042","BodyOfWater":"[{\"BodyOfWaterNumber\":\"62006100\",\"LakeDepth\":28,\"NST_LakeClass\":\"General Development\",\"LakeAcres\":450.02,\"NST_LakeChain\":\"N\",\"WaterBodyName\":\"Turtle\",\"WaterBodyKey\":\"106042\"}]","BodyOfWater__BodyOfWaterNumber":"62006100","BodyOfWater__LakeDepth":"28","BodyOfWater__NST_LakeClass":"General Development","BodyOfWater__LakeAcres":"450.02","BodyOfWater__NST_LakeChain":"N","BodyOfWater__WaterBodyName":"Turtle","BodyOfWater__WaterBodyKey":"106042","Rooms":"[{\"RoomDimensions\":\"18x10\",\"RoomKey\":\"NST116449707\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":6},{\"RoomDimensions\":\"9x16\",\"RoomKey\":\"NST116449703\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2},{\"RoomDimensions\":\"13x10\",\"RoomKey\":\"NST116449705\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":4},{\"RoomDimensions\":\"6x4\",\"RoomKey\":\"NST116449708\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":7},{\"RoomDimensions\":\"23x18\",\"RoomKey\":\"NST116449702\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1},{\"RoomDimensions\":\"10x14\",\"RoomKey\":\"NST116449709\",\"RoomType\":\"Loft\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":8},{\"RoomDimensions\":\"9x11\",\"RoomKey\":\"NST116449704\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3},{\"RoomDimensions\":\"10x10\",\"RoomKey\":\"NST116449706\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":5}]","Rooms__RoomDimensions":"18x10","Rooms__RoomKey":"NST116449707","Rooms__RoomType":"Family Room","Rooms__RoomLevel":"Lower","Rooms__NST_RoomSortOrder":"6","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}
$MLSDESCRIPTION$
5059 Alameda Street Shoreview, MN 55126
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
5059 Alameda Street Shoreview, MN 55126
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$