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":629359,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7166398","MLSAGENTID":"NST502041478","MLSOFFICEID":"NST41104","ADDRESS":"15648 Emerald Drive N","ACRES":0.151,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":3.0,"BEDROOMS":3.0,"CITY":"Hugo","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":299000.0,"LASTPRICEDATE":"2026-10-29T22:27:08.86","LATITUDE":45.176867,"LENDEROWNED":"No","LISTDATE":"2026-10-29T05:00:00","LISTPRICE":299000.0,"LIVINGAREA":1755.0,"LONGITUDE":-93.018049,"MODIFICATIONTIMESTAMP":"2026-10-30T10:10:14.806","OFFICE_OFFICENAME":"Rosie Schueller","PHOTOCOUNT":15,"POSTALCODE":"55038","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"624-White Bear Lake","SCHOOLDISTRICTPHONE":"6514077500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-10-29T22:27:08.86","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Emerald","STREETNUMBER":"15648","STREETSUFFIX":"Drive","STYLE":"(TH) Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2005,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-10-30T00:29:10.93","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"15648 Emerald Dr N Unit 4, Hugo MN 55038\"},{\"Order\":2,\"Remarks\":\"Hall to Owners suite and loft.\"},{\"Order\":3,\"Remarks\":\"Hall to bedrooms 2 & 3 and 2nd floor restroom.\"},{\"Order\":4,\"Remarks\":\"Loft\"},{\"Order\":5,\"Remarks\":\"Bedroom 3\"},{\"Order\":6,\"Remarks\":\"Bedroom 2\"},{\"Order\":7,\"Remarks\":\"1000056719.jpg\"},{\"Order\":8,\"Remarks\":\"2nd floor Shared Bathroom\"},{\"Order\":9,\"Remarks\":\"Second Floor Laundry room/ Utility room.\"},{\"Order\":10,\"Remarks\":\"Owners Bathroom Suite\"},{\"Order\":11,\"Remarks\":\"Stairs to 2nd floor\"},{\"Order\":12,\"Remarks\":\"Main floor half bath.\"},{\"Order\":13,\"Remarks\":\"Beautiful KitchenAid Appliances, Countertop seating, New carpet and paint throughout.\"},{\"Order\":14,\"Remarks\":\"Owners Suite Closet\"},{\"Order\":15,\"Remarks\":\"Garage\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","SOURCE":"MG_NST"}
{"ListingKey":"NST7991690","NST_AboveGradeSqFtTotal":"1755","AboveGradeFinishedArea":"1755","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","Appliances":"Dishwasher,Disposal,Dryer,Exhaust Fan,Gas Water Heater,Microwave,Refrigerator,Stainless Steel Appliances,Washer,Water Softener Owned","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"True","AssociationFee":"293","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Lawn Care,Maintenance Grounds,Professional Mgmt,Sanitation,Sewer,Snow Removal,Water","AssociationName":"Heritage Heights","AssociationPhone":"6517626300","Basement":"None","BasementYN":"False","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Hugo","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Washington","NST_DPResource":"Yes","Directions":"North on 35E to Main Street exit in Hugo MN - Right Main to 24th - right on 24th to 158th st - turn right to Express Ave - turn right to Emerald Dr - turn right","DocumentsCount":"0","DaysOnMarket":"0","NST_DomIncrementTimestamp":"2026-10-29","NST_DomIncrementYN":"true","ExteriorFeatures":"Vinyl","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1135","FoundationDetails":"Slab","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"400","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"White Bear Lake","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.176867","LaundryFeatures":"Laundry Room","NST_LenderOwned":"No","Levels":"Two","ListPrice":"299000","ListingContractDate":"2026-10-29T05:00:00Z","ListingId":"NST7166398","LivingArea":"1755","LockBoxType":"Combo","Longitude":"-93.018049","LotSizeArea":"0.151","LotSizeDimensions":"Common","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1135","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-10-29T17:13:44Z","ParcelNumber":"1803121230102","ParkingFeatures":"Attached Garage","NST_PatioPorchType":"Deck","PhotosCount":"15","PhotosChangeTimestamp":"2026-10-30T00:29:10.93Z","PoolFeatures":"None","PostalCity":"Hugo","PostalCode":"55038","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(TH) Side x Side","PropertyType":"Residential","PublicSurveyRange":"21","PublicSurveySection":"18","PublicSurveyTownship":"31","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Y","NST_SchoolDistrictFullName":"624 - White Bear Lake","NST_SchoolDistrictNumber":"624","NST_SchoolDistrictPhone":"6514077500","Sewer":"City Sewer/Connected","NST_SingleFamilyTownhouseType":"Multi-Level","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Emerald","StreetNumber":"15648","StreetNumberNumeric":"15648","StreetSuffix":"Drive","SubdivisionName":"Cic 256","TaxAnnualAmount":"3281","NST_TaxWithAssessments":"3284","TaxYear":"2026","NST_TotalArea":"1755","BuildingAreaTotal":"1755","Township":"Hugo","UnitNumber":"4","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2005","ZoningDescription":"Residential-Multi-Family","ListAgentKey":"NST96814","ListAgentMlsId":"NST502041478","ListOfficeMlsId":"NST41104","ListOfficeName":"Rosie Schueller","ListOfficeKey":"NST21144","ModificationTimestamp":"2026-10-30T10:10:14.806Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/bf3837bd-c35d-4923-8aaa-4bfe3e29e6a8.jpeg\",\"LongDescription\":\"Beautiful KitchenAid Appliances, Countertop seating, New carpet and paint throughout.\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-10-29T22:14:13.258Z\",\"MediaKey\":\"NST125658913\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/a8e3bacb-6bcc-4157-b1a9-8018cab2faf4.jpeg\",\"LongDescription\":\"Owners Suite Closet\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaModificationTimestamp\":\"2026-10-29T22:14:13.295Z\",\"MediaKey\":\"NST125664610\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/ae370391-1351-470b-beca-b2b0d947369b.jpeg\",\"LongDescription\":\"Loft\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-10-29T22:14:13.274Z\",\"MediaKey\":\"NST125658923\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/ab180605-e30f-4281-ab52-ac571dbf3d48.jpeg\",\"LongDescription\":\"Garage\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-10-29T22:14:13.322Z\",\"MediaKey\":\"NST125665142\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/34acf39c-6877-4b64-ba41-d69213be20ec.jpeg\",\"LongDescription\":\"Second Floor Laundry room/ Utility room.\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-10-29T22:14:13.306Z\",\"MediaKey\":\"NST125658916\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/0128e550-b6ad-48f2-9991-a702cd036e85.jpeg\",\"LongDescription\":\"1000056719.jpg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaModificationTimestamp\":\"2026-10-30T00:29:09.759Z\",\"MediaKey\":\"NST125658917\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/fb4966f1-cfbe-43e4-86dc-021897ef0a60.jpeg\",\"LongDescription\":\"Main floor half bath.\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaModificationTimestamp\":\"2026-10-29T22:14:13.264Z\",\"MediaKey\":\"NST125658914\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/e3adb4e2-b5b9-4a54-967e-baa8d1851d7b.jpeg\",\"LongDescription\":\"Hall to bedrooms 2 & 3 and 2nd floor restroom.\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaModificationTimestamp\":\"2026-10-30T00:29:09.709Z\",\"MediaKey\":\"NST125658925\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/1fa3fdae-002a-4d09-9141-0cef27482753.jpeg\",\"LongDescription\":\"Hall to Owners suite and loft.\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaModificationTimestamp\":\"2026-10-30T00:29:09.741Z\",\"MediaKey\":\"NST125658924\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/a9baa3d4-acd6-46cc-a617-371fa9c3555a.jpeg\",\"LongDescription\":\"2nd floor Shared Bathroom\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaModificationTimestamp\":\"2026-10-30T00:29:09.797Z\",\"MediaKey\":\"NST125658918\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/22098a30-ffc5-4e01-8058-98ef3db64308.jpeg\",\"LongDescription\":\"Bedroom 2\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-10-29T22:14:13.313Z\",\"MediaKey\":\"NST125658921\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/85cfa51e-7a77-4aa3-9fc1-f65db3971d5d.jpeg\",\"LongDescription\":\"Stairs to 2nd floor\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaModificationTimestamp\":\"2026-10-29T22:14:13.308Z\",\"MediaKey\":\"NST125658915\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/17c3b13f-10a7-4f01-9992-d225de6e3313.jpeg\",\"LongDescription\":\"15648 Emerald Dr N Unit 4, Hugo MN 55038\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":999,\"ImageHeight\":815,\"ImageSizeDescription\":\"999x815\",\"MediaModificationTimestamp\":\"2026-10-30T00:29:09.814Z\",\"MediaKey\":\"NST125658850\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/7c3aa8b1-f74e-4d18-8d67-ed1157f70588.jpeg\",\"LongDescription\":\"Bedroom 3\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-10-29T22:14:13.293Z\",\"MediaKey\":\"NST125658922\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/29eb9c3d-4484-4e0e-864c-15cd9a14e1d1.jpeg\",\"LongDescription\":\"Owners Bathroom Suite\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7991690\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaModificationTimestamp\":\"2026-10-29T22:14:13.317Z\",\"MediaKey\":\"NST125663835\"}]","Media__MediaURL":"https://media.mlsgrid.com/token=Jl5cW84ADiOCfvQ0kAtHn0vPPpXAz3xCKKogAcCaaBw&expires=1793358666&id=5d6fc86794c5224544394849/images/NST7991690/bf3837bd-c35d-4923-8aaa-4bfe3e29e6a8.jpeg","Media__LongDescription":"Beautiful KitchenAid Appliances, Countertop seating, New carpet and paint throughout.","Media__Order":"13","Media__MediaObjectID":"NST13","Media__ResourceRecordKey":"NST7991690","Media__ImageWidth":"2048","Media__ImageHeight":"1536","Media__ImageSizeDescription":"2048x1536","Media__MediaModificationTimestamp":"10/29/2026 10:14:13 PM","Media__MediaKey":"NST125658913","DocumentsChangeTimestamp":"2026-10-29T22:14:09.461Z","Rooms":"[{\"RoomType\":\"Dining Room\",\"RoomDimensions\":\"10x8\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116800582\"},{\"RoomType\":\"Bedroom\",\"RoomDimensions\":\"21x16\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116800586\"},{\"RoomType\":\"Kitchen\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116800583\"},{\"RoomType\":\"Living Room\",\"RoomDimensions\":\"18x15\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116800584\"},{\"RoomType\":\"Loft\",\"RoomDimensions\":\"12x9\",\"NST_RoomSortOrder\":8,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116800589\"},{\"RoomType\":\"Patio\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116800585\"},{\"RoomType\":\"Bedroom 2\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116800587\"},{\"RoomType\":\"Bedroom 3\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116800588\"}]","Rooms__RoomType":"Dining Room","Rooms__RoomDimensions":"10x8","Rooms__NST_RoomSortOrder":"1","Rooms__RoomLevel":"Main","Rooms__RoomKey":"NST116800582","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"15648 Emerald Dr N Unit 4, Hugo MN 55038\"},{\"Order\":2,\"Remarks\":\"Hall to Owners suite and loft.\"},{\"Order\":3,\"Remarks\":\"Hall to bedrooms 2 & 3 and 2nd floor restroom.\"},{\"Order\":4,\"Remarks\":\"Loft\"},{\"Order\":5,\"Remarks\":\"Bedroom 3\"},{\"Order\":6,\"Remarks\":\"Bedroom 2\"},{\"Order\":7,\"Remarks\":\"1000056719.jpg\"},{\"Order\":8,\"Remarks\":\"2nd floor Shared Bathroom\"},{\"Order\":9,\"Remarks\":\"Second Floor Laundry room/ Utility room.\"},{\"Order\":10,\"Remarks\":\"Owners Bathroom Suite\"},{\"Order\":11,\"Remarks\":\"Stairs to 2nd floor\"},{\"Order\":12,\"Remarks\":\"Main floor half bath.\"},{\"Order\":13,\"Remarks\":\"Beautiful KitchenAid Appliances, Countertop seating, New carpet and paint throughout.\"},{\"Order\":14,\"Remarks\":\"Owners Suite Closet\"},{\"Order\":15,\"Remarks\":\"Garage\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","CustomVTourURL":""}