{"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":149900.0,"LASTPRICEDATE":"2025-09-29T13:09:03.53","LATITUDE":44.934376,"LENDEROWNED":"No","LISTDATE":"2025-08-14T05:00:00","LISTPRICE":139900.0,"LIVINGAREA":1020.0,"LONGITUDE":-93.122835,"MODIFICATIONTIMESTAMP":"2025-09-29T13:09:03.531","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-09-29T13:08:03.425","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"LARGE KITCHEN!\"},{\"Order\":2,\"Remarks\":\"551 ST CLAIR\"},{\"Order\":3,\"Remarks\":\"DOUBLE LOT!\"},{\"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","NST_DPResource":"Y","DaysOnMarket":"46","CumulativeDaysOnMarket":"46","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-09-29","Latitude":"44.934376","NST_LenderOwned":"No","ListAgentKey":"NST75554","ListAgentMlsId":"NST506001854","ListingContractDate":"2025-08-14T05:00:00Z","ListOfficeKey":"NST48931","ListOfficeName":"John McGovern","ListOfficeMlsId":"NST48931","ListPrice":"139900","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-09-29T13:09:03.531Z","PhotosChangeTimestamp":"2025-09-29T13:08:03.425Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7788083\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"LARGE KITCHEN!\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/560c33c6-e690-4f19-a2c1-1419ad6164c6.jpeg\",\"MediaModificationTimestamp\":\"2025-09-29T13:07:17.407Z\",\"MediaKey\":\"68da848532c9145143cb6022\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"551 ST CLAIR\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/c7de411a-8367-4132-9384-20438b20afa0.jpeg\",\"MediaModificationTimestamp\":\"2025-09-29T13:07:17.416Z\",\"MediaKey\":\"68da848532c9145143cb6023\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"DOUBLE LOT!\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/32c26445-10ac-48f4-96e1-a5fbbb118238.jpeg\",\"MediaModificationTimestamp\":\"2025-09-29T13:07:17.452Z\",\"MediaKey\":\"68da848532c9145143cb6024\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/ec0d68e9-5fc7-460e-9a11-e7e0947b2ae2.jpeg\",\"MediaModificationTimestamp\":\"2025-09-29T13:07:17.406Z\",\"MediaKey\":\"68da848532c9145143cb6025\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"MAIN FLOOR LAUNDRY!\",\"ImageWidth\":1512,\"ImageHeight\":2016,\"ImageSizeDescription\":\"1512x2016\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/17a62146-7a9e-4ff4-a2f5-5790ec4289b1.jpeg\",\"MediaModificationTimestamp\":\"2025-09-29T13:07:17.538Z\",\"MediaKey\":\"68da848532c9145143cb6026\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"LARGE 2 CAR!\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/fb0c504b-3d64-4984-aeb7-2b82b7c67c86.jpeg\",\"MediaModificationTimestamp\":\"2025-09-29T13:07:17.467Z\",\"MediaKey\":\"68da848532c9145143cb6027\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"ADDITIONAL STORAGE!\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/8e35a75c-dc4e-4a06-aab7-489f8fc8a338.jpeg\",\"MediaModificationTimestamp\":\"2025-09-29T13:07:17.516Z\",\"MediaKey\":\"68da848532c9145143cb6028\"},{\"ResourceRecordKey\":\"NST7788083\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"NEWER CENTRAL AIR!\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788083/561775c4-760e-4f36-a4ec-c99919e6b2f8.jpeg\",\"MediaModificationTimestamp\":\"2025-09-29T13:07:17.583Z\",\"MediaKey\":\"68da848532c9145143cb6029\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"LARGE KITCHEN!\"},{\"Order\":2,\"Remarks\":\"551 ST CLAIR\"},{\"Order\":3,\"Remarks\":\"DOUBLE LOT!\"},{\"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":""}