{"Id":501187,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6822259","MLSAGENTID":"NST506097649","MLSOFFICEID":"NST5116","ADDRESS":"2106 Richard Avenue","ACRES":0.325,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Partially Finished","BATHSTOTAL":1.0,"BEDROOMS":2,"CITY":"White Bear Lake","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":291000.0,"LASTPRICEDATE":"2026-01-16T17:53:06.62","LATITUDE":45.054709,"LENDEROWNED":"Yes","LISTDATE":"2025-11-26T06:00:00","LISTPRICE":247350.0,"LIVINGAREA":1744.0,"LONGITUDE":-93.011685,"MODIFICATIONTIMESTAMP":"2026-01-16T18:01:06.76","OFFICE_OFFICENAME":"Coldwell Banker Realty - Lakes","PHOTOCOUNT":7,"POSTALCODE":"55110","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Excellent investment or renovation opportunity in Saint Paul! This 2-bedroom, 1-bath home features hardwood floors, a practical layout, and a 2-car garage. The property requires updates and repairs, offering a great chance for buyers looking to add value through improvement. Convenient location with access to local amenities. Home is being sold as-is.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2099-White Bear Lake","SCHOOLDISTRICTPHONE":"6514077500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-26T17:33:04.023","LASTSTATUS":"Active","STREETNAME":"Richard","STREETNUMBER":"2106","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1952,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-01-16T18:01:06.76","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front.jpg\"},{\"Order\":2,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":3,\"Remarks\":\"LR.jpg\"},{\"Order\":4,\"Remarks\":\"BR 1.jpg\"},{\"Order\":5,\"Remarks\":\"BR 2.jpg\"},{\"Order\":6,\"Remarks\":\"Bath.jpg\"},{\"Order\":7,\"Remarks\":\"Side.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7","SOURCE":"MG_NST"}
{"ListingKey":"NST7831271","AssociationYN":"False","AssociationFee":"0","AttributionContact":"6129789610","NST_AttributionName":"Robin L Sook","Basement":"Partially Finished","City":"White Bear Lake","Contingency":"None","Directions":"East on Cedar Avenue to Van Dyke Street. South on Van Dyke to Richard Avenue.","FireplaceYN":"False","NST_Fuel":"Natural Gas","Latitude":"45.054709","ListPrice":"247350","LivingArea":"1744","Longitude":"-93.011685","LotSizeDimensions":"75x189","LotSizeUnits":"Acres","ParcelNumber":"263022420049","PostalCity":"Saint Paul","PostalCode":"55110","PublicRemarks":"Excellent investment or renovation opportunity in Saint Paul! This 2-bedroom, 1-bath home features hardwood floors, a practical layout, and a 2-car garage. The property requires updates and repairs, offering a great chance for buyers looking to add value through improvement. Convenient location with access to local amenities. Home is being sold as-is.","PublicSurveyRange":"22","PublicSurveySection":"26","PublicSurveyTownship":"30","NST_SchoolDistrictPhone":"6514077500","Sewer":"City Sewer/Connected","StateOrProvince":"MN","StreetName":"Richard","StreetNumber":"2106","StreetNumberNumeric":"2106","StreetSuffix":"Avenue","TaxYear":"2025","YearBuilt":"1952","NST_AboveGradeSqFtTotal":"1924","AboveGradeFinishedArea":"1294","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":"2","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"450","CumulativeDaysOnMarket":"0","NewConstructionYN":"False","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","DocumentsCount":"7","DocumentsChangeTimestamp":"2026-01-16T17:53:06.62Z","DaysOnMarket":"0","FireplacesTotal":"0","FoundationArea":"1294","NST_FractionalOwnershipYN":"No","NST_GarageSquareFeet":"240","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"White Bear Lake","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","NST_LenderOwned":"Yes","Levels":"One","ListingContractDate":"2025-11-26T06:00:00Z","ListingId":"NST6822259","LotSizeArea":"0.325","NST_MainLevelFinishedArea":"1924","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2025-11-26T11:30:49Z","NST_SchoolDistrictNumber":"2099","ParkingFeatures":"Detached Garage","PhotosCount":"7","PhotosChangeTimestamp":"2026-01-16T18:01:06.76Z","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","StandardStatus":"Active","SubdivisionName":"John E Blomquist, First Add","TaxAnnualAmount":"3970","NST_TaxWithAssessments":"3970","Township":"White Bear Lake","VideosCount":"0","WaterSource":"City Water/Connected","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST74596","ListAgentMlsId":"NST506097649","ListOfficeMlsId":"NST5116","ListOfficeName":"Coldwell Banker Realty - Lakes","ListOfficeKey":"NST16638","ModificationTimestamp":"2026-01-16T18:01:06.76Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7831271\",\"LongDescription\":\"Kitchen.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7831271/55833adf-a6c3-471b-bd74-364510a2fa23.jpeg\",\"ImageWidth\":958,\"ImageHeight\":719,\"ImageSizeDescription\":\"958x719\",\"MediaModificationTimestamp\":\"2025-11-26T18:19:07.078Z\",\"MediaKey\":\"NST119782796\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7831271\",\"LongDescription\":\"BR 2.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7831271/4e22c5f7-86c1-4545-92cf-b70a6bfd05e7.jpeg\",\"ImageWidth\":958,\"ImageHeight\":719,\"ImageSizeDescription\":\"958x719\",\"MediaModificationTimestamp\":\"2025-11-26T18:19:07.084Z\",\"MediaKey\":\"NST119782797\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7831271\",\"LongDescription\":\"BR 1.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7831271/79c6fe4c-a067-4c57-bfd4-a057beb87690.jpeg\",\"ImageWidth\":958,\"ImageHeight\":719,\"ImageSizeDescription\":\"958x719\",\"MediaModificationTimestamp\":\"2025-11-26T18:19:07.078Z\",\"MediaKey\":\"NST119782798\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7831271\",\"LongDescription\":\"Bath.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7831271/f8e57639-8367-4147-a241-bf0e0f687c2e.jpeg\",\"ImageWidth\":958,\"ImageHeight\":719,\"ImageSizeDescription\":\"958x719\",\"MediaModificationTimestamp\":\"2025-11-26T18:19:07.109Z\",\"MediaKey\":\"NST119782800\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7831271\",\"LongDescription\":\"Front.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7831271/28b9c6d3-ae60-4bc3-aeef-5c7c685f84ca.jpeg\",\"ImageWidth\":958,\"ImageHeight\":719,\"ImageSizeDescription\":\"958x719\",\"MediaModificationTimestamp\":\"2025-11-26T18:19:07.138Z\",\"MediaKey\":\"NST119782794\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7831271\",\"LongDescription\":\"LR.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7831271/cf4ebb19-7bb5-43a3-b5e9-79f74658b917.jpeg\",\"ImageWidth\":958,\"ImageHeight\":719,\"ImageSizeDescription\":\"958x719\",\"MediaModificationTimestamp\":\"2025-11-26T18:19:07.067Z\",\"MediaKey\":\"NST119782795\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7831271\",\"LongDescription\":\"Side.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7831271/4d42e026-7ef1-41d4-9051-1fcbbb80661a.jpeg\",\"ImageWidth\":958,\"ImageHeight\":719,\"ImageSizeDescription\":\"958x719\",\"MediaModificationTimestamp\":\"2025-11-26T18:19:07.1Z\",\"MediaKey\":\"NST119782799\"}]","Media__Order":"2","Media__MediaObjectID":"NST2","Media__ResourceRecordKey":"NST7831271","Media__LongDescription":"Kitchen.jpg","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7831271/55833adf-a6c3-471b-bd74-364510a2fa23.jpeg","Media__ImageWidth":"958","Media__ImageHeight":"719","Media__ImageSizeDescription":"958x719","Media__MediaModificationTimestamp":"11/26/2025 6:19:07 PM","Media__MediaKey":"NST119782796","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front.jpg\"},{\"Order\":2,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":3,\"Remarks\":\"LR.jpg\"},{\"Order\":4,\"Remarks\":\"BR 1.jpg\"},{\"Order\":5,\"Remarks\":\"BR 2.jpg\"},{\"Order\":6,\"Remarks\":\"Bath.jpg\"},{\"Order\":7,\"Remarks\":\"Side.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7","CustomVTourURL":""}