{"Id":1395616,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6772289","MLSAGENTID":"NST506001854","MLSOFFICEID":"NST48931","ADDRESS":"551 Saint Clair Avenue","ACRES":0.07,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Other","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":169900.0,"LASTPRICEDATE":"2025-08-14T13:40:04.073","LATITUDE":44.934376,"LENDEROWNED":"No","LISTDATE":"2025-08-14T05:00:00","LISTPRICE":169900.0,"LIVINGAREA":1020.0,"LONGITUDE":-93.122835,"MODIFICATIONTIMESTAMP":"2025-08-14T13:40:04.072","NEIGHBORHOOD":"West Seventh","OFFICE_OFFICENAME":"John McGovern","PHOTOCOUNT":8,"POSTALCODE":"55102","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"****OPPORTUNITY KNOCKS**** THIS HOME NEEDS A LOT OF WORK, GREAT EQUITY BUILDER!! THE FORCED AIR FURNACE HAS BEEN CERTIFIED. THIS HOME SITS ON 2 LOTS; 50 X 125 TOTAL LOT SIZE. 2 CAR GARAGE!!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-14T13:40:04.073","LASTSTATUS":"Active","STREETNAME":"Saint Clair","STREETNUMBER":"551","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1890,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-14T13:40:04.072","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"551 ST CLAIR\"},{\"Order\":2,\"Remarks\":\"DOUBLE LOT!\"},{\"Order\":3,\"Remarks\":\"LARGE KITCHEN!\"},{\"Order\":5,\"Remarks\":\"MAIN FLOOR LAUNDRY!\"},{\"Order\":6,\"Remarks\":\"LARGE 2 CAR!\"},{\"Order\":7,\"Remarks\":\"ADDITIONAL STORAGE!\"},{\"Order\":8,\"Remarks\":\"NEWER CENTRAL AIR!\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8","SOURCE":"MG_NST"}
{"ListingKey":"NST7788083","LotSizeArea":"0.07","NST_AgeOfProperty":"135","NST_AgentOwner":"Yes","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Other","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","Directions":"35E TO ST CLAIR TO 551","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"948","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached","NST_GarageSquareFeet":"528","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-14T13:38:09Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-14","Latitude":"44.934376","NST_LenderOwned":"No","ListAgentKey":"NST75554","ListAgentMlsId":"NST506001854","ListingContractDate":"2025-08-14T05:00:00Z","ListOfficeKey":"NST48931","ListOfficeName":"John McGovern","ListOfficeMlsId":"NST48931","ListPrice":"169900","LivingArea":"1020","Longitude":"-93.122835","LotSizeDimensions":"50 X 125 2 pids","LotSizeSquareFeet":"3092.76","LotSizeUnits":"Acres","ListingId":"NST6772289","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"West Seventh","NST_OfficeBoard":"MAAR","ParcelNumber":"012823330073","GarageSpaces":"2","NST_ParkingOpen":"2","PhotosCount":"8","PostalCity":"Saint Paul","PostalCode":"55102","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"****OPPORTUNITY KNOCKS**** THIS HOME NEEDS A LOT OF WORK, GREAT EQUITY BUILDER!! THE FORCED AIR FURNACE HAS BEEN CERTIFIED. THIS HOME SITS ON 2 LOTS; 50 X 125 TOTAL LOT SIZE. 2 CAR GARAGE!!","PublicSurveyRange":"23","PublicSurveySection":"01","PublicSurveyTownship":"28","NST_RentalLicenseYN":"No","NST_AboveGradeSqFtTotal":"1020.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"948.0000","BuildingAreaTotal":"1020","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1020","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One and One Half","StreetName":"Saint Clair","StreetNumber":"551","StreetNumberNumeric":"551","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Norwood Add","NST_TaxWithAssessments":"2896.0000","TaxYear":"2025","TaxAnnualAmount":"2896","WaterSource":"City Water/Connected","YearBuilt":"1890","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-14T13:40:04.072Z","PhotosChangeTimestamp":"2025-08-14T13:40:04.072Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7788083\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"551 ST CLAIR\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/6d6ff5fa-14b9-45d6-9103-f010dc4857b9.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T13:39:46.018Z\",\"MediaKey\":\"689de7224d706d77e1057a4c\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"DOUBLE LOT!\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/6f252019-05c0-4a47-a234-55a3cc702f2e.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T13:39:46.037Z\",\"MediaKey\":\"689de7224d706d77e1057a4d\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"LARGE KITCHEN!\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/978027ca-184e-482b-ab61-4354d919903a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T13:39:46.065Z\",\"MediaKey\":\"689de7224d706d77e1057a4e\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/46d63465-4c09-4120-9aa8-ec202df74ada.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T13:39:46.055Z\",\"MediaKey\":\"689de7224d706d77e1057a4f\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"MAIN FLOOR LAUNDRY!\",\"ImageWidth\":1512,\"ImageHeight\":2016,\"ImageSizeDescription\":\"1512x2016\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/2a54cc83-3ca1-43f2-9df9-d93ee56640eb.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T13:39:46.024Z\",\"MediaKey\":\"689de7224d706d77e1057a50\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"LARGE 2 CAR!\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/74ad002c-f16e-4da1-8ce1-15652facaa92.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T13:39:46.044Z\",\"MediaKey\":\"689de7224d706d77e1057a51\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"ADDITIONAL STORAGE!\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/679e09e3-8861-4bc4-908b-43fc4d0d4b90.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T13:39:46.047Z\",\"MediaKey\":\"689de7224d706d77e1057a52\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"NEWER CENTRAL AIR!\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/0f9cf900-f209-4ee5-8ab4-012f8155ac19.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T13:39:46.076Z\",\"MediaKey\":\"689de7224d706d77e1057a53\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"551 ST CLAIR\"},{\"Order\":2,\"Remarks\":\"DOUBLE LOT!\"},{\"Order\":3,\"Remarks\":\"LARGE KITCHEN!\"},{\"Order\":5,\"Remarks\":\"MAIN FLOOR LAUNDRY!\"},{\"Order\":6,\"Remarks\":\"LARGE 2 CAR!\"},{\"Order\":7,\"Remarks\":\"ADDITIONAL STORAGE!\"},{\"Order\":8,\"Remarks\":\"NEWER CENTRAL AIR!\"}]","PhotoOrder":"1,2,3,4,5,6,7,8","CustomVTourURL":""}