{"Id":502836,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6821267","MLSAGENTID":"NST496502584","MLSCOAGENTID":"NST502052519","MLSOFFICEID":"NST41150","ADDRESS":"553 White Bear Avenue N","ACRES":0.113,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full","BATHSTOTAL":1.0,"BEDROOMS":1,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":124900.0,"LASTPRICEDATE":"2025-12-17T22:55:24.62","LATITUDE":44.958004,"LENDEROWNED":"No","LISTDATE":"2025-12-04T06:00:00","LISTPRICE":119900.0,"LIVINGAREA":581.0,"LONGITUDE":-93.025554,"MODIFICATIONTIMESTAMP":"2025-12-18T19:37:05.417","NEIGHBORHOOD":"88","OFFICE_OFFICENAME":"HOMESTEAD ROAD","PHOTOCOUNT":12,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Great fixer-upper to get into this neighborhood at this price point. Large, clean unfinished basement offers ability to expand space. Large yard, detached garage. Come see today! Sold as-is.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-12-04T20:08:03.937","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"White Bear","STREETNUMBER":"553","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1926,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-12-10T20:52:04.468","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front\"},{\"Order\":2,\"Remarks\":\"Large Yard\"},{\"Order\":3,\"Remarks\":\"Large Yard\"},{\"Order\":4,\"Remarks\":\"Kitchen\"},{\"Order\":5,\"Remarks\":\"Main Room\"},{\"Order\":6,\"Remarks\":\"Bedroom\"},{\"Order\":7,\"Remarks\":\"Bathroom\"},{\"Order\":8,\"Remarks\":\"Basement\"},{\"Order\":9,\"Remarks\":\"Floor Plans\"},{\"Order\":10,\"Remarks\":\"Floor Plans\"},{\"Order\":11,\"Remarks\":\"Floor Plans\"},{\"Order\":12,\"Remarks\":\"Floor Plans\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12","SOURCE":"MG_NST"}
{"ListingKey":"NST7830432","AssociationYN":"False","AssociationFee":"0","Basement":"Full","City":"Saint Paul","Contingency":"None","Directions":"94 to White Bear, North on White Bear","FireplaceYN":"False","NST_Fuel":"Natural Gas","Latitude":"44.958004","ListPrice":"119900","LivingArea":"581","Longitude":"-93.025554","LotSizeDimensions":"64'x77'x63'x77'","LotSizeUnits":"Acres","ParcelNumber":"342922140043","PostalCity":"Saint Paul","PostalCode":"55106","PublicRemarks":"Great fixer-upper to get into this neighborhood at this price point. Large, clean unfinished basement offers ability to expand space. Large yard, detached garage. Come see today! Sold as-is.","PublicSurveyRange":"22","PublicSurveySection":"34","PublicSurveyTownship":"29","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"White Bear","StreetNumber":"553","StreetNumberNumeric":"553","StreetSuffix":"Avenue","TaxYear":"2025","YearBuilt":"1926","NST_AboveGradeSqFtTotal":"581","AboveGradeFinishedArea":"581","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"1","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","NewConstructionYN":"False","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Yes","DocumentsCount":"2","DocumentsChangeTimestamp":"2025-12-10T20:52:04.468Z","DaysOnMarket":"0","FireplacesTotal":"0","FoundationArea":"581","NST_FractionalOwnershipYN":"No","NST_GarageSquareFeet":"308","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","NST_LenderOwned":"No","Levels":"One","ListingContractDate":"2025-12-04T06:00:00Z","ListingId":"NST6821267","LotSizeArea":"0.113","NST_MainLevelFinishedArea":"581","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"88","OriginalEntryTimestamp":"2025-12-04T13:58:56Z","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Detached Garage","PhotosCount":"12","PhotosChangeTimestamp":"2025-12-10T20:52:04.468Z","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","NST_SpecialSearch":"Main Floor Bedroom","StandardStatus":"Active","SubdivisionName":"Heinemann Shirk & Stierles Sub","TaxAnnualAmount":"2578","NST_TaxWithAssessments":"2578","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST505934","CoListAgentMlsId":"NST502052519","CoListOfficeName":"HOMESTEAD ROAD","ListAgentKey":"NST49282","ListAgentMlsId":"NST496502584","ListOfficeMlsId":"NST41150","ListOfficeName":"HOMESTEAD ROAD","ListOfficeKey":"NST21187","ModificationTimestamp":"2025-12-18T19:37:05.417Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830432/9e34b311-fa67-4676-9057-d9423c136726.jpeg\",\"LongDescription\":\"Floor Plans\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7830432\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-10T20:51:10.444Z\",\"MediaKey\":\"NST119841412\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830432/50b21209-2b39-4757-aebf-60cdc5e7a20e.jpeg\",\"LongDescription\":\"Floor Plans\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7830432\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-10T20:51:10.44Z\",\"MediaKey\":\"NST119841410\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830432/5a3a4566-f780-4a42-b5b4-4588cb74ca52.jpeg\",\"LongDescription\":\"Floor Plans\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7830432\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-10T20:51:10.436Z\",\"MediaKey\":\"NST119841413\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830432/bea7f7e0-099b-4cdd-81b8-1976a42138fa.jpeg\",\"LongDescription\":\"Floor Plans\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7830432\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-10T20:51:10.442Z\",\"MediaKey\":\"NST119841411\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830432/796bca0d-4647-4c4e-949b-e0d3d3d35b42.jpeg\",\"LongDescription\":\"Kitchen\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7830432\",\"ImageWidth\":2080,\"ImageHeight\":1387,\"ImageSizeDescription\":\"2080x1387\",\"MediaModificationTimestamp\":\"2025-12-10T20:51:10.443Z\",\"MediaKey\":\"NST119841392\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830432/1c429a84-3bd6-486d-859c-7fdbbc5bcf83.jpeg\",\"LongDescription\":\"Bedroom\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7830432\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-10T20:51:10.465Z\",\"MediaKey\":\"NST119841389\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830432/ad6140e2-84fd-4901-a38c-5547a75ae1b7.jpeg\",\"LongDescription\":\"Bathroom\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7830432\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-10T20:51:10.44Z\",\"MediaKey\":\"NST119841387\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830432/c43b43af-1080-4052-99f4-d1caaf502922.jpeg\",\"LongDescription\":\"Basement\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7830432\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-10T20:51:10.455Z\",\"MediaKey\":\"NST119841383\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830432/460618e4-98fc-4e4b-9709-72d0723fc6dd.jpeg\",\"LongDescription\":\"Main Room\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7830432\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-10T20:51:10.492Z\",\"MediaKey\":\"NST119841391\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830432/ea804933-6e7d-4cef-bff3-9320e287fe4c.jpeg\",\"LongDescription\":\"Large Yard\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7830432\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-10T20:51:10.452Z\",\"MediaKey\":\"NST119841396\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830432/aa6a056f-6ef1-4919-87b1-c89e2de7f1c2.jpeg\",\"LongDescription\":\"Large Yard\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7830432\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-10T20:51:10.563Z\",\"MediaKey\":\"NST119841395\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830432/8da1d0b3-199d-4919-a6e9-6da768b53fab.jpeg\",\"LongDescription\":\"Front\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7830432\",\"ImageWidth\":2080,\"ImageHeight\":1387,\"ImageSizeDescription\":\"2080x1387\",\"MediaModificationTimestamp\":\"2025-12-10T20:51:10.477Z\",\"MediaKey\":\"NST119841398\"}]","Rooms":"[{\"RoomKey\":\"NST115810947\",\"RoomDimensions\":\"5x6\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5},{\"RoomKey\":\"NST115810944\",\"RoomDimensions\":\"7x11\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2},{\"RoomKey\":\"NST115810946\",\"RoomDimensions\":\"12x11\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4},{\"RoomKey\":\"NST115810945\",\"RoomDimensions\":\"6x7\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3},{\"RoomKey\":\"NST115810943\",\"RoomDimensions\":\"17x9\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front\"},{\"Order\":2,\"Remarks\":\"Large Yard\"},{\"Order\":3,\"Remarks\":\"Large Yard\"},{\"Order\":4,\"Remarks\":\"Kitchen\"},{\"Order\":5,\"Remarks\":\"Main Room\"},{\"Order\":6,\"Remarks\":\"Bedroom\"},{\"Order\":7,\"Remarks\":\"Bathroom\"},{\"Order\":8,\"Remarks\":\"Basement\"},{\"Order\":9,\"Remarks\":\"Floor Plans\"},{\"Order\":10,\"Remarks\":\"Floor Plans\"},{\"Order\":11,\"Remarks\":\"Floor Plans\"},{\"Order\":12,\"Remarks\":\"Floor Plans\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12","CustomVTourURL":""}