{"Id":564884,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7083437","MLSAGENTID":"NST506091485","MLSOFFICEID":"NST41034","ADDRESS":"15648 Emerald Drive N","ACRES":0.151,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Crawl Space","BATHSTOTAL":3.0,"BEDROOMS":2.0,"CITY":"Hugo","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":249900.0,"LASTPRICEDATE":"2026-05-29T20:49:07.803","LATITUDE":45.176867,"LENDEROWNED":"No","LISTDATE":"2026-05-29T05:00:00","LISTPRICE":249900.0,"LIVINGAREA":1568.0,"LONGITUDE":-93.018049,"MODIFICATIONTIMESTAMP":"2026-05-30T09:21:16.281","OFFICE_OFFICENAME":"Redfin Corporation","PHOTOCOUNT":6,"POSTALCODE":"55038","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this well-maintained townhome in the heart of Hugo! The main level offers a comfortable and functional layout with a spacious living room, dining area, kitchen, and convenient half bath. Upstairs, you’ll find a versatile loft space, two bedrooms, and laundry, including a private primary suite with an ensuite bath and walk-in closet. Enjoy low-maintenance living in a convenient location near parks, schools, shopping, dining, and easy access to I-35E. The community gazebo adds an extra touch of charm to this inviting home! Mortgage savings may be available for buyers of this listing.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years","SCHOOLDISTRICTNUMBER":"624-White Bear Lake","SCHOOLDISTRICTPHONE":"6514077500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-05-29T20:49:07.803","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-Single Family","VIRTUALTOUR_URL1":"https://my.matterport.com/show/?m=6YdJgLv3otY&mls=1","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-05-29T20:49:07.803","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1_02.jpg\"},{\"Order\":2,\"Remarks\":\"6_06.jpg\"},{\"Order\":3,\"Remarks\":\"14_14.jpg\"},{\"Order\":4,\"Remarks\":\"30_30.jpg\"},{\"Order\":5,\"Remarks\":\"4_04.jpg\"},{\"Order\":6,\"Remarks\":\"15648EmeraldDrN2_ykwm3ar9x8y5b7im4qtkg1epc_1.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6","SOURCE":"MG_NST"}
{"ListingKey":"NST7909856","NST_AboveGradeSqFtTotal":"1568","AboveGradeFinishedArea":"1568","AccessibilityFeatures":"Accessible for Hearing-Impairment","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ethernet Wired,Primary Bedroom Walk-In Closet,Patio,In-Ground Sprinkler,Vaulted Ceiling(s),Washer/Dryer Hookup,Walk-In Closet","Appliances":"Dishwasher,Microwave,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"True","AssociationAmenities":"None","AssociationFee":"379","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Hazard Insurance,Lawn Care,Maintenance Grounds,Professional Mgmt,Sanitation,Sewer,Snow Removal,Water","AssociationName":"Heritage Ponds Association","AssociationPhone":"7534240300","Basement":"Crawl Space","BasementYN":"False","NST_BathDesc":"Main Floor 1/2 Bath,Separate Tub & Shower,Upper Level Full Bath,Jetted Tub","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"12","City":"Hugo","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Washington","NST_DPResource":"Yes","NST_DiningRoomDescription":"Breakfast Bar,Informal Dining Room","Directions":"35E to Cty Rd 14 E, N on Elmcrest, E on Heritage Pkwy","DocumentsCount":"5","DocumentsChangeTimestamp":"2026-05-29T20:49:07.803Z","DaysOnMarket":"0","Electric":"Circuit Breakers","ExteriorFeatures":"Vinyl","Fencing":"None","FireplaceFeatures":"Electric,Living Room","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"576","FoundationDetails":"Slab","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric,Natural Gas","NST_GarageSquareFeet":"440","GarageSpaces":"2","Heating":"Fireplace(s)","HighSchoolDistrict":"White Bear Lake","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.176867","LaundryFeatures":"Electric Dryer Hookup,Laundry Closet,Upper Level,Washer Hookup","NST_LenderOwned":"No","Levels":"Two","ListPrice":"249900","ListingContractDate":"2026-05-29T05:00:00Z","ListingId":"NST7083437","LivingArea":"1568","LockBoxType":"Supra","Longitude":"-93.018049","LotSizeArea":"0.151","LotSizeDimensions":"Common","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"576","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-05-29T15:48:13Z","ParcelNumber":"1803121230100","ParkingFeatures":"Attached Garage,Concrete,Garage Door Opener,Guest Parking","NST_PatioPorchType":"Patio","PhotosCount":"6","PhotosChangeTimestamp":"2026-05-29T20:49:07.803Z","PoolFeatures":"None","PostalCity":"Hugo","PostalCode":"55038","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(TH) Side x Side","PropertyType":"Residential","PublicRemarks":"Welcome to this well-maintained townhome in the heart of Hugo! The main level offers a comfortable and functional layout with a spacious living room, dining area, kitchen, and convenient half bath. Upstairs, you’ll find a versatile loft space, two bedrooms, and laundry, including a private primary suite with an ensuite bath and walk-in closet. Enjoy low-maintenance living in a convenient location near parks, schools, shopping, dining, and easy access to I-35E. The community gazebo adds an extra touch of charm to this inviting home! Mortgage savings may be available for buyers of this listing.","PublicSurveyRange":"21","PublicSurveySection":"18","PublicSurveyTownship":"31","RoadFrontageType":"City Street,Paved Streets,Sidewalks","RoadResponsibility":"Association Maintained Road","Roof":"Age Over 8 Years","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":"2817","NST_TaxWithAssessments":"2820","TaxYear":"2025","NST_TotalArea":"1568","BuildingAreaTotal":"1568","Township":"Hugo","UnitNumber":"2","VideosCount":"1","VideosChangeTimestamp":"2026-05-29T20:36:32Z","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2005","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST18007","ListAgentMlsId":"NST506091485","ListOfficeMlsId":"NST41034","ListOfficeName":"Redfin Corporation","ListOfficeKey":"NST21063","VirtualTourURLUnbranded":"https://my.matterport.com/show/?m=6YdJgLv3otY&mls=1","ModificationTimestamp":"2026-05-30T09:21:16.281Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"6_06.jpg\",\"ResourceRecordKey\":\"NST7909856\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909856/a85c08c3-f3ae-4c9b-9440-9564456171b1.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-05-29T20:42:12.789Z\",\"MediaKey\":\"NST122589013\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"14_14.jpg\",\"ResourceRecordKey\":\"NST7909856\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909856/303d1dfd-33f4-4ad4-8c52-2e584c2a5e20.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-05-29T20:48:11.027Z\",\"MediaKey\":\"NST122589020\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"30_30.jpg\",\"ResourceRecordKey\":\"NST7909856\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909856/d100c837-55ea-4a02-bca2-606d0399a8d4.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-05-29T20:48:11.075Z\",\"MediaKey\":\"NST122589031\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"15648EmeraldDrN2_ykwm3ar9x8y5b7im4qtkg1epc_1.jpg\",\"ResourceRecordKey\":\"NST7909856\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909856/ea84501c-8197-4d7d-858b-375ff6e5b50c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1471,\"ImageSizeDescription\":\"2080x1471\",\"MediaModificationTimestamp\":\"2026-05-29T20:48:11.066Z\",\"MediaKey\":\"NST122589037\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"1_02.jpg\",\"ResourceRecordKey\":\"NST7909856\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909856/8b0afc46-3001-48c3-881c-6abacdb65fa1.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-05-29T20:42:12.79Z\",\"MediaKey\":\"NST122589012\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"4_04.jpg\",\"ResourceRecordKey\":\"NST7909856\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909856/50572046-c940-4cde-8e8b-fa3e361c1c12.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-05-29T20:48:11.045Z\",\"MediaKey\":\"NST122589036\"}]","Media__Order":"2","Media__MediaObjectID":"NST2","Media__LongDescription":"6_06.jpg","Media__ResourceRecordKey":"NST7909856","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7909856/a85c08c3-f3ae-4c9b-9440-9564456171b1.jpeg","Media__ImageWidth":"2048","Media__ImageHeight":"1365","Media__ImageSizeDescription":"2048x1365","Media__MediaModificationTimestamp":"5/29/2026 8:42:12 PM","Media__MediaKey":"NST122589013","Rooms":"[{\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116294106\",\"RoomDimensions\":\"10x11\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116294105\",\"RoomDimensions\":\"21x12\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116294104\",\"RoomDimensions\":\"21x9\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116294108\",\"RoomDimensions\":\"12x18\",\"RoomType\":\"Loft\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116294107\",\"RoomDimensions\":\"18x13\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\"}]","Rooms__NST_RoomSortOrder":"3","Rooms__RoomKey":"NST116294106","Rooms__RoomDimensions":"10x11","Rooms__RoomType":"Bedroom","Rooms__RoomLevel":"Upper","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1_02.jpg\"},{\"Order\":2,\"Remarks\":\"6_06.jpg\"},{\"Order\":3,\"Remarks\":\"14_14.jpg\"},{\"Order\":4,\"Remarks\":\"30_30.jpg\"},{\"Order\":5,\"Remarks\":\"4_04.jpg\"},{\"Order\":6,\"Remarks\":\"15648EmeraldDrN2_ykwm3ar9x8y5b7im4qtkg1epc_1.jpg\"}]","PhotoOrder":"1,2,3,4,5,6","CustomVTourURL":""}