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":1434224,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6821034","MLSAGENTID":"NST502018274","MLSCOAGENTID":"NST502053215","MLSOFFICEID":"NST253203","ADDRESS":"810 57th Avenue N","ACRES":0.45,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Full","BATHSTOTAL":2.0,"BEDROOMS":4,"CITY":"Brooklyn Center","CONTINGENCY":"None","COUNTY":"Hennepin","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":375000.0,"LASTPRICEDATE":"2025-11-22T18:58:04.203","LATITUDE":45.058759,"LENDEROWNED":"No","LISTDATE":"2025-11-22T06:00:00","LISTPRICE":375000.0,"LIVINGAREA":2346.0,"LONGITUDE":-93.290034,"MODIFICATIONTIMESTAMP":"2025-11-23T11:03:05.786","OFFICE_OFFICENAME":"Pemberton RE","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":11,"POSTALCODE":"55430","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this beautifully renovated rambler offering dream one-level living at its best! This charming home features brand new carpet throughout, a new AC, and a new washer and dryer for complete peace of mind. The finished lower level boasts a cozy family room and a spacious recreational area that could easily be converted into a future 5th bedroom, plus plenty of storage space.\n\nSitting on nearly half an acre, the property provides an abundance of room for outdoor fun and entertaining. Enjoy the stunning 3-season porch, complete with skylights and surrounded by large windows that bring nature right inside—perfect for relaxing year-round.\n\nLocated in the highly sought-after Grandview neighborhood, you’ll love the convenience of being close to parks, schools, and major highways. This is truly a rare find that combines comfort, style, and location all in one!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"286-Brooklyn Center","SCHOOLDISTRICTPHONE":"763-561-2120","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-23T06:02:04.477","LASTSTATUS":"Coming Soon","STREETDIRSUFFIX":"N","STREETNAME":"57th","STREETNUMBER":"810","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1960,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-11-22T19:05:04.042","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"front night.jpg\"},{\"Order\":2,\"Remarks\":\"front day.jpg\"},{\"Order\":3,\"Remarks\":\"back yard\"},{\"Order\":4,\"Remarks\":\"living Room main level\"},{\"Order\":5,\"Remarks\":\"sun room / 3 season porch.jpg\"},{\"Order\":6,\"Remarks\":\"kitchen\"},{\"Order\":7,\"Remarks\":\"bathroom main level.jpg\"},{\"Order\":8,\"Remarks\":\"bedroom main level\"},{\"Order\":9,\"Remarks\":\"laundry and storage space.jpg\"},{\"Order\":10,\"Remarks\":\"lower level family room.jpg\"},{\"Order\":11,\"Remarks\":\"810 lower bath.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11","SOURCE":"MG_NST"}
{"ListingKey":"NST7830222","LotSizeArea":"0.45","NST_AgeOfProperty":"65","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Main Floor Primary Bedroom,Porch,Skylight,Sun Room","Appliances":"Dishwasher,Dryer,Exhaust Fan,Refrigerator,Washer","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Finished,Full","BasementYN":"True","NST_BathDesc":"Main Floor 3/4 Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"4","City":"Brooklyn Center","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Hennepin","NST_DPResource":"Y","DaysOnMarket":"0","CumulativeDaysOnMarket":"11","Directions":"Camden Avenue North to 57th Avenue North","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","NST_ExpectedMarketDate":"2025-11-23","ConstructionMaterials":"Vinyl Siding","FireplaceFeatures":"Brick,Family Room,Living Room,Wood Burning","FireplaceYN":"True","FireplacesTotal":"2","NST_ForeclosureStatus":"No","FoundationArea":"1114","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Concrete","NST_GarageSquareFeet":"520","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-11-23T06:00:05Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-23","Latitude":"45.058759","NST_LenderOwned":"No","ListAgentKey":"NST93424","ListAgentMlsId":"NST502018274","CoListAgentKey":"NST508297","CoListAgentMlsId":"NST502053215","ListingContractDate":"2025-11-22T06:00:00Z","ListOfficeKey":"NST1001946","ListOfficeName":"Pemberton RE","ListOfficeMlsId":"NST253203","ListPrice":"375000","LivingArea":"2346","Longitude":"-93.290034","LotSizeDimensions":"222x76","LotSizeSquareFeet":"19602","LotSizeUnits":"Acres","ListingId":"NST6821034","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","OtherStructures":"Storage Shed","ParcelNumber":"0111821240067","GarageSpaces":"2","PhotosCount":"11","PostalCity":"Minneapolis","PostalCode":"55430","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Welcome to this beautifully renovated rambler offering dream one-level living at its best! This charming home features brand new carpet throughout, a new AC, and a new washer and dryer for complete peace of mind. The finished lower level boasts a cozy family room and a spacious recreational area that could easily be converted into a future 5th bedroom, plus plenty of storage space.\n\nSitting on nearly half an acre, the property provides an abundance of room for outdoor fun and entertaining. Enjoy the stunning 3-season porch, complete with skylights and surrounded by large windows that bring nature right inside—perfect for relaxing year-round.\n\nLocated in the highly sought-after Grandview neighborhood, you’ll love the convenience of being close to parks, schools, and major highways. This is truly a rare find that combines comfort, style, and location all in one!","PublicSurveyRange":"21","PublicSurveySection":"01","PublicSurveyTownship":"118","NST_RentalLicenseYN":"No","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Three Season Porch,Family Room,Recreation Room","NST_AboveGradeSqFtTotal":"1392.0000","NST_BelowGradeSqFtTotal":"954.0000","NST_MainLevelFinishedArea":"1392.0000","BuildingAreaTotal":"2346","HighSchoolDistrict":"Brooklyn Center","NST_SchoolDistrictNumber":"286","NST_SchoolDistrictPhone":"763-561-2120","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1392","BelowGradeFinishedArea":"954","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"N","StreetName":"57th","StreetNumber":"810","StreetNumberNumeric":"810","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Goulds Riverview Add","NST_TaxWithAssessments":"4029.0000","TaxYear":"2025","TaxAnnualAmount":"4029","WaterSource":"City Water/Connected","YearBuilt":"1960","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-11-23T11:03:05.786Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7830222\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"front night.jpg\",\"ImageWidth\":1184,\"ImageHeight\":864,\"ImageSizeDescription\":\"1184x864\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830222/45acde09-7a5c-400d-88a5-e5e84e12ba3c.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T19:02:07.275Z\",\"MediaKey\":\"692208af1223e255bbb964f6\"},{\"ResourceRecordKey\":\"NST7830222\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"front day.jpg\",\"ImageWidth\":1184,\"ImageHeight\":864,\"ImageSizeDescription\":\"1184x864\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830222/06c380f3-324a-4caa-ba65-d41af5e23096.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T19:02:07.313Z\",\"MediaKey\":\"692208af1223e255bbb964f7\"},{\"ResourceRecordKey\":\"NST7830222\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"back yard\",\"ImageWidth\":1184,\"ImageHeight\":817,\"ImageSizeDescription\":\"1184x817\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830222/5172fe1f-ef55-406a-abbe-6c6f0e774a3f.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T19:02:07.278Z\",\"MediaKey\":\"692208af1223e255bbb964f8\"},{\"ResourceRecordKey\":\"NST7830222\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"living Room main level\",\"ImageWidth\":1184,\"ImageHeight\":864,\"ImageSizeDescription\":\"1184x864\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830222/5612175a-2ebf-4f95-9b8e-925354b5a233.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T19:02:07.268Z\",\"MediaKey\":\"692208af1223e255bbb964f9\"},{\"ResourceRecordKey\":\"NST7830222\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"sun room / 3 season porch.jpg\",\"ImageWidth\":1175,\"ImageHeight\":813,\"ImageSizeDescription\":\"1175x813\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830222/a91b5ede-2bbf-42ed-82b2-3316d275c35d.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T19:02:07.277Z\",\"MediaKey\":\"692208af1223e255bbb964fa\"},{\"ResourceRecordKey\":\"NST7830222\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"kitchen\",\"ImageWidth\":1184,\"ImageHeight\":864,\"ImageSizeDescription\":\"1184x864\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830222/96ee8d12-9bad-4b25-bab3-ff2031fb235e.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T19:02:07.269Z\",\"MediaKey\":\"692208af1223e255bbb964fb\"},{\"ResourceRecordKey\":\"NST7830222\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"bathroom main level.jpg\",\"ImageWidth\":864,\"ImageHeight\":1184,\"ImageSizeDescription\":\"864x1184\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830222/76131711-59d6-402f-9044-60f75801b453.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T19:02:07.299Z\",\"MediaKey\":\"692208af1223e255bbb964fc\"},{\"ResourceRecordKey\":\"NST7830222\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"bedroom main level\",\"ImageWidth\":1248,\"ImageHeight\":783,\"ImageSizeDescription\":\"1248x783\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830222/781f7cef-6e75-45c9-9c00-0aa5b17e2534.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T19:02:07.268Z\",\"MediaKey\":\"692208af1223e255bbb96500\"},{\"ResourceRecordKey\":\"NST7830222\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"laundry and storage space.jpg\",\"ImageWidth\":1248,\"ImageHeight\":783,\"ImageSizeDescription\":\"1248x783\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830222/5d95420c-4f8e-4fbc-b6e0-2b1f88530742.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T19:02:07.292Z\",\"MediaKey\":\"692208af1223e255bbb964fd\"},{\"ResourceRecordKey\":\"NST7830222\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"lower level family room.jpg\",\"ImageWidth\":1248,\"ImageHeight\":783,\"ImageSizeDescription\":\"1248x783\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830222/31302b09-64ec-4240-8775-a2a38c37be3a.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T19:02:07.276Z\",\"MediaKey\":\"692208af1223e255bbb964fe\"},{\"ResourceRecordKey\":\"NST7830222\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"810 lower bath.jpg\",\"ImageWidth\":1242,\"ImageHeight\":780,\"ImageSizeDescription\":\"1242x780\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830222/4c9ae665-d7b6-441c-91e7-1e6020b75172.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T19:02:07.289Z\",\"MediaKey\":\"692208af1223e255bbb964ff\"}]","PhotosChangeTimestamp":"2025-11-22T19:05:04.042Z","Rooms":"[{\"RoomKey\":\"NST115794093\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"17x13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115794094\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115794095\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x10\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115794096\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19x14\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115794097\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115794098\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115794099\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115794100\",\"RoomType\":\"Three Season Porch\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x15\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115794101\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"12x29\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115794102\",\"RoomType\":\"Recreation Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"16x13\",\"NST_RoomSortOrder\":\"10\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"front night.jpg\"},{\"Order\":2,\"Remarks\":\"front day.jpg\"},{\"Order\":3,\"Remarks\":\"back yard\"},{\"Order\":4,\"Remarks\":\"living Room main level\"},{\"Order\":5,\"Remarks\":\"sun room / 3 season porch.jpg\"},{\"Order\":6,\"Remarks\":\"kitchen\"},{\"Order\":7,\"Remarks\":\"bathroom main level.jpg\"},{\"Order\":8,\"Remarks\":\"bedroom main level\"},{\"Order\":9,\"Remarks\":\"laundry and storage space.jpg\"},{\"Order\":10,\"Remarks\":\"lower level family room.jpg\"},{\"Order\":11,\"Remarks\":\"810 lower bath.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11","CustomVTourURL":""}