{"Id":585208,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7100245","MLSAGENTID":"NST502051468","MLSOFFICEID":"NST252847","ADDRESS":"500 Robert Street N","ACRES":0.647,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":1.0,"BEDROOMS":0.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":192500.0,"LASTPRICEDATE":"2026-07-13T18:02:06.86","LATITUDE":44.951142,"LENDEROWNED":"No","LISTDATE":"2026-06-26T05:00:00","LISTPRICE":192500.0,"LIVINGAREA":1014.0,"LONGITUDE":-93.094138,"MODIFICATIONTIMESTAMP":"2026-07-13T18:22:06.298","NEIGHBORHOOD":"91","OFFICE_OFFICENAME":"Cobalt Property Management LLC","PHOTOCOUNT":12,"POSTALCODE":"55101","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"True artist's loft in historical Rossmor building! Numerous upgrades include kitchen cabinets with under-cabinet lighting, granite counter tops, and subway tile back splash. Brand-new stainless steel appliances: Refrigerator with ice-maker and Air-Fryer oven, dishwasher, and over-the-stove microwave. Modern ceiling fan and light fixtures, closet shelving, custom blinds, stone vessel sink, and European soaking tub. Storage loft above bathroom.\n\nFREE laundry is available on every floor and there is abundant storage space in unit. South-facing 8-foot windows provide beautiful morning sunlight and a great view of downtown Saint Paul. Additional storage and band-practice space available in lower level of building for an additional cost.\n\nThis is truly an urban loft in a lively area: Sawadtee Thai Restaurant, Camp Bar and Cabaret, and Keys Cafe are all on street level. New Aldi grocery store soon to open across the street and the light rail line to Minneapolis is just two blocks away.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-07-13T18:02:06.86","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Robert","STREETNUMBER":"500","STREETSUFFIX":"Street","STYLE":"(CC) High Rise (4+ Levels)","TRANSACTIONTYPE":"For Sale","WATER":"City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1916,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-07-13T18:18:07.476","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Living Space 1\"},{\"Order\":2,\"Remarks\":\"Living Space 2\"},{\"Order\":3,\"Remarks\":\"Living Space 3\"},{\"Order\":4,\"Remarks\":\"Kitchen 1\"},{\"Order\":5,\"Remarks\":\"Kitchen 2\"},{\"Order\":6,\"Remarks\":\"Kitchen 3\"},{\"Order\":7,\"Remarks\":\"Entry Way\"},{\"Order\":8,\"Remarks\":\"Bathroom 1\"},{\"Order\":9,\"Remarks\":\"Bathroom 2\"},{\"Order\":10,\"Remarks\":\"Bathroom 3\"},{\"Order\":11,\"Remarks\":\"Walk-In Closet\"},{\"Order\":12,\"Remarks\":\"Rossmor Building.png\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12","SOURCE":"MG_NST"}
{"ListingKey":"NST7926504","NST_AboveGradeSqFtTotal":"1014","AboveGradeFinishedArea":"1014","AccessibilityFeatures":"Doors 36\"+,Fully Wheelchair,Hallways 42\"+","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Yes","AssociationYN":"True","AssociationFee":"460","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Hazard Insurance,Lawn Care,Maintenance Grounds,Professional Mgmt,Sanitation,Security System,Sewer,Shared Amenities,Snow Removal,Water","AssociationName":"First Residential","AssociationPhone":"9522772700","Basement":"None","BasementYN":"False","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"0","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"Robert street N between 9th and 10th Streets. Use 10th Street entrance.","DocumentsCount":"4","DocumentsChangeTimestamp":"2026-06-30T18:45:08.846Z","DaysOnMarket":"0","NST_ExpectedMarketDate":"2026-07-03","ExteriorFeatures":"Other","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1014","FoundationDetails":"Combination","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","GarageSpaces":"0","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.951142","LaundryFeatures":"Common Area","NST_LenderOwned":"No","Levels":"One","ListPrice":"192500","ListingContractDate":"2026-06-26T05:00:00Z","ListingId":"NST7100245","LivingArea":"1014","Longitude":"-93.094138","LotSizeArea":"0.647","LotSizeDimensions":"Common","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1014","NST_ManufacturedHome":"N","NST_NeighborhoodName":"Downtown","NST_NeighborhoodNumber":"91","OriginalEntryTimestamp":"2026-07-03T00:00:21Z","ParcelNumber":"312922431408","ParkingFeatures":"Parking Lot","PhotosCount":"12","PhotosChangeTimestamp":"2026-07-13T18:18:07.476Z","PostalCity":"Saint Paul","PostalCode":"55101","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(CC) High Rise (4+ Levels)","PropertyType":"Residential","PublicRemarks":"True artist's loft in historical Rossmor building! Numerous upgrades include kitchen cabinets with under-cabinet lighting, granite counter tops, and subway tile back splash. Brand-new stainless steel appliances: Refrigerator with ice-maker and Air-Fryer oven, dishwasher, and over-the-stove microwave. Modern ceiling fan and light fixtures, closet shelving, custom blinds, stone vessel sink, and European soaking tub. Storage loft above bathroom.\n\nFREE laundry is available on every floor and there is abundant storage space in unit. South-facing 8-foot windows provide beautiful morning sunlight and a great view of downtown Saint Paul. Additional storage and band-practice space available in lower level of building for an additional cost.\n\nThis is truly an urban loft in a lively area: Sawadtee Thai Restaurant, Camp Bar and Cabaret, and Keys Cafe are all on street level. New Aldi grocery store soon to open across the street and the light rail line to Minneapolis is just two blocks away.","PublicSurveyRange":"22","PublicSurveySection":"31","PublicSurveyTownship":"29","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Y","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer - In Street","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Robert","StreetNumber":"500","StreetNumberNumeric":"500","StreetSuffix":"Street","SubdivisionName":"Cic 535 Rossmor","TaxAnnualAmount":"3138","NST_TaxWithAssessments":"3138","TaxYear":"2025","NST_TotalArea":"1014","BuildingAreaTotal":"1014","Township":"Saint Paul","UnitNumber":"502","VideosCount":"0","WaterSource":"City Water - In Street","WaterfrontYN":"False","YearBuilt":"1916","ZoningDescription":"Residential-Multi-Family","ListAgentKey":"NST230332","ListAgentMlsId":"NST502051468","ListOfficeMlsId":"NST252847","ListOfficeName":"Cobalt Property Management LLC","ListOfficeKey":"NST1001589","ModificationTimestamp":"2026-07-13T18:22:06.298Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7926504\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926504/56ff3204-f1b4-4eef-a440-cdde1bb83851.jpeg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"Walk-In Closet\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-07-13T18:17:18.993Z\",\"MediaKey\":\"NST123374489\"},{\"ResourceRecordKey\":\"NST7926504\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926504/24dea239-7435-41be-ae04-350994e231de.jpeg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"Bathroom 2\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-07-13T18:17:19.066Z\",\"MediaKey\":\"NST123374487\"},{\"ResourceRecordKey\":\"NST7926504\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926504/06023dd3-6bd1-40bc-a802-51efd84ff98e.jpeg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"Bathroom 3\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-07-13T18:17:19.044Z\",\"MediaKey\":\"NST123374493\"},{\"ResourceRecordKey\":\"NST7926504\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926504/51a2b01d-e597-4f85-b2e4-a23b082422ab.jpeg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"Bathroom 1\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-07-13T18:17:18.98Z\",\"MediaKey\":\"NST123374490\"},{\"ResourceRecordKey\":\"NST7926504\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926504/02aaf782-1b09-4b44-941a-28f1f2ccc752.jpeg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"Rossmor Building.png\",\"ImageWidth\":997,\"ImageHeight\":864,\"ImageSizeDescription\":\"997x864\",\"MediaModificationTimestamp\":\"2026-07-13T18:17:19.006Z\",\"MediaKey\":\"NST123374501\"},{\"ResourceRecordKey\":\"NST7926504\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926504/ffaa0c2c-b110-4187-89d1-f49b1237a0db.jpeg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"Entry Way\",\"ImageWidth\":1086,\"ImageHeight\":1448,\"ImageSizeDescription\":\"1086x1448\",\"MediaModificationTimestamp\":\"2026-07-13T18:17:19.099Z\",\"MediaKey\":\"NST123374496\"},{\"ResourceRecordKey\":\"NST7926504\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926504/5512a8f4-7f09-48aa-8b45-31d62b14fd5b.jpeg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"Living Space 2\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-07-13T18:17:19.041Z\",\"MediaKey\":\"NST123561847\"},{\"ResourceRecordKey\":\"NST7926504\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926504/1dd52663-99c2-4f39-a9cc-885f2bb12d66.jpeg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"Kitchen 2\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-07-13T18:17:19.066Z\",\"MediaKey\":\"NST123374494\"},{\"ResourceRecordKey\":\"NST7926504\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926504/acec2c20-6245-4e61-ab33-462c39b5b579.jpeg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"Kitchen 1\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-07-13T18:17:19.115Z\",\"MediaKey\":\"NST123561861\"},{\"ResourceRecordKey\":\"NST7926504\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926504/d04f66f8-5d5c-463c-a5be-24c8c26d73b5.jpeg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"Living Space 1\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-07-13T18:17:19.138Z\",\"MediaKey\":\"NST123562043\"},{\"ResourceRecordKey\":\"NST7926504\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926504/f0c1570a-a6b7-4615-9243-ec5ee943bbbb.jpeg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"Kitchen 3\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-07-13T18:17:19.1Z\",\"MediaKey\":\"NST123374495\"},{\"ResourceRecordKey\":\"NST7926504\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926504/ceb1c36c-1643-4026-870d-3c4df4748c4d.jpeg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"Living Space 3\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-07-13T18:17:19.017Z\",\"MediaKey\":\"NST123562234\"}]","Media__ResourceRecordKey":"NST7926504","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7926504/56ff3204-f1b4-4eef-a440-cdde1bb83851.jpeg","Media__Order":"11","Media__MediaObjectID":"NST11","Media__LongDescription":"Walk-In Closet","Media__ImageWidth":"1560","Media__ImageHeight":"2080","Media__ImageSizeDescription":"1560x2080","Media__MediaModificationTimestamp":"7/13/2026 6:17:18 PM","Media__MediaKey":"NST123374489","Rooms":"[{\"RoomKey\":\"NST116401672\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Other\"}]","Rooms__RoomKey":"NST116401672","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"1","Rooms__RoomType":"Other","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Living Space 1\"},{\"Order\":2,\"Remarks\":\"Living Space 2\"},{\"Order\":3,\"Remarks\":\"Living Space 3\"},{\"Order\":4,\"Remarks\":\"Kitchen 1\"},{\"Order\":5,\"Remarks\":\"Kitchen 2\"},{\"Order\":6,\"Remarks\":\"Kitchen 3\"},{\"Order\":7,\"Remarks\":\"Entry Way\"},{\"Order\":8,\"Remarks\":\"Bathroom 1\"},{\"Order\":9,\"Remarks\":\"Bathroom 2\"},{\"Order\":10,\"Remarks\":\"Bathroom 3\"},{\"Order\":11,\"Remarks\":\"Walk-In Closet\"},{\"Order\":12,\"Remarks\":\"Rossmor Building.png\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12","CustomVTourURL":""}