{"Id":491779,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6809696","MLSAGENTID":"NST506008884","MLSOFFICEID":"NST1865","ADDRESS":"820 Emerald Street","ACRES":0.907,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":2.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":270000.0,"LASTPRICEDATE":"2026-04-18T04:16:05.213","LATITUDE":44.965538,"LENDEROWNED":"No","LISTDATE":"2025-10-27T05:00:00","LISTPRICE":265900.0,"LIVINGAREA":930.0,"LONGITUDE":-93.207381,"MODIFICATIONTIMESTAMP":"2026-04-18T04:16:05.213","NEIGHBORHOOD":"99","OFFICE_OFFICENAME":"Keller Williams Classic Realty","PHOTOCOUNT":1,"POSTALCODE":"55114","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-30T05:02:08.267","LASTSTATUS":"Coming Soon","STREETNAME":"Emerald Street","STREETNUMBER":"820","STYLE":"(CC) High Rise (4+ Levels)","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2003,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-10-29T18:40:03.707","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"02_820_Emerald_St_3072_mls.jpg\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"NST_AboveGradeSqFtTotal":"930","AboveGradeFinishedArea":"930","AccessibilityFeatures":"Accessible Elevator Installed","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Balcony","Appliances":"Dishwasher,Dryer,Electric Water Heater,Microwave,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"True","AssociationFee":"516.62","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Cable TV,Hazard Insurance,Internet,Lawn Care,Maintenance Grounds,Parking,Professional Mgmt,Sanitation,Security System,Sewer,Shared Amenities,Snow Removal,Water","AssociationName":"First Service Residential","AssociationPhone":"9522772700","Basement":"None","BasementYN":"False","NST_BathDesc":"Main Floor 1/2 Bath,Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"I-94 to Hwy. 280, N. immediate exit at Franklin Ave., East 5-blks on Franklin to Emerald, N. to 820\nbuilding.","DocumentsCount":"2","DocumentsChangeTimestamp":"2025-11-04T04:41:04.032Z","DaysOnMarket":"0","NST_ExpectedMarketDate":"2025-10-30","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"930","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"50","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.965538","NST_LenderOwned":"No","Levels":"One","ListPrice":"265900","ListingContractDate":"2025-10-27T05:00:00Z","ListingId":"NST6809696","ListingKey":"NST7820480","LivingArea":"930","LockBoxType":"Combo","Longitude":"-93.207381","LotSizeArea":"0.907","LotSizeDimensions":"n/a","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"930","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"99","OriginalEntryTimestamp":"2025-10-30T00:00:05Z","ParcelNumber":"TBD","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Attached Garage,Underground","PhotosCount":"1","PhotosChangeTimestamp":"2025-10-29T18:40:03.707Z","PostalCity":"Saint Paul","PostalCode":"55114","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(CC) High Rise (4+ Levels)","PropertyType":"Residential","PublicSurveyRange":"23","PublicSurveySection":"29","PublicSurveyTownship":"29","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Emerald Street","StreetNumber":"820","StreetNumberNumeric":"820","SubdivisionName":"Cic 486 Emerald Gardens","TaxAnnualAmount":"4314","NST_TaxWithAssessments":"4314","TaxYear":"2025","BuildingAreaTotal":"930","Township":"Saint Paul","UnitNumber":"307","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"2003","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST98319","ListAgentMlsId":"NST506008884","ListOfficeMlsId":"NST1865","ListOfficeName":"Keller Williams Classic Realty","ListOfficeKey":"NST14003","ModificationTimestamp":"2026-04-18T04:16:05.213Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"02_820_Emerald_St_3072_mls.jpg\",\"ResourceRecordKey\":\"NST7820480\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":1919,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1919x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7820480/dec7895d-7c0c-4569-b09f-8c897771d8ec.jpeg\",\"MediaModificationTimestamp\":\"2025-10-29T18:39:39.343Z\",\"MediaKey\":\"69025f6bb5918138cd3f6457\"}]","Media__LongDescription":"02_820_Emerald_St_3072_mls.jpg","Media__ResourceRecordKey":"NST7820480","Media__Order":"1","Media__MediaObjectID":"NST1","Media__ImageWidth":"1919","Media__ImageHeight":"1280","Media__ImageSizeDescription":"1919x1280","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7820480/dec7895d-7c0c-4569-b09f-8c897771d8ec.jpeg","Media__MediaModificationTimestamp":"10/29/2025 6:39:39 PM","Media__MediaKey":"69025f6bb5918138cd3f6457","Rooms":"[{\"RoomKey\":\"NST115732635\",\"RoomLevel\":\"Main\",\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"13x9\"},{\"RoomKey\":\"NST115732637\",\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"18x13\"},{\"RoomKey\":\"NST115732636\",\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"10x8\"},{\"RoomKey\":\"NST115732634\",\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"14x13\"},{\"RoomKey\":\"NST115732638\",\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"12x11\"}]","Rooms__RoomKey":"NST115732635","Rooms__RoomLevel":"Main","Rooms__RoomType":"Dining Room","Rooms__NST_RoomSortOrder":"2","Rooms__RoomDimensions":"13x9","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"02_820_Emerald_St_3072_mls.jpg\"}]","PhotoOrder":"1","CustomVTourURL":""}