Bay Lake Realty
Bruce Johnson
Broker/Owner
Bay Lake Realty is Licensed in the State of Minnesota
15929 Wakeman Rd.
Deerwood, MN 56444
Cell Phone: 218-838-1111
E-mail: bruce@baylakerealty.com
{"Id":1399601,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6777307","MLSAGENTID":"NST506015936","MLSOFFICEID":"NST8205","ADDRESS":"47 Juniper Street","ACRES":0.13,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block","BATHSTOTAL":3.0,"BEDROOMS":4,"CITY":"Mahtomedi","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":260000.0,"LASTPRICEDATE":"2025-08-23T16:12:03.45","LATITUDE":45.067726,"LENDEROWNED":"No","LISTDATE":"2025-08-23T05:00:00","LISTPRICE":260000.0,"LIVINGAREA":2008.0,"LONGITUDE":-92.960458,"MODIFICATIONTIMESTAMP":"2025-08-23T17:53:03.648","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":16,"POSTALCODE":"55115","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"NO HOA OR RESTRICTIONS. This twin home nestled just a stone's throw away from the tranquil shores of White Bear Lake! The spacious 4-bedroom, 3-bathroom residence is perfect for those who enjoy the lake. Located within the highly sought-after Mahtomedi School District. Highlights of this fantastic home include: New Roof and Steel Siding (2024) plus a fairly new boiler. Generously Sized Bedrooms with the flexibility to utilize one of the bedrooms as a home office or playroom. With a little love, you can make this home truly your own. Don’t miss this incredible opportunity to live in a fantastic location close to local beaches, parks, and community amenities. Schedule a viewing today and experience all that this charming twin home has to offer!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"832-Mahtomedi","SCHOOLDISTRICTPHONE":"651-407-2001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-23T16:12:03.45","LASTSTATUS":"Active","STREETNAME":"Juniper","STREETNUMBER":"47","STREETSUFFIX":"Street","STYLE":"Townhouse Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1960,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-23T17:53:03.648","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Exterior\"},{\"Order\":2,\"Remarks\":\"Exterior\"},{\"Order\":3,\"Remarks\":\"Living room\"},{\"Order\":4,\"Remarks\":\"Living room\"},{\"Order\":5,\"Remarks\":\"Kitchen\"},{\"Order\":6,\"Remarks\":\"Primary bedroom\"},{\"Order\":7,\"Remarks\":\"2nd bedroom\"},{\"Order\":8,\"Remarks\":\"3rd Bedroom\"},{\"Order\":9,\"Remarks\":\"en suite\"},{\"Order\":10,\"Remarks\":\"4th Bedroom\"},{\"Order\":11,\"Remarks\":\"4th Bedroom\"},{\"Order\":12,\"Remarks\":\"Aerial view\"},{\"Order\":13,\"Remarks\":\"Aerial View\"},{\"Order\":14,\"Remarks\":\"White Bear Lake\"},{\"Order\":15,\"Remarks\":\"47.jpg\"},{\"Order\":16,\"Remarks\":\"exterior\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","SOURCE":"MG_NST"}
{"ListingKey":"NST7792491","LotSizeArea":"0.13","NST_AgeOfProperty":"65","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Deck","Appliances":"Dishwasher,Refrigerator,Stainless Steel Appliances","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"True","NST_AttributionContact":"651-336-9218","NST_AttributionName":"Peter Salazar III","Basement":"Block","BasementYN":"True","NST_BathDesc":"1/2 Basement,3/4 Primary,Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"4","City":"Mahtomedi","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Window Unit(s)","CountyOrParish":"Washington","NST_DiningRoomDescription":"Eat In Kitchen","Directions":"694 to Century-East to 244 (Mahtomedi Ave) North to Juniper-West towards Lake","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"100 Amp Service","ConstructionMaterials":"Vinyl Siding","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"2236","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Asphalt,Tuckunder Garage","NST_GarageDimensions":"10x20","NST_GarageDoorHeight":"7","NST_GarageDoorWidth":"9","NST_GarageSquareFeet":"200","AccessibilityFeatures":"None","Heating":"Baseboard,Boiler","OriginalEntryTimestamp":"2025-08-23T16:10:34Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-23","Latitude":"45.067726","NST_LenderOwned":"No","ListAgentKey":"NST113407","ListAgentMlsId":"NST506015936","ListingContractDate":"2025-08-23T05:00:00Z","ListOfficeKey":"NST16457","ListOfficeName":"Coldwell Banker Realty","ListOfficeMlsId":"NST8205","ListPrice":"260000","LivingArea":"2008","Longitude":"-92.960458","LotSizeDimensions":"104x50x117x52","LotSizeSquareFeet":"5532.12","LotSizeUnits":"Acres","ListingId":"NST6777307","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"2003021330090","GarageSpaces":"1","NST_ParkingOpen":"2","PhotosCount":"16","PostalCity":"Saint Paul","PostalCode":"55115","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"NO HOA OR RESTRICTIONS. This twin home nestled just a stone's throw away from the tranquil shores of White Bear Lake! The spacious 4-bedroom, 3-bathroom residence is perfect for those who enjoy the lake. Located within the highly sought-after Mahtomedi School District. Highlights of this fantastic home include: New Roof and Steel Siding (2024) plus a fairly new boiler. Generously Sized Bedrooms with the flexibility to utilize one of the bedrooms as a home office or playroom. With a little love, you can make this home truly your own. Don’t miss this incredible opportunity to live in a fantastic location close to local beaches, parks, and community amenities. Schedule a viewing today and experience all that this charming twin home has to offer!","PublicSurveyRange":"21","PublicSurveySection":"20","PublicSurveyTownship":"30","NST_RentalLicenseYN":"No","NST_Restrictions":"None","Roof":"Age 8 Years or Less","RoomType":"Living Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4","NST_AboveGradeSqFtTotal":"1508.0000","NST_BelowGradeSqFtTotal":"528.0000","NST_MainLevelFinishedArea":"1508.0000","BuildingAreaTotal":"2036","HighSchoolDistrict":"Mahtomedi","NST_SchoolDistrictNumber":"832","NST_SchoolDistrictPhone":"651-407-2001","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level","AboveGradeFinishedArea":"1508","BelowGradeFinishedArea":"500","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Juniper","StreetNumber":"47","StreetNumberNumeric":"47","StreetSuffix":"Street","PropertySubType":"Townhouse Side x Side","SubdivisionName":"Cic 137","NST_TaxWithAssessments":"5372.0000","TaxYear":"2025","TaxAnnualAmount":"5372","WaterSource":"City Water/Connected","YearBuilt":"1960","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-23T17:53:03.648Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7792491\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Exterior\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/8f9e4199-69e9-4b30-ae7a-09234b63bad7.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:23:31.811Z\",\"MediaKey\":\"68a9f91369f7f96b009a1ef3\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Exterior\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/2f86a64f-b7cf-4574-bf63-14f5f626a52c.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:23:31.855Z\",\"MediaKey\":\"68a9f91369f7f96b009a1ee8\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Living room\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/830686c9-526b-4cb1-a5c1-a7c3066ce3c7.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:34:32.432Z\",\"MediaKey\":\"68a9fba8a31b247758849122\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Living room\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/2f791a6f-b1a4-43e6-8e9d-cb322e26f619.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:34:32.474Z\",\"MediaKey\":\"68a9fba8a31b247758849121\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Kitchen\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/e9624e3b-4d31-42b7-9bee-a82f0705827a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:34:32.426Z\",\"MediaKey\":\"68a9fba8a31b247758849123\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Primary bedroom\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/81953fe1-108f-44ec-b5a5-b714fc169f70.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:46:20.597Z\",\"MediaKey\":\"68a9fe6c8f8c1a754e74e521\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"2nd bedroom\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/942b2bd2-dbc4-431f-b29c-5c6b31777d7f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:46:20.619Z\",\"MediaKey\":\"68a9fe6c8f8c1a754e74e522\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"3rd Bedroom\",\"ImageWidth\":2080,\"ImageHeight\":1601,\"ImageSizeDescription\":\"2080x1601\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/860ea6ee-dd1d-4ca2-91aa-d06cb81004e7.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:23:31.836Z\",\"MediaKey\":\"68a9f91369f7f96b009a1eef\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"en suite\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/f2b9eed3-6200-44d2-8057-0fa40a2cf577.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:34:32.464Z\",\"MediaKey\":\"68a9fba8a31b247758849124\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"4th Bedroom\",\"ImageWidth\":975,\"ImageHeight\":839,\"ImageSizeDescription\":\"975x839\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/0261563f-0f66-40e9-ab43-9473cbb002ac.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:23:31.832Z\",\"MediaKey\":\"68a9f91369f7f96b009a1ef1\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"4th Bedroom\",\"ImageWidth\":1011,\"ImageHeight\":839,\"ImageSizeDescription\":\"1011x839\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/31f7b93a-51fa-47be-9373-49b23e5e484a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:23:31.778Z\",\"MediaKey\":\"68a9f91369f7f96b009a1ef2\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"Aerial view\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/2cfbcd67-87df-421d-a3d6-8287ef65925b.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:23:31.865Z\",\"MediaKey\":\"68a9f91369f7f96b009a1ef4\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"Aerial View\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/4c82f5ac-9b5d-4c82-9c04-38fc26d9fdc0.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:23:31.833Z\",\"MediaKey\":\"68a9f91369f7f96b009a1ef5\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"White Bear Lake\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/5686fc2b-b19b-4ae8-8b18-75ee0c06e0ab.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:23:31.851Z\",\"MediaKey\":\"68a9f91369f7f96b009a1ef6\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"47.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/8f4020f8-daa4-4918-81f4-3e0631ae3e97.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:23:31.815Z\",\"MediaKey\":\"68a9f91369f7f96b009a1ef7\"},{\"ResourceRecordKey\":\"NST7792491\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"exterior\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792491/917a1f10-ee51-4528-9a6a-b5e56bd2ff43.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T17:34:32.426Z\",\"MediaKey\":\"68a9fba8a31b247758849125\"}]","PhotosChangeTimestamp":"2025-08-23T17:53:03.648Z","Rooms":"[{\"RoomKey\":\"NST115546092\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x14\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115546093\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115546094\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115546095\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115546096\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x9\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115546097\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"18x13\",\"NST_RoomSortOrder\":\"6\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Exterior\"},{\"Order\":2,\"Remarks\":\"Exterior\"},{\"Order\":3,\"Remarks\":\"Living room\"},{\"Order\":4,\"Remarks\":\"Living room\"},{\"Order\":5,\"Remarks\":\"Kitchen\"},{\"Order\":6,\"Remarks\":\"Primary bedroom\"},{\"Order\":7,\"Remarks\":\"2nd bedroom\"},{\"Order\":8,\"Remarks\":\"3rd Bedroom\"},{\"Order\":9,\"Remarks\":\"en suite\"},{\"Order\":10,\"Remarks\":\"4th Bedroom\"},{\"Order\":11,\"Remarks\":\"4th Bedroom\"},{\"Order\":12,\"Remarks\":\"Aerial view\"},{\"Order\":13,\"Remarks\":\"Aerial View\"},{\"Order\":14,\"Remarks\":\"White Bear Lake\"},{\"Order\":15,\"Remarks\":\"47.jpg\"},{\"Order\":16,\"Remarks\":\"exterior\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","CustomVTourURL":""}