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":575645,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7096558","MLSAGENTID":"NST505004198","MLSOFFICEID":"NST3679","ADDRESS":"514 Huset Parkway NE","ACRES":0.02,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":4.0,"BEDROOMS":3.0,"CITY":"Columbia Heights","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":329000.0,"LASTPRICEDATE":"2026-06-21T02:10:06.547","LATITUDE":45.037465,"LENDEROWNED":"No","LISTDATE":"2026-06-20T05:00:00","LISTPRICE":329000.0,"LIVINGAREA":1874.0,"LONGITUDE":-93.259216,"MODIFICATIONTIMESTAMP":"2026-06-21T02:10:06.545","OFFICE_OFFICENAME":"MN Realty Group Inc.","PHOTOCOUNT":12,"POSTALCODE":"55421","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Spacious 3 Bedrooms, Finished Basement TH, Granite Counter Tops, Stainless Steel Appliances. Many upgrades when built. Views are great of park in front. The floor plan has nice flow w/3 BR & 4 Baths. A see-through Cozy Gas fireplace between the dining area & living Aewa. The kitchen is bright, boasts an island for your convenience. Classic brick front & bay window. Best location-close to Huset Park, MASTER BR with Private Master Bathroom. , LOWER LEVEL Can be 4th Bedroom Suite if you Just add a door. Attached is 2 CAR GARAGE. Washer Dryer in the unit.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"13-Columbia Heights","SCHOOLDISTRICTPHONE":"7635284500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-21T02:10:06.547","LASTSTATUS":"Active","STREETDIRSUFFIX":"NE","STREETNAME":"Huset","STREETNUMBER":"514","STREETSUFFIX":"Parkway","STYLE":"(TH) Side x Side","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2006,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-21T02:03:06.591","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"514 Front.jpg\"},{\"Order\":2,\"Remarks\":\"GG.jpg\"},{\"Order\":3,\"Remarks\":\"514 Kitchen.jpg\"},{\"Order\":4,\"Remarks\":\"514 k.jpg\"},{\"Order\":5,\"Remarks\":\"514 kit dr.jpg\"},{\"Order\":6,\"Remarks\":\"514.jpg\"},{\"Order\":7,\"Remarks\":\"514 +.jpg\"},{\"Order\":8,\"Remarks\":\"514 Kitchen 1.jpg\"},{\"Order\":9,\"Remarks\":\"514 FP.jpg\"},{\"Order\":10,\"Remarks\":\"514 LR.jpg\"},{\"Order\":21,\"Remarks\":\"Bath.jpg\"},{\"Order\":23,\"Remarks\":\"2nd BR of 4.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,21,23","SOURCE":"MG_NST"}
{"ListingKey":"NST7922289","NST_AboveGradeSqFtTotal":"1648","AboveGradeFinishedArea":"1648","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Deck,Kitchen Center Island,Walk-In Closet","Appliances":"Dishwasher,Dryer,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"True","AssociationFee":"256","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Lawn Care,Maintenance Grounds,Professional Mgmt,Snow Removal","AssociationName":"First Residential","AssociationPhone":"9522772700","Basement":"Finished","BasementYN":"True","NST_BathDesc":"3/4 Basement,Full Primary,Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"4","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"226","BelowGradeFinishedArea":"226","CumulativeDaysOnMarket":"463","City":"Columbia Heights","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DiningRoomDescription":"Breakfast Area,Kitchen/Dining Room,Living/Dining Room","Directions":"37th to Huset Parkway to the house","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-06-21T02:03:06.591Z","DaysOnMarket":"0","ExteriorFeatures":"Stone,Vinyl","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"824","FoundationDetails":"Combination","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"400","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Columbia Heights","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.037465","NST_LenderOwned":"No","Levels":"Two","ListPrice":"329000","ListingContractDate":"2026-06-20T05:00:00Z","ListingId":"NST7096558","LivingArea":"1874","Longitude":"-93.259216","LotSizeArea":"0.02","LotSizeDimensions":"common","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"824","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-06-20T21:02:13Z","ParcelNumber":"353024340103","ParkingFeatures":"Attached Garage","PhotosCount":"12","PhotosChangeTimestamp":"2026-06-21T02:03:06.591Z","PostalCity":"Minneapolis","PostalCode":"55421","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(TH) Side x Side","PropertyType":"Residential","PublicRemarks":"Spacious 3 Bedrooms, Finished Basement TH, Granite Counter Tops, Stainless Steel Appliances. Many upgrades when built. Views are great of park in front. The floor plan has nice flow w/3 BR & 4 Baths. A see-through Cozy Gas fireplace between the dining area & living Aewa. The kitchen is bright, boasts an island for your convenience. Classic brick front & bay window. Best location-close to Huset Park, MASTER BR with Private Master Bathroom. , LOWER LEVEL Can be 4th Bedroom Suite if you Just add a door. Attached is 2 CAR GARAGE. Washer Dryer in the unit.","PublicSurveyRange":"24","PublicSurveySection":"35","PublicSurveyTownship":"30","NST_SchoolDistrictFullName":"13 - Columbia Heights","NST_SchoolDistrictNumber":"13","NST_SchoolDistrictPhone":"7635284500","Sewer":"City Sewer/Connected","NST_SingleFamilyTownhouseType":"Multi-Level","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NE","StreetName":"Huset","StreetNumber":"514","StreetNumberNumeric":"514","StreetSuffix":"Parkway","SubdivisionName":"Huset Park","TaxAnnualAmount":"3695","NST_TaxWithAssessments":"3695","TaxYear":"2026","NST_TotalArea":"1874","BuildingAreaTotal":"1874","Township":"Columbia Heights","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2006","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST42366","ListAgentMlsId":"NST505004198","ListOfficeMlsId":"NST3679","ListOfficeName":"MN Realty Group Inc.","ListOfficeKey":"NST14149","ModificationTimestamp":"2026-06-21T02:10:06.545Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"514 k.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922289/4e2b092e-1115-42c7-a455-9aa32c9971a4.jpeg\",\"ResourceRecordKey\":\"NST7922289\",\"ImageWidth\":1024,\"ImageHeight\":660,\"ImageSizeDescription\":\"1024x660\",\"MediaModificationTimestamp\":\"2026-06-21T02:03:04.166Z\",\"MediaKey\":\"NST123108434\"},{\"Order\":21,\"MediaObjectID\":\"NST21\",\"LongDescription\":\"Bath.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922289/b0b05d64-89f5-450c-8c50-fac8fec3eed6.jpeg\",\"ResourceRecordKey\":\"NST7922289\",\"ImageWidth\":1024,\"ImageHeight\":647,\"ImageSizeDescription\":\"1024x647\",\"MediaModificationTimestamp\":\"2026-06-21T02:03:04.158Z\",\"MediaKey\":\"NST123108440\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"514 +.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922289/077799d8-7592-48ce-8502-6a757df08ca9.jpeg\",\"ResourceRecordKey\":\"NST7922289\",\"ImageWidth\":1024,\"ImageHeight\":651,\"ImageSizeDescription\":\"1024x651\",\"MediaModificationTimestamp\":\"2026-06-21T02:03:04.243Z\",\"MediaKey\":\"NST123108437\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"514 kit dr.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922289/bdd5a794-eaed-4cb3-8efb-122c8218ad25.jpeg\",\"ResourceRecordKey\":\"NST7922289\",\"ImageWidth\":1024,\"ImageHeight\":666,\"ImageSizeDescription\":\"1024x666\",\"MediaModificationTimestamp\":\"2026-06-21T02:03:04.162Z\",\"MediaKey\":\"NST123108436\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"514 Kitchen.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922289/0048f099-ee38-4391-9dd6-01eabe68fddf.jpeg\",\"ResourceRecordKey\":\"NST7922289\",\"ImageWidth\":1024,\"ImageHeight\":677,\"ImageSizeDescription\":\"1024x677\",\"MediaModificationTimestamp\":\"2026-06-21T02:03:04.226Z\",\"MediaKey\":\"NST123108432\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"514 Kitchen 1.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922289/570cd88d-b5d3-49ff-93e0-3ba566972401.jpeg\",\"ResourceRecordKey\":\"NST7922289\",\"ImageWidth\":1024,\"ImageHeight\":666,\"ImageSizeDescription\":\"1024x666\",\"MediaModificationTimestamp\":\"2026-06-21T02:03:04.205Z\",\"MediaKey\":\"NST123108433\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"GG.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922289/6ea3d9b6-ff6f-41d6-9ae8-da45774c6322.jpeg\",\"ResourceRecordKey\":\"NST7922289\",\"ImageWidth\":1024,\"ImageHeight\":676,\"ImageSizeDescription\":\"1024x676\",\"MediaModificationTimestamp\":\"2026-06-21T02:03:04.217Z\",\"MediaKey\":\"NST123108431\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"514 Front.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922289/5051e88a-849c-43ef-995e-1da31e566b52.jpeg\",\"ResourceRecordKey\":\"NST7922289\",\"ImageWidth\":426,\"ImageHeight\":768,\"ImageSizeDescription\":\"426x768\",\"MediaModificationTimestamp\":\"2026-06-21T02:03:04.17Z\",\"MediaKey\":\"NST123108429\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"514 LR.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922289/f77f7653-6b3b-4077-8037-fe4379280c8c.jpeg\",\"ResourceRecordKey\":\"NST7922289\",\"ImageWidth\":1024,\"ImageHeight\":647,\"ImageSizeDescription\":\"1024x647\",\"MediaModificationTimestamp\":\"2026-06-21T02:03:04.181Z\",\"MediaKey\":\"NST123108438\"},{\"Order\":23,\"MediaObjectID\":\"NST23\",\"LongDescription\":\"2nd BR of 4.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922289/16928907-df98-40f3-87fd-7f905a40962c.jpeg\",\"ResourceRecordKey\":\"NST7922289\",\"ImageWidth\":1024,\"ImageHeight\":649,\"ImageSizeDescription\":\"1024x649\",\"MediaModificationTimestamp\":\"2026-06-21T02:03:04.188Z\",\"MediaKey\":\"NST123108443\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"514.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922289/2f7e0387-23cb-4647-901c-266aecea3143.jpeg\",\"ResourceRecordKey\":\"NST7922289\",\"ImageWidth\":1024,\"ImageHeight\":673,\"ImageSizeDescription\":\"1024x673\",\"MediaModificationTimestamp\":\"2026-06-21T02:03:04.162Z\",\"MediaKey\":\"NST123108435\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"514 FP.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922289/e23d35e6-771c-4bc8-87ae-4f0b3e17d5a4.jpeg\",\"ResourceRecordKey\":\"NST7922289\",\"ImageWidth\":1024,\"ImageHeight\":662,\"ImageSizeDescription\":\"1024x662\",\"MediaModificationTimestamp\":\"2026-06-21T02:03:04.174Z\",\"MediaKey\":\"NST123108439\"}]","Media__Order":"4","Media__MediaObjectID":"NST4","Media__LongDescription":"514 k.jpg","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7922289/4e2b092e-1115-42c7-a455-9aa32c9971a4.jpeg","Media__ResourceRecordKey":"NST7922289","Media__ImageWidth":"1024","Media__ImageHeight":"660","Media__ImageSizeDescription":"1024x660","Media__MediaModificationTimestamp":"6/21/2026 2:03:04 AM","Media__MediaKey":"NST123108434","Rooms":"[{\"RoomKey\":\"NST116377591\",\"RoomDimensions\":\"8x6\",\"NST_RoomSortOrder\":8,\"RoomType\":\"Deck\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116377587\",\"RoomDimensions\":\"14x10\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Den\",\"RoomLevel\":\"Lower\"},{\"RoomKey\":\"NST116377585\",\"RoomDimensions\":\"19x12\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116377588\",\"RoomDimensions\":\"16x13\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST116377593\",\"RoomDimensions\":\"6x5\",\"NST_RoomSortOrder\":10,\"RoomType\":\"Foyer\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116377586\",\"RoomDimensions\":\"14x10\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116377584\",\"RoomDimensions\":\"19x14\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116377592\",\"RoomDimensions\":\"10x7\",\"NST_RoomSortOrder\":9,\"RoomType\":\"Primary Bathroom\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST116377589\",\"RoomDimensions\":\"14x10\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST116377590\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\"}]","Rooms__RoomKey":"NST116377591","Rooms__RoomDimensions":"8x6","Rooms__NST_RoomSortOrder":"8","Rooms__RoomType":"Deck","Rooms__RoomLevel":"Main","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"514 Front.jpg\"},{\"Order\":2,\"Remarks\":\"GG.jpg\"},{\"Order\":3,\"Remarks\":\"514 Kitchen.jpg\"},{\"Order\":4,\"Remarks\":\"514 k.jpg\"},{\"Order\":5,\"Remarks\":\"514 kit dr.jpg\"},{\"Order\":6,\"Remarks\":\"514.jpg\"},{\"Order\":7,\"Remarks\":\"514 +.jpg\"},{\"Order\":8,\"Remarks\":\"514 Kitchen 1.jpg\"},{\"Order\":9,\"Remarks\":\"514 FP.jpg\"},{\"Order\":10,\"Remarks\":\"514 LR.jpg\"},{\"Order\":21,\"Remarks\":\"Bath.jpg\"},{\"Order\":23,\"Remarks\":\"2nd BR of 4.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,21,23","CustomVTourURL":""}