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":1396101,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6771687","MLSAGENTID":"NST502021148","MLSOFFICEID":"NST41150","ADDRESS":"2024 Queen Avenue N","ACRES":0.12,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Full","BATHSTOTAL":1.0,"BEDROOMS":3,"CITY":"Minneapolis","CONTINGENCY":"None","COUNTY":"Hennepin","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":189900.0,"LASTPRICEDATE":"2025-08-14T23:43:03.847","LATITUDE":45.000336,"LENDEROWNED":"No","LISTDATE":"2025-08-14T05:00:00","LISTPRICE":189900.0,"LIVINGAREA":1024.0,"LONGITUDE":-93.309128,"MODIFICATIONTIMESTAMP":"2025-08-15T10:08:10.692","NEIGHBORHOOD":"Willard - Hay","OFFICE_OFFICENAME":"HOMESTEAD ROAD","PHOTOCOUNT":18,"POSTALCODE":"55411","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Affordable, move-in ready home in a convenient Minneapolis location. A great opportunity to own instead of rent. Close to parks, transit, and city amenities.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"1-Minneapolis","SCHOOLDISTRICTPHONE":"612-668-0000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-14T23:43:03.847","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Queen","STREETNUMBER":"2024","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1910,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-14T23:43:03.845","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Main level living room\"},{\"Order\":2,\"Remarks\":\"Dining room\"},{\"Order\":3,\"Remarks\":\"Main level kitchen\"},{\"Order\":4,\"Remarks\":\"Main level kitchen\"},{\"Order\":5,\"Remarks\":\"Main level bedroom 1\"},{\"Order\":6,\"Remarks\":\"Main level full bathroom\"},{\"Order\":7,\"Remarks\":\"Main level full bathroom\"},{\"Order\":8,\"Remarks\":\"17_Nordy (17).jpeg\"},{\"Order\":9,\"Remarks\":\"Upper level bedroom 2\"},{\"Order\":10,\"Remarks\":\"Upper level bed 3\"},{\"Order\":11,\"Remarks\":\"Exterior\"},{\"Order\":12,\"Remarks\":\"Front porch\"},{\"Order\":13,\"Remarks\":\"Detached 2 car garage\"},{\"Order\":14,\"Remarks\":\"Backyard\"},{\"Order\":15,\"Remarks\":\"Main level floorplan\"},{\"Order\":16,\"Remarks\":\"Upper level floorplan\"},{\"Order\":17,\"Remarks\":\"Lower level floorplan\"},{\"Order\":18,\"Remarks\":\"All floors floorplan\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7787551","LotSizeArea":"0.12","NST_AgeOfProperty":"115","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Daylight/Lookout Windows,Full","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","City":"Minneapolis","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Hennepin","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","Directions":"Penn Ave to 21st Street West to Queen Ave then South to Home.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"715","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached,Asphalt,Concrete","NST_GarageSquareFeet":"365","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-14T23:40:18Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-15","Latitude":"45.000336","NST_LenderOwned":"No","ListAgentKey":"NST82339","ListAgentMlsId":"NST502021148","ListingContractDate":"2025-08-14T05:00:00Z","ListOfficeKey":"NST21187","ListOfficeName":"HOMESTEAD ROAD","ListOfficeMlsId":"NST41150","ListPrice":"189900","LivingArea":"1024","Longitude":"-93.309128","LotSizeDimensions":"40'x127'x40'x127'","LotSizeSquareFeet":"5227.2","LotSizeUnits":"Acres","ListingId":"NST6771687","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Willard - Hay","NST_OfficeBoard":"MAAR","ParcelNumber":"1702924140036","GarageSpaces":"2","PhotosCount":"18","PostalCity":"Minneapolis","PostalCode":"55411","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Affordable, move-in ready home in a convenient Minneapolis location. A great opportunity to own instead of rent. Close to parks, transit, and city amenities.","PublicSurveyRange":"24","PublicSurveySection":"17","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bathroom","NST_AboveGradeSqFtTotal":"1024.0000","NST_BelowGradeSqFtTotal":"715.0000","NST_MainLevelFinishedArea":"715.0000","BuildingAreaTotal":"1739","HighSchoolDistrict":"Minneapolis","NST_SchoolDistrictNumber":"1","NST_SchoolDistrictPhone":"612-668-0000","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Divided Bdr Flr Plan,Main Floor Primary,Main Floor Bedroom","AboveGradeFinishedArea":"1024","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One and One Half","StreetDirSuffix":"N","StreetName":"Queen","StreetNumber":"2024","StreetNumberNumeric":"2024","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Nichols-Frissell Cos Shady Oaks Add","NST_TaxWithAssessments":"448.0000","TaxYear":"2025","TaxAnnualAmount":"448","WaterSource":"City Water/Connected","YearBuilt":"1910","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-15T10:08:10.692Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7787551\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Main level living room\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/fc0590cd-71e7-4bc5-941e-e5b52f0eb03a.png\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:49.069Z\",\"MediaKey\":\"689e7479a4b924472d87e304\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Dining room\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/2b6871fb-8abd-440e-961f-ecd25327dfb3.png\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:49.063Z\",\"MediaKey\":\"689e7479a4b924472d87e305\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Main level kitchen\",\"ImageWidth\":2047,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2047x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/33219bfb-b642-4044-a5da-9f0b26b74f33.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:48.986Z\",\"MediaKey\":\"689e7479a4b924472d87e306\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Main level kitchen\",\"ImageWidth\":2047,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2047x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/ec9891fe-16c5-4916-ac79-aa4e8baa72c2.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:49.018Z\",\"MediaKey\":\"689e7479a4b924472d87e307\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Main level bedroom 1\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/374f9660-28d1-4c35-a191-03c4ed5dcca9.png\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:49.089Z\",\"MediaKey\":\"689e7479a4b924472d87e308\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Main level full bathroom\",\"ImageWidth\":2047,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2047x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/c7d94284-0efc-411b-8627-5cc4c2b5b0ea.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:49.03Z\",\"MediaKey\":\"689e7479a4b924472d87e309\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Main level full bathroom\",\"ImageWidth\":2047,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2047x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/a8da67ad-ffbb-452e-83a2-85cb65f32360.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:49.015Z\",\"MediaKey\":\"689e7479a4b924472d87e30a\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"17_Nordy (17).jpeg\",\"ImageWidth\":2047,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2047x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/ebae0a45-5ac6-4aab-8dae-cd0462d7ee6a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:48.984Z\",\"MediaKey\":\"689e7479a4b924472d87e30b\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Upper level bedroom 2\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/5b7fd475-c0f9-4928-b7de-f5be31b7c651.png\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:49.081Z\",\"MediaKey\":\"689e7479a4b924472d87e30c\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Upper level bed 3\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/d1c603a9-7306-420b-876f-0be873db93e1.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:48.998Z\",\"MediaKey\":\"689e7479a4b924472d87e30d\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Exterior\",\"ImageWidth\":2047,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2047x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/3708c683-12c1-41bb-abdf-4f15452db5bb.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:48.982Z\",\"MediaKey\":\"689e7479a4b924472d87e30e\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"Front porch\",\"ImageWidth\":2047,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2047x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/dcfac723-4fbb-4752-a373-05e3970dcf05.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:48.968Z\",\"MediaKey\":\"689e7479a4b924472d87e30f\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"Detached 2 car garage\",\"ImageWidth\":2046,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2046x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/e551abbe-440c-49ec-94e2-e2d2f188789d.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:49.033Z\",\"MediaKey\":\"689e7479a4b924472d87e310\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"Backyard\",\"ImageWidth\":2047,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2047x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/1a278334-39f7-43ba-9d59-92b4f17574b9.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:49.056Z\",\"MediaKey\":\"689e7479a4b924472d87e311\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"Main level floorplan\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/969363f9-cdba-4268-9f04-08bbda6ddf1a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:48.96Z\",\"MediaKey\":\"689e7479a4b924472d87e312\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"Upper level floorplan\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/a3afeffb-57f4-4a4d-88a6-9c79101b3da7.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:48.984Z\",\"MediaKey\":\"689e7479a4b924472d87e313\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"Lower level floorplan\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/b75c6c92-08b7-4974-8e8e-ae99eff5a6cc.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:48.984Z\",\"MediaKey\":\"689e7479a4b924472d87e314\"},{\"ResourceRecordKey\":\"NST7787551\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"All floors floorplan\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787551/27545132-9ce5-4d92-b56d-f8b6f0dd084e.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T23:42:49.002Z\",\"MediaKey\":\"689e7479a4b924472d87e315\"}]","PhotosChangeTimestamp":"2025-08-14T23:43:03.845Z","Rooms":"[{\"RoomKey\":\"NST115514346\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x11.5\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115514347\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115514348\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19x10\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115514349\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115514350\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115514351\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13.5x11\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115514352\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"7\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Main level living room\"},{\"Order\":2,\"Remarks\":\"Dining room\"},{\"Order\":3,\"Remarks\":\"Main level kitchen\"},{\"Order\":4,\"Remarks\":\"Main level kitchen\"},{\"Order\":5,\"Remarks\":\"Main level bedroom 1\"},{\"Order\":6,\"Remarks\":\"Main level full bathroom\"},{\"Order\":7,\"Remarks\":\"Main level full bathroom\"},{\"Order\":8,\"Remarks\":\"17_Nordy (17).jpeg\"},{\"Order\":9,\"Remarks\":\"Upper level bedroom 2\"},{\"Order\":10,\"Remarks\":\"Upper level bed 3\"},{\"Order\":11,\"Remarks\":\"Exterior\"},{\"Order\":12,\"Remarks\":\"Front porch\"},{\"Order\":13,\"Remarks\":\"Detached 2 car garage\"},{\"Order\":14,\"Remarks\":\"Backyard\"},{\"Order\":15,\"Remarks\":\"Main level floorplan\"},{\"Order\":16,\"Remarks\":\"Upper level floorplan\"},{\"Order\":17,\"Remarks\":\"Lower level floorplan\"},{\"Order\":18,\"Remarks\":\"All floors floorplan\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}