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":505506,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7001062","MLSAGENTID":"NST502001117","MLSOFFICEID":"NST5418","ADDRESS":"3537 Flag Avenue N","ACRES":0.4,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Full","BATHSTOTAL":1.0,"BEDROOMS":3,"CITY":"New Hope","CONTINGENCY":"None","COUNTY":"Hennepin","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":209900.0,"LASTPRICEDATE":"2025-12-18T22:53:05.623","LATITUDE":45.020506,"LENDEROWNED":"No","LISTDATE":"2025-12-17T06:00:00","LISTPRICE":209900.0,"LIVINGAREA":1270.0,"LONGITUDE":-93.395925,"LOTDESCRIPTION":"Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2025-12-19T11:03:13.489","OFFICE_OFFICENAME":"Twin Oaks Realty, Inc","PHOTOCOUNT":16,"POSTALCODE":"55427","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Great location and beautiful large treed lot. Convenient location close to schools, parks, shopping and easy highway access. Three bedrooms on the main level. Office located off of one of the bedrooms. Large libing room with fireplace plus a dining room or main floor family room. Lower level is unfinished with more potential here. This home is being sold as is. Good opportunity to rehab and build equity. Buyer to be responsible for any work required by the city. Affordable opportunity here.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"1271-Robbinsdale","SCHOOLDISTRICTPHONE":"7635048000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-12-18T22:53:05.623","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Flag","STREETNUMBER":"3537","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1942,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-12-18T22:45:06.07","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","SOURCE":"MG_NST"}
{"ListingKey":"NST7836203","NST_AboveGradeSqFtTotal":"1270","AboveGradeFinishedArea":"1270","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Window,Natural Woodwork","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Full","BasementYN":"True","NST_BathDesc":"Basement,Main Floor Full Bath,Rough In","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"1023","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"1","City":"New Hope","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Hennepin","NST_DPResource":"Yes","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"36th Ave N east of Hwy 169 to Flag Ave, south to home","DocumentsCount":"2","DocumentsChangeTimestamp":"2025-12-18T23:16:05.137Z","DaysOnMarket":"1","FireplaceFeatures":"Living Room","FireplaceYN":"True","FireplacesTotal":"2","FoundationArea":"1023","NST_FractionalOwnershipYN":"No","NST_Fuel":"Oil","NST_GarageSquareFeet":"552","NST_GarageDimensions":"23 x 24","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Robbinsdale","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.020506","LaundryFeatures":"Lower Level","NST_LenderOwned":"No","Levels":"One","ListPrice":"209900","ListingContractDate":"2025-12-17T06:00:00Z","ListingId":"NST7001062","LivingArea":"1270","LockBoxType":"Supra","Longitude":"-93.395925","LotFeatures":"Tree Coverage - Light","LotSizeArea":"0.4","LotSizeDimensions":"91x237x46x89x45x147","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1270","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2025-12-18T16:42:52Z","ParcelNumber":"1911821220008","NST_SchoolDistrictNumber":"1271","ParkingFeatures":"Attached Garage,Asphalt","NST_PatioPorchType":"Deck","PhotosCount":"16","PhotosChangeTimestamp":"2025-12-18T22:45:06.07Z","PostalCity":"Minneapolis","PostalCode":"55427","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"Great location and beautiful large treed lot. Convenient location close to schools, parks, shopping and easy highway access. Three bedrooms on the main level. Office located off of one of the bedrooms. Large libing room with fireplace plus a dining room or main floor family room. Lower level is unfinished with more potential here. This home is being sold as is. Good opportunity to rehab and build equity. Buyer to be responsible for any work required by the city. Affordable opportunity here.","PublicSurveyRange":"21","PublicSurveySection":"19","PublicSurveyTownship":"118","RoadFrontageType":"City Street","Roof":"Asphalt,Pitched","NST_SchoolDistrictPhone":"7635048000","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level,Main Floor Bedroom","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Flag","StreetNumber":"3537","StreetNumberNumeric":"3537","StreetSuffix":"Avenue","TaxAnnualAmount":"3989","NST_TaxWithAssessments":"3989","TaxYear":"2025","Township":"New Hope","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1942","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST48510","ListAgentMlsId":"NST502001117","ListOfficeMlsId":"NST5418","ListOfficeName":"Twin Oaks Realty, Inc","ListOfficeKey":"NST16194","ModificationTimestamp":"2025-12-19T11:03:13.489Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/5ac7968b-3857-470d-82b8-afec1408ef1d.jpeg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":1504,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1504x1000\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.166Z\",\"MediaKey\":\"NST119941706\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/b35abdcc-0c05-40b4-a3c5-640ef1af36f8.jpeg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":1451,\"ImageHeight\":965,\"ImageSizeDescription\":\"1451x965\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.173Z\",\"MediaKey\":\"NST119941670\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/e246c1f1-5841-4cfe-b50f-9bf2472cef73.jpeg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":1504,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1504x1000\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.175Z\",\"MediaKey\":\"NST119941700\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/05657f01-502d-4198-971c-9f424a9666f3.jpeg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":1504,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1504x1000\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.196Z\",\"MediaKey\":\"NST119941703\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/0f432bf0-2f11-4f8c-aec0-4bc39482a374.jpeg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":1472,\"ImageHeight\":979,\"ImageSizeDescription\":\"1472x979\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.194Z\",\"MediaKey\":\"NST119941704\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/4903bd9c-fb70-4e32-bc6d-fc3105469de3.jpeg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":1504,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1504x1000\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.157Z\",\"MediaKey\":\"NST119941698\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/cb75b397-7a22-4a52-9179-ad387381fead.jpeg\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":1436,\"ImageHeight\":955,\"ImageSizeDescription\":\"1436x955\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.157Z\",\"MediaKey\":\"NST119941699\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/3179962f-9dae-4a33-8a05-d5a333c7fdfe.jpeg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":1504,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1504x1000\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.157Z\",\"MediaKey\":\"NST119941592\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/d9a9398e-3ebd-40de-bdf9-d465b64aa354.jpeg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":1504,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1504x1000\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.161Z\",\"MediaKey\":\"NST119941668\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/46acbbae-a793-4e96-9faf-1c0c5bca5433.jpeg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":1504,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1504x1000\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.157Z\",\"MediaKey\":\"NST119941705\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/efe25f97-9f41-4bc0-b92b-82889826ff1a.jpeg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":1504,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1504x1000\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.157Z\",\"MediaKey\":\"NST119941669\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/03be3462-5792-49d2-bd50-6bb4bf952df2.jpeg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":1504,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1504x1000\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.134Z\",\"MediaKey\":\"NST119941702\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/0ddc4e98-0228-4fef-95c3-e6c624584fc0.jpeg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":1504,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1504x1000\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.162Z\",\"MediaKey\":\"NST119941707\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/3a84bd25-d2bb-473e-8ac9-e4cd49151df0.jpeg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":1504,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1504x1000\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.186Z\",\"MediaKey\":\"NST119941701\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/ecea88e6-36b0-4d38-b448-85172f3aaeda.jpeg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":1504,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1504x1000\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.186Z\",\"MediaKey\":\"NST119941591\"},{\"ResourceRecordKey\":\"NST7836203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836203/36e7f3cb-19cc-418c-bb4c-ce56bcc0ca8e.jpeg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":1504,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1504x1000\",\"MediaModificationTimestamp\":\"2025-12-18T22:44:13.186Z\",\"MediaKey\":\"NST119941708\"}]","Media__ResourceRecordKey":"NST7836203","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7836203/5ac7968b-3857-470d-82b8-afec1408ef1d.jpeg","Media__Order":"9","Media__MediaObjectID":"NST9","Media__ImageWidth":"1504","Media__ImageHeight":"1000","Media__ImageSizeDescription":"1504x1000","Media__MediaModificationTimestamp":"12/18/2025 10:44:13 PM","Media__MediaKey":"NST119941706","Rooms":"[{\"RoomDimensions\":\"14 x 10\",\"RoomKey\":\"NST115830860\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2},{\"RoomDimensions\":\"15 x 9\",\"RoomKey\":\"NST115830862\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4},{\"RoomDimensions\":\"12 x 9\",\"RoomKey\":\"NST115830861\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3},{\"RoomDimensions\":\"20 x 14\",\"RoomKey\":\"NST115830859\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1},{\"RoomDimensions\":\"10 x 9\",\"RoomKey\":\"NST115830865\",\"RoomType\":\"Office\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":7},{\"RoomDimensions\":\"15 x 10\",\"RoomKey\":\"NST115830863\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5},{\"RoomDimensions\":\"11 x 9\",\"RoomKey\":\"NST115830864\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":6}]","Rooms__RoomDimensions":"14 x 10","Rooms__RoomKey":"NST115830860","Rooms__RoomType":"Dining Room","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"2","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","CustomVTourURL":""}