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":535425,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7046697","MLSAGENTID":"NST502034509","MLSOFFICEID":"NST40384","ADDRESS":"2801 Flag Avenue N","ACRES":0.0,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":2.0,"CITY":"New Hope","CONTINGENCY":"None","COUNTY":"Hennepin","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":175500.0,"LASTPRICEDATE":"2026-03-31T22:01:06.253","LATITUDE":45.008791,"LENDEROWNED":"Yes","LISTDATE":"2026-03-31T05:00:00","LISTPRICE":175500.0,"LIVINGAREA":988.0,"LONGITUDE":-93.39603,"MODIFICATIONTIMESTAMP":"2026-03-31T22:23:05.992","OFFICE_OFFICENAME":"The Relocation Center","PHOTOCOUNT":19,"POSTALCODE":"55427","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Top floor fully renovated unit with private balcony! Step inside to discover an updated kitchen and hardwood floors that flow through the dining and living areas. Fresh carpet and a full coat of fresh paint make this home feel brand new. Some images in this listing have been virtually staged or digitally altered.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"1271-Robbinsdale","SCHOOLDISTRICTPHONE":"7635048000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-31T22:01:06.253","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Flag","STREETNUMBER":"2801","STREETSUFFIX":"Avenue","STYLE":"(CC) Low Rise (3- Levels)","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1970,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-03-31T22:01:06.254","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_2151.jpg\"},{\"Order\":2,\"Remarks\":\"IMG_2160.jpg\"},{\"Order\":3,\"Remarks\":\"IMG_2161.jpg\"},{\"Order\":4,\"Remarks\":\"IMG_2162.jpg\"},{\"Order\":5,\"Remarks\":\"IMG_2163 (VS).jpg\"},{\"Order\":6,\"Remarks\":\"IMG_2163.jpg\"},{\"Order\":7,\"Remarks\":\"IMG_2164 (VS).jpg\"},{\"Order\":8,\"Remarks\":\"IMG_2164.jpg\"},{\"Order\":9,\"Remarks\":\"IMG_2165.jpg\"},{\"Order\":10,\"Remarks\":\"IMG_2166.jpg\"},{\"Order\":11,\"Remarks\":\"IMG_2167.jpg\"},{\"Order\":12,\"Remarks\":\"IMG_2168.jpg\"},{\"Order\":13,\"Remarks\":\"IMG_2169.jpg\"},{\"Order\":14,\"Remarks\":\"IMG_2170.jpg\"},{\"Order\":15,\"Remarks\":\"IMG_2171.jpg\"},{\"Order\":16,\"Remarks\":\"IMG_2154.jpg\"},{\"Order\":17,\"Remarks\":\"IMG_2158.jpg\"},{\"Order\":18,\"Remarks\":\"IMG_2172.jpg\"},{\"Order\":19,\"Remarks\":\"1.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","SOURCE":"MG_NST"}
{"ListingKey":"NST7877865","NST_AboveGradeSqFtTotal":"988","AboveGradeFinishedArea":"988","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Balcony","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"True","AssociationAmenities":"Coin-op Laundry Owned,Security Building,Tennis Courts","AssociationFee":"570","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Hazard Insurance,Heating,Lawn Care,Professional Mgmt,Sanitation,Shared Amenities,Snow Removal,Water","AssociationName":"RSP Management","AssociationPhone":"6122083779","Basement":"None","BasementYN":"False","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"23","City":"New Hope","NewConstructionYN":"False","Contingency":"None","Cooling":"Wall Unit(s)","CountyOrParish":"Hennepin","Directions":"Medicine Lake Rd to Flag Ave, North to condo entrance","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-03-31T22:00:06.672Z","DaysOnMarket":"0","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"988","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","GarageSpaces":"1","Heating":"Baseboard","HighSchoolDistrict":"Robbinsdale","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.008791","NST_LenderOwned":"Yes","Levels":"One","ListPrice":"175500","ListingContractDate":"2026-03-31T05:00:00Z","ListingId":"NST7046697","LivingArea":"988","Longitude":"-93.39603","LotSizeArea":"0","LotSizeDimensions":"Common","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"988","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-03-31T16:59:57Z","ParcelNumber":"1911821330105","NST_SchoolDistrictNumber":"1271","ParkingFeatures":"Heated Garage,Underground","PhotosCount":"19","PhotosChangeTimestamp":"2026-03-31T22:01:06.254Z","PoolFeatures":"Outdoor,Shared","PostalCity":"Minneapolis","PostalCode":"55427","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(CC) Low Rise (3- Levels)","PropertyType":"Residential","PublicRemarks":"Top floor fully renovated unit with private balcony! Step inside to discover an updated kitchen and hardwood floors that flow through the dining and living areas. Fresh carpet and a full coat of fresh paint make this home feel brand new. Some images in this listing have been virtually staged or digitally altered.","PublicSurveyRange":"21","PublicSurveySection":"19","PublicSurveyTownship":"118","NST_SchoolDistrictPhone":"7635048000","Sewer":"City Sewer/Connected","NST_SharedRooms":"Exercise Room","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Flag","StreetNumber":"2801","StreetNumberNumeric":"2801","StreetSuffix":"Avenue","SubdivisionName":"Condo 0104 Presidential Estate Condo","TaxAnnualAmount":"2077","NST_TaxWithAssessments":"2077","TaxYear":"2025","BuildingAreaTotal":"988","Township":"New Hope","UnitNumber":"323","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1970","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST83495","ListAgentMlsId":"NST502034509","ListOfficeMlsId":"NST40384","ListOfficeName":"The Relocation Center","ListOfficeKey":"NST19050","ModificationTimestamp":"2026-03-31T22:23:05.992Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7877865\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"LongDescription\":\"1.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/a0bc8e45-af61-4bc6-ba8d-b1556336626b.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.938Z\",\"MediaKey\":\"NST121243026\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"IMG_2163 (VS).jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/d076e025-66d5-4940-97cf-d164ef0368e4.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.931Z\",\"MediaKey\":\"NST121242882\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"IMG_2165.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/18b1579e-f84e-4276-9b2f-ee1f82c28f9e.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.965Z\",\"MediaKey\":\"NST121242878\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"IMG_2163.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/e60dd45b-b00b-4274-8124-481fa973150a.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.978Z\",\"MediaKey\":\"NST121242881\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"LongDescription\":\"IMG_2171.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/c5e2a033-7929-4901-b0bc-1cefc7038ff2.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.937Z\",\"MediaKey\":\"NST121242872\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"IMG_2164 (VS).jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/024e2ec1-57f1-4f24-8673-5a8625fa611c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.93Z\",\"MediaKey\":\"NST121242880\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"LongDescription\":\"IMG_2154.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/42cc8e26-6cda-456f-af12-35fd5ffe6f1e.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.928Z\",\"MediaKey\":\"NST121242960\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"IMG_2170.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/c129cf57-e274-44fc-abe5-6e17b7044f42.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.94Z\",\"MediaKey\":\"NST121242873\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"IMG_2161.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/9f2333bc-39d9-448d-b2ac-75c82f70ddcf.jpeg\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.921Z\",\"MediaKey\":\"NST121242884\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"IMG_2160.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/1b5298c1-e84d-40c0-a195-4246b3e9c77e.jpeg\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.939Z\",\"MediaKey\":\"NST121242885\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"LongDescription\":\"IMG_2158.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/b84b4e99-c2ac-4430-84d6-c94b7726b16c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.91Z\",\"MediaKey\":\"NST121242959\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"LongDescription\":\"IMG_2172.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/0a96ced0-6e65-441f-a355-cc68068124a2.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.962Z\",\"MediaKey\":\"NST121242958\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"IMG_2151.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/deabe868-778d-469c-81ec-f17260a9c4f5.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.984Z\",\"MediaKey\":\"NST121242886\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"IMG_2168.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/ad5cbfaa-6219-4fb4-a734-4b05674c5848.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.949Z\",\"MediaKey\":\"NST121242875\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"IMG_2164.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/e787b515-4e36-4dab-9476-c95111c0d826.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.938Z\",\"MediaKey\":\"NST121242879\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"IMG_2166.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/e8bf0035-3ed4-4195-b061-7ca517598977.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.931Z\",\"MediaKey\":\"NST121242877\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"IMG_2169.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/74423ebc-ce3f-4249-8e35-49a788a4ea90.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.928Z\",\"MediaKey\":\"NST121242874\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"IMG_2162.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/f9f99601-4694-427f-92e9-863ad15cf345.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.948Z\",\"MediaKey\":\"NST121242883\"},{\"ResourceRecordKey\":\"NST7877865\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"IMG_2167.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7877865/8fda737e-5f67-494c-9afe-a714815c3852.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-31T22:00:08.946Z\",\"MediaKey\":\"NST121242876\"}]","Media__ResourceRecordKey":"NST7877865","Media__Order":"19","Media__MediaObjectID":"NST19","Media__LongDescription":"1.jpg","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7877865/a0bc8e45-af61-4bc6-ba8d-b1556336626b.jpeg","Media__ImageWidth":"1560","Media__ImageHeight":"2080","Media__ImageSizeDescription":"1560x2080","Media__MediaModificationTimestamp":"3/31/2026 10:00:08 PM","Media__MediaKey":"NST121243026","Rooms":"[{\"RoomLevel\":\"Main\",\"RoomType\":\"Dining Room\",\"RoomDimensions\":\"9 X 8\",\"RoomKey\":\"NST116069865\",\"NST_RoomSortOrder\":2},{\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom\",\"RoomDimensions\":\"15 X 11\",\"RoomKey\":\"NST116069867\",\"NST_RoomSortOrder\":4},{\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\",\"RoomDimensions\":\"9 X 8\",\"RoomKey\":\"NST116069866\",\"NST_RoomSortOrder\":3},{\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\",\"RoomDimensions\":\"16 X 13\",\"RoomKey\":\"NST116069784\",\"NST_RoomSortOrder\":1},{\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom 2\",\"RoomDimensions\":\"14 X 11\",\"RoomKey\":\"NST116069868\",\"NST_RoomSortOrder\":5}]","Rooms__RoomLevel":"Main","Rooms__RoomType":"Dining Room","Rooms__RoomDimensions":"9 X 8","Rooms__RoomKey":"NST116069865","Rooms__NST_RoomSortOrder":"2","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_2151.jpg\"},{\"Order\":2,\"Remarks\":\"IMG_2160.jpg\"},{\"Order\":3,\"Remarks\":\"IMG_2161.jpg\"},{\"Order\":4,\"Remarks\":\"IMG_2162.jpg\"},{\"Order\":5,\"Remarks\":\"IMG_2163 (VS).jpg\"},{\"Order\":6,\"Remarks\":\"IMG_2163.jpg\"},{\"Order\":7,\"Remarks\":\"IMG_2164 (VS).jpg\"},{\"Order\":8,\"Remarks\":\"IMG_2164.jpg\"},{\"Order\":9,\"Remarks\":\"IMG_2165.jpg\"},{\"Order\":10,\"Remarks\":\"IMG_2166.jpg\"},{\"Order\":11,\"Remarks\":\"IMG_2167.jpg\"},{\"Order\":12,\"Remarks\":\"IMG_2168.jpg\"},{\"Order\":13,\"Remarks\":\"IMG_2169.jpg\"},{\"Order\":14,\"Remarks\":\"IMG_2170.jpg\"},{\"Order\":15,\"Remarks\":\"IMG_2171.jpg\"},{\"Order\":16,\"Remarks\":\"IMG_2154.jpg\"},{\"Order\":17,\"Remarks\":\"IMG_2158.jpg\"},{\"Order\":18,\"Remarks\":\"IMG_2172.jpg\"},{\"Order\":19,\"Remarks\":\"1.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","CustomVTourURL":""}