{"Id":1414811,"ORGTABLE":"RAW_Property","MLSCLASS":"COM","MLSNUMBER":"NST6796360","MLSAGENTID":"NST506091606","MLSOFFICEID":"NST8107","ADDRESS":"237 Richmond Street","ACRES":0.12,"AGENTOWNER":false,"AUCTIONYN":false,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","CURRENTUSE":"Automotive,Vacant","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block","FORECLOSURE":"No","LASTPRICE":300000.0,"LASTPRICEDATE":"2025-09-30T14:30:04.26","LATITUDE":44.934308,"LENDEROWNED":"No","LISTDATE":"2025-09-29T05:00:00","LISTPRICE":300000.0,"LIVINGAREA":900.0,"LONGITUDE":-93.118741,"LOTDESCRIPTION":"Corner Lot","MODIFICATIONTIMESTAMP":"2025-09-30T14:30:04.259","NEIGHBORHOOD":"West Seventh","OFFICE_OFFICENAME":"Edina Realty, Inc.","PHOTOCOUNT":9,"POSTALCODE":"55102","POTENTIALSHORTSALE":"No","PUBLICREMARKS":"Great location on the corner of St Clair and Richmond. Was formally an auto repair service station. Garage comes with two lifts, one air compressor and most everything you see fastened to the walls. Small \n1/4 bathroom. Off street parking for eight cars, Central Saint Paul location in up and coming west 7th area. The property is currently zoned T2. Tons of options for this property. Would need a conditional use permit to be used as an auto repair shop.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Flat","SALEINCLUDES":"Building,Fixture/Equipment","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-30T14:30:04.26","LASTSTATUS":"Active","STREETNAME":"Richmond","STREETNUMBER":"237","STREETSUFFIX":"Street","STYLE":"Other","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1964,"ZONING":"Business/Commercial","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-30T14:30:04.259","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"20250929_125946.jpg\"},{\"Order\":2,\"Remarks\":\"20250929_130004.jpg\"},{\"Order\":3,\"Remarks\":\"20250929_130027.jpg\"},{\"Order\":4,\"Remarks\":\"20250929_130046.jpg\"},{\"Order\":5,\"Remarks\":\"20250929_131006.jpg\"},{\"Order\":6,\"Remarks\":\"20250929_131015.jpg\"},{\"Order\":7,\"Remarks\":\"20250929_131020.jpg\"},{\"Order\":8,\"Remarks\":\"20250929_131030.jpg\"},{\"Order\":9,\"Remarks\":\"20250929_131033.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9","SOURCE":"MG_NST"}
{"ListingKey":"NST7808887","LotSizeArea":"0.12","NST_AgeOfProperty":"61","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AssessmentPending":"No","BasementYN":"False","PropertySubType":"Other","City":"Saint Paul","PropertyType":"Commercial Sale","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","CurrentUse":"Automotive,Vacant","Directions":"Saint Clair to Richmond, north to home on the corner of Saint Clair and Richmond.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Block","NST_ForeclosureStatus":"No","NST_FoundationDimensions":"30x30","FoundationArea":"900","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Parking Lot","AccessibilityFeatures":"None","Heating":"Space Heater","OriginalEntryTimestamp":"2025-09-30T14:28:03Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-30","Latitude":"44.934308","NST_LenderOwned":"No","ListAgentKey":"NST50003","ListAgentMlsId":"NST506091606","ListingContractDate":"2025-09-29T05:00:00Z","ListOfficeKey":"NST16442","ListOfficeName":"Edina Realty, Inc.","ListOfficeMlsId":"NST8107","ListPrice":"300000","LockBoxType":"Combo","Longitude":"-93.118741","LotFeatures":"Corner Lot","LotSizeDimensions":"91x44","LotSizeUnits":"Acres","ListingId":"NST6796360","SourceSystemName":"RMLS","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"West Seventh","NST_OfficeBoard":"SPAAR","NST_OwnerOccupied":"No","ParcelNumber":"012823340190","GarageSpaces":"2","NST_ParkingOpen":"8","PhotosCount":"9","PostalCity":"Saint Paul","PostalCode":"55102","NST_PotentialShortSale":"No","PossibleUse":"Office,Retail,Service Station,Shop","PublicRemarks":"Great location on the corner of St Clair and Richmond. Was formally an auto repair service station. Garage comes with two lifts, one air compressor and most everything you see fastened to the walls. Small \n1/4 bathroom. Off street parking for eight cars, Central Saint Paul location in up and coming west 7th area. The property is currently zoned T2. Tons of options for this property. Would need a conditional use permit to be used as an auto repair shop.","PublicSurveyRange":"23","PublicSurveySection":"01","PublicSurveyTownship":"28","NST_RangeNum":"None","NST_RentalLicenseYN":"No","Roof":"Flat","Inclusions":"Building,Fixture/Equipment","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","BuildingAreaTotal":"900","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Richmond","StreetNumber":"237","StreetNumberNumeric":"237","StreetSuffix":"Street","SubdivisionName":"Willes Add","NST_TaxWithAssessments":"7560.0000","TaxYear":"2025","TaxAnnualAmount":"7560","NumberOfUnitsTotal":"1","Utilities":"Electric Common","WaterSource":"City Water/Connected","YearBuilt":"1964","ZoningDescription":"Business/Commercial","ModificationTimestamp":"2025-09-30T14:30:04.259Z","PhotosChangeTimestamp":"2025-09-30T14:30:04.259Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7808887\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"20250929_125946.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808887/8a6e8ec3-e88f-4c66-939e-99584fb12dd5.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T14:29:44.931Z\",\"MediaKey\":\"68dbe95908b4290aaab92361\"},{\"ResourceRecordKey\":\"NST7808887\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"20250929_130004.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808887/83d37bd9-36c2-4fef-b617-e66218cab329.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T14:29:44.843Z\",\"MediaKey\":\"68dbe95908b4290aaab92362\"},{\"ResourceRecordKey\":\"NST7808887\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"20250929_130027.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808887/a273d4ce-d570-41db-af09-2169e708f254.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T14:29:45.013Z\",\"MediaKey\":\"68dbe95908b4290aaab92363\"},{\"ResourceRecordKey\":\"NST7808887\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"20250929_130046.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808887/a013a34b-56e3-42c4-9305-146b6edc9321.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T14:29:44.918Z\",\"MediaKey\":\"68dbe95908b4290aaab92364\"},{\"ResourceRecordKey\":\"NST7808887\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"20250929_131006.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808887/68e65976-cb96-481a-a40a-a7003372a19e.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T14:29:44.85Z\",\"MediaKey\":\"68dbe95908b4290aaab92365\"},{\"ResourceRecordKey\":\"NST7808887\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"20250929_131015.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808887/4899065f-d57f-44ee-be6b-db38f4c0763a.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T14:29:44.848Z\",\"MediaKey\":\"68dbe95908b4290aaab92366\"},{\"ResourceRecordKey\":\"NST7808887\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"20250929_131020.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808887/af18fe60-48f3-46ff-b01b-3f2c716060ca.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T14:29:44.842Z\",\"MediaKey\":\"68dbe95908b4290aaab92367\"},{\"ResourceRecordKey\":\"NST7808887\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"20250929_131030.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808887/7163489e-3df6-49fd-8807-9b6e77867c92.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T14:29:44.852Z\",\"MediaKey\":\"68dbe95908b4290aaab92368\"},{\"ResourceRecordKey\":\"NST7808887\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"20250929_131033.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808887/856f8fe1-8c54-4fc5-86d9-293adfe5fce3.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T14:29:44.854Z\",\"MediaKey\":\"68dbe95908b4290aaab92369\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"20250929_125946.jpg\"},{\"Order\":2,\"Remarks\":\"20250929_130004.jpg\"},{\"Order\":3,\"Remarks\":\"20250929_130027.jpg\"},{\"Order\":4,\"Remarks\":\"20250929_130046.jpg\"},{\"Order\":5,\"Remarks\":\"20250929_131006.jpg\"},{\"Order\":6,\"Remarks\":\"20250929_131015.jpg\"},{\"Order\":7,\"Remarks\":\"20250929_131020.jpg\"},{\"Order\":8,\"Remarks\":\"20250929_131030.jpg\"},{\"Order\":9,\"Remarks\":\"20250929_131033.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9","CustomVTourURL":""}