{"Id":596088,"ORGTABLE":"RAW_Property","MLSCLASS":"COM","MLSNUMBER":"NST7122446","MLSAGENTID":"NST506094722","MLSCOAGENTID":"NST506012504","MLSOFFICEID":"NST10699","ADDRESS":"1237 Saint Clair Avenue","ACRES":0.114,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Daylight/Lookout Windows,Full,Partially Finished,Shared Access,Storage Space","BATHSTOTAL":5.0,"BEDROOMS":5.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","CURRENTUSE":"Residential","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":500000.0,"LASTPRICEDATE":"2026-08-05T22:39:06.667","LATITUDE":44.934428,"LENDEROWNED":"No","LISTDATE":"2026-08-04T05:00:00","LISTPRICE":500000.0,"LIVINGAREA":4032.0,"LONGITUDE":-93.152507,"LOTDESCRIPTION":"Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-08-06T16:12:09.787","NEIGHBORHOOD":"95","OFFICE_OFFICENAME":"Norton Realty, Inc","PHOTOCOUNT":5,"POSTALCODE":"55105","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SALEINCLUDES":"Building,Fixture/Equipment,Land,Rental License","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-05T22:39:06.667","LASTSTATUS":"Active","STREETNAME":"Saint Clair","STREETNUMBER":"1237","STREETSUFFIX":"Avenue","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1953,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-08-06T16:08:10.366","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_0683.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_0684.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_0688.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_0685.jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_0690.jpeg\"}]","PHOTOORDER":"1,2,3,4,5","SOURCE":"MG_NST"}
{"ListingKey":"NST7946873","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Window","Appliances":"Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","Basement":"Block,Daylight/Lookout Windows,Full,Partially Finished,Shared Access,Storage Space","BasementYN":"True","BathroomsTotalInteger":"5","BedroomsTotal":"5","BuildingAreaTotal":"4032","CumulativeDaysOnMarket":"1","NST_CeilingHeight":"8-10","City":"Saint Paul","NST_RefrigeratorNum":"Five","NST_CommercialStyleType":"Apartments/Multi Family,Low Rise (3- levels)","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"None","CountyOrParish":"Ramsey","CurrentUse":"Residential","Directions":"Lexington Ave to St Clair Ave, west to property.","DocumentsCount":"0","DaysOnMarket":"1","ExteriorFeatures":"Stucco","Fencing":"None","Flooring":"Wood","FoundationArea":"1344","FoundationDetails":"Block,Poured Concrete","NST_FoundationDimensions":"50’ X 27’","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","GarageSpaces":"0","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","Inclusions":"Building,Fixture/Equipment,Land,Rental License","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.934428","NST_LenderOwned":"No","Levels":"Two","ListPrice":"500000","ListingContractDate":"2026-08-04T05:00:00Z","ListingId":"NST7122446","LockBoxType":"Supra","Longitude":"-93.152507","LotFeatures":"Tree Coverage - Light","LotSizeArea":"0.114","LotSizeDimensions":"105’ X 50’","LotSizeUnits":"Acres","NST_NeighborhoodName":"Macalester-Groveland","NST_NeighborhoodNumber":"95","NumberOfUnitsTotal":"5","OriginalEntryTimestamp":"2026-08-05T17:38:04Z","NST_OwnerOccupied":"No","OwnerPays":"Common Area Maintenance,Exterior Maintenance,Heat,Hot Water,HVAC Maintenance,Grounds Care,Repairs,Snow Removal,Trash Collection,Water","ParcelNumber":"032823430183","ParkingFeatures":"Parking Lot","PhotosCount":"5","PhotosChangeTimestamp":"2026-08-06T16:08:10.366Z","PostalCity":"Saint Paul","PostalCode":"55105","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyType":"Commercial Sale","PublicSurveyRange":"23","PublicSurveySection":"03","PublicSurveyTownship":"28","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Y","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks,Street Lights","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Asphalt","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Saint Clair","StreetNumber":"1237","StreetNumberNumeric":"1237","StreetSuffix":"Avenue","SubdivisionName":"Stinsons Blvd","TaxAnnualAmount":"13696","NST_TaxWithAssessments":"13696","TaxYear":"2026","TenantPays":"Cable TV,Electricity,See Remarks","Topography":"Gently Rolling","Township":"Saint Paul","Utilities":"Electric Separate,Heating Common,Hot Water Common","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","WindowFeatures":"Screens,Blinds,Double Pane Windows","YearBuilt":"1953","ZoningDescription":"Residential-Multi-Family","CoListAgentKey":"NST103705","CoListAgentMlsId":"NST506012504","CoListOfficeName":"Norton Realty, Inc","ListAgentKey":"NST50789","ListAgentMlsId":"NST506094722","ListOfficeMlsId":"NST10699","ListOfficeName":"Norton Realty, Inc","ListOfficeKey":"NST17773","ModificationTimestamp":"2026-08-06T16:12:09.787Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946873/bfed8fe8-2ded-4a78-94a1-a587c8dc5664.jpeg\",\"LongDescription\":\"IMG_0683.jpeg\",\"ResourceRecordKey\":\"NST7946873\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-08-06T16:07:20.577Z\",\"MediaKey\":\"NST124091668\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946873/fc57c45c-eab1-4a43-bef7-2e9abb0e8262.jpeg\",\"LongDescription\":\"IMG_0690.jpeg\",\"ResourceRecordKey\":\"NST7946873\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-08-06T16:07:20.579Z\",\"MediaKey\":\"NST124091664\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946873/d365bf24-6637-4733-8687-bc2bbecae7e9.jpeg\",\"LongDescription\":\"IMG_0688.jpeg\",\"ResourceRecordKey\":\"NST7946873\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-08-06T16:07:20.586Z\",\"MediaKey\":\"NST124091665\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946873/d9e63ebe-2d52-4eb5-be80-a13b66e60381.jpeg\",\"LongDescription\":\"IMG_0685.jpeg\",\"ResourceRecordKey\":\"NST7946873\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-08-06T16:07:20.57Z\",\"MediaKey\":\"NST124091666\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946873/ddeeff37-2dd8-429f-abdd-7f418d7bd236.jpeg\",\"LongDescription\":\"IMG_0684.jpeg\",\"ResourceRecordKey\":\"NST7946873\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-08-06T16:07:20.594Z\",\"MediaKey\":\"NST124091667\"}]","Media__Order":"1","Media__MediaObjectID":"NST1","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7946873/bfed8fe8-2ded-4a78-94a1-a587c8dc5664.jpeg","Media__LongDescription":"IMG_0683.jpeg","Media__ResourceRecordKey":"NST7946873","Media__ImageWidth":"1560","Media__ImageHeight":"2080","Media__ImageSizeDescription":"1560x2080","Media__MediaModificationTimestamp":"8/6/2026 4:07:20 PM","Media__MediaKey":"NST124091668","DocumentsChangeTimestamp":"2026-08-05T22:39:06.668Z","UnitTypes":"[{\"NST_LeaseExpirationDt\":\"2026-10-31\",\"NST_UnitLevel\":\"Main Level\",\"UnitTypeActualRent\":1050,\"NST_UnitIsLeased\":\"Yes\",\"UnitTypeBedsTotal\":1,\"UnitTypeBathsTotal\":1,\"NST_UnitRoomsTotal\":3,\"UnitTypeKey\":\"NST22136\",\"NST_UnitBathFull\":1,\"NST_UnitNumber\":\"1\"},{\"NST_LeaseExpirationDt\":\"2027-07-31\",\"NST_UnitLevel\":\"Main Level\",\"UnitTypeActualRent\":1050,\"NST_UnitIsLeased\":\"Yes\",\"UnitTypeBedsTotal\":1,\"UnitTypeBathsTotal\":1,\"NST_UnitRoomsTotal\":3,\"UnitTypeKey\":\"NST22137\",\"NST_UnitBathFull\":1,\"NST_UnitNumber\":\"2\"},{\"NST_LeaseExpirationDt\":\"2026-10-31\",\"NST_UnitLevel\":\"2nd Level\",\"UnitTypeActualRent\":1050,\"NST_UnitIsLeased\":\"Yes\",\"UnitTypeBedsTotal\":1,\"UnitTypeBathsTotal\":1,\"NST_UnitRoomsTotal\":3,\"UnitTypeKey\":\"NST22138\",\"NST_UnitBathFull\":1,\"NST_UnitNumber\":\"3\"},{\"NST_UnitLevel\":\"2nd Level\",\"NST_UnitIsLeased\":\"No\",\"UnitTypeBedsTotal\":1,\"UnitTypeBathsTotal\":1,\"NST_UnitRoomsTotal\":3,\"UnitTypeKey\":\"NST22139\",\"NST_UnitBathFull\":1,\"NST_UnitNumber\":\"4\"},{\"NST_LeaseExpirationDt\":\"2027-05-31\",\"NST_UnitLevel\":\"Below Ground\",\"UnitTypeActualRent\":950,\"NST_UnitIsLeased\":\"Yes\",\"UnitTypeBedsTotal\":1,\"UnitTypeBathsTotal\":1,\"NST_UnitRoomsTotal\":3,\"UnitTypeKey\":\"NST22140\",\"NST_UnitBathFull\":1,\"NST_UnitNumber\":\"5\"}]","UnitTypes__NST_LeaseExpirationDt":"2026-10-31","UnitTypes__NST_UnitLevel":"Main Level","UnitTypes__UnitTypeActualRent":"1050","UnitTypes__NST_UnitIsLeased":"Yes","UnitTypes__UnitTypeBedsTotal":"1","UnitTypes__UnitTypeBathsTotal":"1","UnitTypes__NST_UnitRoomsTotal":"3","UnitTypes__UnitTypeKey":"NST22136","UnitTypes__NST_UnitBathFull":"1","UnitTypes__NST_UnitNumber":"1","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_0683.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_0684.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_0688.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_0685.jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_0690.jpeg\"}]","PhotoOrder":"1,2,3,4,5","CustomVTourURL":""}