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":1429843,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6815139","MLSAGENTID":"NST502018274","MLSOFFICEID":"NST253203","ADDRESS":"870 Sherwood Road","ACRES":0.09,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Finished,Full","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Shoreview","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":279000.0,"LASTPRICEDATE":"2025-11-07T16:30:03.863","LATITUDE":45.116332,"LENDEROWNED":"No","LISTDATE":"2025-11-07T06:00:00","LISTPRICE":279000.0,"LIVINGAREA":1406.0,"LONGITUDE":-93.138052,"LOTDESCRIPTION":"Corner Lot","MODIFICATIONTIMESTAMP":"2025-11-08T11:29:04.846","OFFICE_OFFICENAME":"Pemberton RE","PHOTOCOUNT":13,"POSTALCODE":"55126","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to your new home in the highly desirable Shoreview neighborhood and award-winning Mounds View\nSchool District!\nThis inviting split-entry townhome is perfectly situated in a nature lover’s paradise—nestled among\nserene walking trails that wind through Turtle Creek and lead to McCullough Park. Enjoy peaceful mornings\nor evening sunsets from your private deck overlooking a beautiful pond.\nInside, you’ll find numerous updates that make this home truly move-in ready: brand-new stainless steel\nappliances, stunning LVP flooring, and plush new carpet. The freshly painted interior provides a bright\nand modern feel throughout. The home also features a spacious walk-in pantry, generous walk-in closets,\nand plenty of storage.\nMajor updates give you peace of mind with a new furnace and A/C installed in June 2025. Located in a\nquiet, friendly community where you might spot deer or wild turkeys passing by this home offers the\nperfect blend of comfort, convenience, and natural beauty.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"621-Mounds View","SCHOOLDISTRICTPHONE":"651-621-6001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-08T06:02:06.243","LASTSTATUS":"Coming Soon","STREETNAME":"Sherwood","STREETNUMBER":"870","STREETSUFFIX":"Road","STYLE":"Townhouse Quad/4 Corners","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1983,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-11-07T16:34:03.709","PHOTOREMARKS":"[{\"Order\":5,\"Remarks\":\"pantry.jpg\"},{\"Order\":7,\"Remarks\":\"master walk in closet.jpg\"},{\"Order\":9,\"Remarks\":\"master bedroom\"},{\"Order\":10,\"Remarks\":\"lower level family room\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13","SOURCE":"MG_NST"}
{"ListingKey":"NST7825109","LotSizeArea":"0.09","NST_AgeOfProperty":"42","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Ceiling Fan(s),Deck,Primary Bedroom Walk-In Closet,Vaulted Ceiling(s)","Appliances":"Dishwasher,Dryer,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","NST_AssessmentPending":"No","AssociationFeeIncludes":"Hazard Insurance,Lawn Care,Professional Mgmt,Trash,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"320","AssociationName":"Cedar Management","AssociationPhone":"763-574-1500","PropertyAttachedYN":"True","Basement":"Daylight/Lookout Windows,Finished,Full","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"Shoreview","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"0","CumulativeDaysOnMarket":"0","Directions":"Lexington to Sherwood, west on Royal Oaks Dr, to Sherwood to 870","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","NST_ExpectedMarketDate":"2025-11-08","ConstructionMaterials":"Brick/Stone,Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1006","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageDimensions":"20x20","NST_GarageSquareFeet":"400","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-11-08T06:00:05Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-08","Latitude":"45.116332","NST_LenderOwned":"No","ListAgentKey":"NST93424","ListAgentMlsId":"NST502018274","ListingContractDate":"2025-11-07T06:00:00Z","ListOfficeKey":"NST1001946","ListOfficeName":"Pemberton RE","ListOfficeMlsId":"NST253203","ListPrice":"279000","LivingArea":"1406","LockBoxType":"Combo","Longitude":"-93.138052","LotFeatures":"Corner Lot","LotSizeDimensions":"42x92","LotSizeSquareFeet":"3833.28","LotSizeUnits":"Acres","ListingId":"NST6815139","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"023023240221","GarageSpaces":"2","NST_PatioPorchType":"Deck","PhotosCount":"13","PostalCity":"Saint Paul","PostalCode":"55126","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Welcome to your new home in the highly desirable Shoreview neighborhood and award-winning Mounds View\nSchool District!\nThis inviting split-entry townhome is perfectly situated in a nature lover’s paradise—nestled among\nserene walking trails that wind through Turtle Creek and lead to McCullough Park. Enjoy peaceful mornings\nor evening sunsets from your private deck overlooking a beautiful pond.\nInside, you’ll find numerous updates that make this home truly move-in ready: brand-new stainless steel\nappliances, stunning LVP flooring, and plush new carpet. The freshly painted interior provides a bright\nand modern feel throughout. The home also features a spacious walk-in pantry, generous walk-in closets,\nand plenty of storage.\nMajor updates give you peace of mind with a new furnace and A/C installed in June 2025. Located in a\nquiet, friendly community where you might spot deer or wild turkeys passing by this home offers the\nperfect blend of comfort, convenience, and natural beauty.","PublicSurveyRange":"23","PublicSurveySection":"02","PublicSurveyTownship":"30","NST_RentalLicenseYN":"No","NST_Restrictions":"Rentals not Permitted,Pets - Cats Allowed,Pets - Dogs Allowed,Pets - Number Limit","RoomType":"Living Room,Kitchen,Dining Room,Family Room,Bedroom 1,Bedroom 2,Bedroom 3,Deck,Walk In Closet","NST_AboveGradeSqFtTotal":"1056.0000","NST_BelowGradeSqFtTotal":"350.0000","NST_MainLevelFinishedArea":"1056.0000","BuildingAreaTotal":"1406","HighSchoolDistrict":"Mounds View","NST_SchoolDistrictNumber":"621","NST_SchoolDistrictPhone":"651-621-6001","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1056","BelowGradeFinishedArea":"350","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Split Entry (Bi-Level)","StreetName":"Sherwood","StreetNumber":"870","StreetNumberNumeric":"870","StreetSuffix":"Road","PropertySubType":"Townhouse Quad/4 Corners","SubdivisionName":"Cic 493 Cherry Wood Hills Twnhm","NST_TaxWithAssessments":"4224.0000","TaxYear":"2025","TaxAnnualAmount":"4224","WaterSource":"City Water/Connected","YearBuilt":"1983","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-11-08T11:29:04.846Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7825109\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":2048,\"ImageHeight\":1454,\"ImageSizeDescription\":\"2048x1454\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825109/a5655cae-1ee7-483f-826f-e51c5cf5fc14.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T16:33:06.892Z\",\"MediaKey\":\"690e1f4239d1a16fee68e8e3\"},{\"ResourceRecordKey\":\"NST7825109\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825109/04574360-1f29-469e-acd1-37dade408863.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T16:33:06.714Z\",\"MediaKey\":\"690e1f4239d1a16fee68e8e4\"},{\"ResourceRecordKey\":\"NST7825109\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825109/8a518d29-7942-4989-b110-7c83e9baa4ad.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T16:33:06.702Z\",\"MediaKey\":\"690e1f4239d1a16fee68e8e5\"},{\"ResourceRecordKey\":\"NST7825109\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825109/9c98806c-7c29-48fe-89e5-ce3da8b7c7f1.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T16:33:06.701Z\",\"MediaKey\":\"690e1f4239d1a16fee68e8e6\"},{\"ResourceRecordKey\":\"NST7825109\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"pantry.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825109/4fbc1e39-ca84-4b01-a41e-62df89b68e7c.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T16:33:06.72Z\",\"MediaKey\":\"690e1f4239d1a16fee68e8e7\"},{\"ResourceRecordKey\":\"NST7825109\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825109/7d935968-59d1-43c1-b11e-5b42a7bd6b8e.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T16:33:06.775Z\",\"MediaKey\":\"690e1f4239d1a16fee68e8e8\"},{\"ResourceRecordKey\":\"NST7825109\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"master walk in closet.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825109/6549a011-82e7-46dc-b77c-16a33be3386d.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T16:33:06.742Z\",\"MediaKey\":\"690e1f4239d1a16fee68e8e9\"},{\"ResourceRecordKey\":\"NST7825109\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825109/670b7b3a-e54c-4805-9b16-98618f6515eb.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T16:33:06.741Z\",\"MediaKey\":\"690e1f4239d1a16fee68e8ea\"},{\"ResourceRecordKey\":\"NST7825109\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"master bedroom\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825109/e462536b-2f18-4841-9bba-82d05ad5da38.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T16:33:06.712Z\",\"MediaKey\":\"690e1f4239d1a16fee68e8eb\"},{\"ResourceRecordKey\":\"NST7825109\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"lower level family room\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825109/678f732e-7f99-46c7-9977-fe6951396e34.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T16:33:06.761Z\",\"MediaKey\":\"690e1f4239d1a16fee68e8ec\"},{\"ResourceRecordKey\":\"NST7825109\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825109/62737676-4602-4532-9490-2168eb1af5ce.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T16:33:06.76Z\",\"MediaKey\":\"690e1f4239d1a16fee68e8ed\"},{\"ResourceRecordKey\":\"NST7825109\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825109/ffd887c9-57e0-419f-b42b-fd30201a63b5.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T16:33:06.796Z\",\"MediaKey\":\"690e1f4239d1a16fee68e8ee\"},{\"ResourceRecordKey\":\"NST7825109\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825109/1d8fd85e-2b05-4b37-bb3a-2fe9fc64180d.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T16:33:06.81Z\",\"MediaKey\":\"690e1f4239d1a16fee68e8ef\"}]","PhotosChangeTimestamp":"2025-11-07T16:34:03.709Z","Rooms":"[{\"RoomKey\":\"NST115761815\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115761816\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115761817\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9.5x9\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115761818\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"15x12\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115761819\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"17x11\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115761820\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"17x11\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115761821\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"10x9\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115761822\",\"RoomType\":\"Deck\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x9\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115761823\",\"RoomType\":\"Walk In Closet\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x5\",\"NST_RoomSortOrder\":\"9\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":5,\"Remarks\":\"pantry.jpg\"},{\"Order\":7,\"Remarks\":\"master walk in closet.jpg\"},{\"Order\":9,\"Remarks\":\"master bedroom\"},{\"Order\":10,\"Remarks\":\"lower level family room\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13","CustomVTourURL":""}