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":1414948,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6791909","MLSAGENTID":"NST506017206","MLSOFFICEID":"NST10794","ADDRESS":"2800 Hillsboro Avenue N","ACRES":3.33,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":1.0,"BEDROOMS":1,"CITY":"New Hope","CONTINGENCY":"None","COUNTY":"Hennepin","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone","FORECLOSURE":"No","LASTPRICE":125000.0,"LASTPRICEDATE":"2025-09-30T16:46:05.073","LATITUDE":45.008869,"LENDEROWNED":"No","LISTDATE":"2025-09-30T05:00:00","LISTPRICE":125000.0,"LIVINGAREA":700.0,"LONGITUDE":-93.397146,"MODIFICATIONTIMESTAMP":"2025-09-30T21:05:03.665","OFFICE_OFFICENAME":"Weichert, Realtors-Advantage","PHOTOCOUNT":17,"POSTALCODE":"55427","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Charming condo in New Hope featuring a thoughtful layout and true move-in readiness. The kitchen shines with crisp white cabinetry and a stylish tiled backsplash. Sunlight pours into the living room from the adjoining deck—an ideal spot for your morning coffee. Enjoy hassle-free living with access to community amenities including a pool, fitness center, and party room. Heated underground parking is another major perk, especially during Minnesota winters. Don’t miss this excellent opportunity at a great value—it won’t be available for long!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"281-Robbinsdale","SCHOOLDISTRICTPHONE":"763-504-8000","SEWER":"City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-30T16:46:05.073","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Hillsboro","STREETNUMBER":"2800","STREETSUFFIX":"Avenue","STYLE":"Low Rise","TRANSACTIONTYPE":"For Sale","WATER":"City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1970,"ZONING":"Residential-Multi-Family","VIRTUALTOUR_URL1":"https://listings.uavvisionmedia.com/sites/qajwajk/unbranded","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-30T21:05:03.665","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"20250930_140551.jpg\"},{\"Order\":2,\"Remarks\":\"20250930_140459.jpg\"},{\"Order\":3,\"Remarks\":\"1-web-or-mls-UAV Vision Media (9).jpg\"},{\"Order\":4,\"Remarks\":\"2-web-or-mls-UAV Vision Media (10).jpg\"},{\"Order\":5,\"Remarks\":\"3-web-or-mls-UAV Vision Media (11).jpg\"},{\"Order\":6,\"Remarks\":\"4-web-or-mls-UAV Vision Media (12).jpg\"},{\"Order\":7,\"Remarks\":\"5-web-or-mls-UAV Vision Media (8).jpg\"},{\"Order\":8,\"Remarks\":\"6-web-or-mls-UAV Vision Media (14).jpg\"},{\"Order\":9,\"Remarks\":\"7-web-or-mls-UAV Vision Media (15).jpg\"},{\"Order\":10,\"Remarks\":\"8-web-or-mls-UAV Vision Media (1).jpg\"},{\"Order\":11,\"Remarks\":\"9-web-or-mls-UAV Vision Media (2).jpg\"},{\"Order\":12,\"Remarks\":\"10-web-or-mls-UAV Vision Media (3).jpg\"},{\"Order\":13,\"Remarks\":\"11-web-or-mls-UAV Vision Media (4).jpg\"},{\"Order\":14,\"Remarks\":\"12-web-or-mls-UAV Vision Media (5).jpg\"},{\"Order\":15,\"Remarks\":\"13-web-or-mls-UAV Vision Media (6).jpg\"},{\"Order\":16,\"Remarks\":\"14-web-or-mls-UAV Vision Media (7).jpg\"},{\"Order\":17,\"Remarks\":\"15-web-or-mls-UAV Vision Media (13).jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7805153","LotSizeArea":"3.33","NST_AgeOfProperty":"55","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","AssociationAmenities":"Laundry,Coin-op Laundry Owned,Elevator(s)","NST_AmenitiesUnit":"Deck","NST_AssessmentPending":"No","AssociationFeeIncludes":"Gas,Hazard Insurance,Heating,Lawn Care,Maintenance Grounds,Professional Mgmt,Trash,Shared Amenities,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"400","AssociationName":"Compass Management","AssociationPhone":"612-888-4710","PropertyAttachedYN":"True","Basement":"None","BasementYN":"False","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"1","City":"New Hope","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Hennepin","Directions":"Hwy 169 to Medicine Lake Rd (CR 70), East to Hillsboro. North to first complex on the right, Presidential Estates II.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"700","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Assigned,Finished Garage,Guest Parking,Heated Garage,Parking Garage,Underground","AccessibilityFeatures":"Accessible Elevator Installed","Heating":"Baseboard,Hot Water","OriginalEntryTimestamp":"2025-09-30T16:43:52Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-30","Latitude":"45.008869","NST_LenderOwned":"No","ListAgentKey":"NST219744","ListAgentMlsId":"NST506017206","ListingContractDate":"2025-09-30T05:00:00Z","ListOfficeKey":"NST18009","ListOfficeName":"Weichert, Realtors-Advantage","ListOfficeMlsId":"NST10794","ListPrice":"125000","LivingArea":"700","LockBoxType":"Combo","Longitude":"-93.397146","LotSizeDimensions":"Common","LotSizeSquareFeet":"145229.04","LotSizeUnits":"Acres","ListingId":"NST6791909","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"1911821330133","GarageSpaces":"1","PhotosCount":"17","PoolFeatures":"Below Ground","PostalCity":"New Hope","PostalCode":"55427","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Charming condo in New Hope featuring a thoughtful layout and true move-in readiness. The kitchen shines with crisp white cabinetry and a stylish tiled backsplash. Sunlight pours into the living room from the adjoining deck—an ideal spot for your morning coffee. Enjoy hassle-free living with access to community amenities including a pool, fitness center, and party room. Heated underground parking is another major perk, especially during Minnesota winters. Don’t miss this excellent opportunity at a great value—it won’t be available for long!","PublicSurveyRange":"21","PublicSurveySection":"19","PublicSurveyTownship":"118","NST_RentalLicenseYN":"No","NST_Restrictions":"Pets Not Allowed","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Deck","NST_AboveGradeSqFtTotal":"700.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"700.0000","BuildingAreaTotal":"700","HighSchoolDistrict":"Robbinsdale","NST_SchoolDistrictNumber":"281","NST_SchoolDistrictPhone":"763-504-8000","Sewer":"City Sewer - In Street","NST_SharedRooms":"Amusement/Party Room,Club House,Community Room","AboveGradeFinishedArea":"700","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"N","StreetName":"Hillsboro","StreetNumber":"2800","StreetNumberNumeric":"2800","StreetSuffix":"Avenue","PropertySubType":"Low Rise","SubdivisionName":"Condo 0124 President Estate Condo 2","NST_TaxWithAssessments":"1788.0000","TaxYear":"2025","TaxAnnualAmount":"1788","UnitNumber":"203","VirtualTourURLUnbranded":"https://listings.uavvisionmedia.com/sites/qajwajk/unbranded","WaterSource":"City Water - In Street","YearBuilt":"1970","ZoningDescription":"Residential-Multi-Family","ModificationTimestamp":"2025-09-30T21:05:03.665Z","PhotosChangeTimestamp":"2025-09-30T21:05:03.665Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7805153\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"20250930_140551.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1604,\"ImageSizeDescription\":\"2080x1604\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/6041ef28-e9f0-4912-bfb7-84b92ac78dc0.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.171Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4c6\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"20250930_140459.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/672f85bb-ffab-4029-93cd-073d73d53cca.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.192Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4c7\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"1-web-or-mls-UAV Vision Media (9).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/03a8550f-c209-4d71-a2b5-702ca601e5ed.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.166Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4c8\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"2-web-or-mls-UAV Vision Media (10).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/43cce8e9-27a3-4a42-a0f9-aa9eee28640d.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.14Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4c9\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"3-web-or-mls-UAV Vision Media (11).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/893a1ec1-0f1e-48bf-95f5-aef509b180e7.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.174Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4ca\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"4-web-or-mls-UAV Vision Media (12).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/a41a8a52-8cd7-4e62-a15c-3ed827292828.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.142Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4cb\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"5-web-or-mls-UAV Vision Media (8).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/901f00ff-8e28-4bd9-9399-7188be66bb6e.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.166Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4cc\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"6-web-or-mls-UAV Vision Media (14).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/55304c79-bc26-497f-9aca-0201b2200cc5.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.229Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4cd\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"7-web-or-mls-UAV Vision Media (15).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/0608ea15-28da-4813-a017-d3f3c77f9799.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.133Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4ce\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"8-web-or-mls-UAV Vision Media (1).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/50e32cc2-a502-439c-b4d4-0a813e14ee40.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.13Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4cf\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"9-web-or-mls-UAV Vision Media (2).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/765eb664-e93c-47ed-99d9-3d71971ae447.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.137Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4d0\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"10-web-or-mls-UAV Vision Media (3).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/243e1394-7412-498e-ac82-64c725019027.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.132Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4d1\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"11-web-or-mls-UAV Vision Media (4).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/b2efc3f0-a657-4351-af68-0235f2d8a6f4.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.166Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4d2\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"12-web-or-mls-UAV Vision Media (5).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/485bbe3a-2449-4822-b167-3ff4ebb9f434.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.177Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4d3\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"13-web-or-mls-UAV Vision Media (6).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/fd360014-049c-49cf-a188-62541a12d0c8.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.127Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4d4\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"14-web-or-mls-UAV Vision Media (7).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/14427887-f143-47ac-9d9a-023c1e08dd30.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.164Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4d5\"},{\"ResourceRecordKey\":\"NST7805153\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"15-web-or-mls-UAV Vision Media (13).jpg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805153/8f8ac119-3bf3-4f96-8bf3-28ff28199173.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:04:36.282Z\",\"MediaKey\":\"68dc45e46ce09e10477dc4d6\"}]","Rooms":"[{\"RoomKey\":\"NST115659585\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19 x 13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115659586\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"08 x 07\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115659587\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"08 x 07\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115659588\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13 x 12\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115659589\",\"RoomType\":\"Deck\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11 x 05\",\"NST_RoomSortOrder\":\"5\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"20250930_140551.jpg\"},{\"Order\":2,\"Remarks\":\"20250930_140459.jpg\"},{\"Order\":3,\"Remarks\":\"1-web-or-mls-UAV Vision Media (9).jpg\"},{\"Order\":4,\"Remarks\":\"2-web-or-mls-UAV Vision Media (10).jpg\"},{\"Order\":5,\"Remarks\":\"3-web-or-mls-UAV Vision Media (11).jpg\"},{\"Order\":6,\"Remarks\":\"4-web-or-mls-UAV Vision Media (12).jpg\"},{\"Order\":7,\"Remarks\":\"5-web-or-mls-UAV Vision Media (8).jpg\"},{\"Order\":8,\"Remarks\":\"6-web-or-mls-UAV Vision Media (14).jpg\"},{\"Order\":9,\"Remarks\":\"7-web-or-mls-UAV Vision Media (15).jpg\"},{\"Order\":10,\"Remarks\":\"8-web-or-mls-UAV Vision Media (1).jpg\"},{\"Order\":11,\"Remarks\":\"9-web-or-mls-UAV Vision Media (2).jpg\"},{\"Order\":12,\"Remarks\":\"10-web-or-mls-UAV Vision Media (3).jpg\"},{\"Order\":13,\"Remarks\":\"11-web-or-mls-UAV Vision Media (4).jpg\"},{\"Order\":14,\"Remarks\":\"12-web-or-mls-UAV Vision Media (5).jpg\"},{\"Order\":15,\"Remarks\":\"13-web-or-mls-UAV Vision Media (6).jpg\"},{\"Order\":16,\"Remarks\":\"14-web-or-mls-UAV Vision Media (7).jpg\"},{\"Order\":17,\"Remarks\":\"15-web-or-mls-UAV Vision Media (13).jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}