$LABEL$$CONTENT$
$DESC$
MLS# 7166398 - 15648 Emerald Drive N Hugo, MN 55038
Rosie Schueller is the brokerage office representing the seller for this listing.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Cummings Janzen Realty, Inc. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Cummings Janzen Realty, Inc., a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
{"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-30T00:29:10.93","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","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-30T00:29:10.93Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://media.mlsgrid.com/token=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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=Xf75rAH5SQV3PMMvdfo3teX5zm6vrH8IfXUBHhZnqH4&expires=1793324664&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":""}