{"Id":524048,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7028439","MLSAGENTID":"NST502048047","MLSOFFICEID":"NST200018","ADDRESS":"861 Algonquin Avenue","ACRES":0.114,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Full,Unfinished","BATHSTOTAL":1.0,"BEDROOMS":1.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Concrete,Frame","FORECLOSURE":"No","LASTPRICE":172000.0,"LASTPRICEDATE":"2026-03-03T00:23:05.763","LATITUDE":44.967188,"LENDEROWNED":"No","LISTDATE":"2026-03-02T06:00:00","LISTPRICE":172000.0,"LIVINGAREA":560.0,"LONGITUDE":-93.017843,"LOTDESCRIPTION":"Cleared","MODIFICATIONTIMESTAMP":"2026-03-03T11:04:11.131","NEIGHBORHOOD":"92","OFFICE_OFFICENAME":"Real Broker, LLC","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":5,"POSTALCODE":"55119","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Natural light engulfs this home which is packed with updates and ready for you to move in. Updates include: a newer roof, newer gutters and eaves, newer loft window, granite kitchen countertops and updated bathroom. There is also a new furnace and air conditioning unit and tankless water heater. All kitchen appliances are newer including: fridge, stove, microwave and dishwasher and new washer and dryer! The large upper loft is a bright oasis overlooking the main floor. Don’t miss this opportunity! New gutter added to rear of home in 2024. New windows were installed in 2024. New sewer line from home to city connection in street - 2024.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt","SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-03T00:23:05.763","LASTSTATUS":"Active","STREETNAME":"Algonquin","STREETNUMBER":"861","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1924,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-03-03T00:22:33.642","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front of Home.JPG\"},{\"Order\":2,\"Remarks\":\"Front Porch.jpg\"},{\"Order\":3,\"Remarks\":\"Lights on Shed.JPG\"},{\"Order\":4,\"Remarks\":\"Fire Pit.JPG\"},{\"Order\":5,\"Remarks\":\"Brent - Eat in Kitchen.jpg\"}]","PHOTOORDER":"1,2,3,4,5","SOURCE":"MG_NST"}
{"ListingKey":"NST7861529","NST_AboveGradeSqFtTotal":"536","AboveGradeFinishedArea":"560","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Cable,Ceiling Fan(s),Patio","Appliances":"Dishwasher,Dryer,Microwave,Range,Refrigerator,Tankless Water Heater,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Full,Unfinished","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"1","NST_BelowGradeSqFtTotal":"480","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","ConstructionMaterials":"Concrete,Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Eat In Kitchen","Directions":"94 to White Bear Ave N to Stillwater Ave E to Algonquin.","DocumentsCount":"3","DocumentsChangeTimestamp":"2026-03-03T00:13:06.127Z","DaysOnMarket":"0","Electric":"Circuit Breakers","Fencing":"Chain Link,Partial","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"560","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"0","NST_GarageDimensions":"0","NST_GarageDoorHeight":"0","NST_GarageDoorWidth":"0","GarageSpaces":"0","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.967188","LaundryFeatures":"Main Level","NST_LenderOwned":"No","Levels":"One","ListPrice":"172000","ListingContractDate":"2026-03-02T06:00:00Z","ListingId":"NST7028439","LivingArea":"560","LockBoxType":"Supra","Longitude":"-93.017843","LotFeatures":"Cleared","LotSizeArea":"0.114","LotSizeDimensions":"50x100","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"560","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"92","OriginalEntryTimestamp":"2026-03-02T18:10:15Z","OtherStructures":"Storage Shed","ParcelNumber":"262922310107","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Gravel,Open","NST_PatioPorchType":"Enclosed,Front Porch,Patio","PhotosCount":"5","PhotosChangeTimestamp":"2026-03-03T00:22:33.642Z","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55119","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"Natural light engulfs this home which is packed with updates and ready for you to move in. Updates include: a newer roof, newer gutters and eaves, newer loft window, granite kitchen countertops and updated bathroom. There is also a new furnace and air conditioning unit and tankless water heater. All kitchen appliances are newer including: fridge, stove, microwave and dishwasher and new washer and dryer! The large upper loft is a bright oasis overlooking the main floor. Don’t miss this opportunity! New gutter added to rear of home in 2024. New windows were installed in 2024. New sewer line from home to city connection in street - 2024.","PublicSurveyRange":"22","PublicSurveySection":"26","PublicSurveyTownship":"29","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Age Over 8 Years,Asphalt","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Algonquin","StreetNumber":"861","StreetNumberNumeric":"861","StreetSuffix":"Avenue","SubdivisionName":"Beaver Lake Heights","TaxAnnualAmount":"3726","NST_TaxWithAssessments":"3726","TaxYear":"2025","BuildingAreaTotal":"1016","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1924","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST109867","ListAgentMlsId":"NST502048047","ListOfficeMlsId":"NST200018","ListOfficeName":"Real Broker, LLC","ListOfficeKey":"NST1000015","ModificationTimestamp":"2026-03-03T11:04:11.131Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7861529/b663a132-e6a8-4d74-8086-458dd48ec37c.jpeg\",\"LongDescription\":\"Brent - Eat in Kitchen.jpg\",\"ResourceRecordKey\":\"NST7861529\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-03-03T00:21:49.586Z\",\"MediaKey\":\"NST120726714\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7861529/64013218-955a-47cf-9f8b-62826302c758.jpeg\",\"LongDescription\":\"Front Porch.jpg\",\"ResourceRecordKey\":\"NST7861529\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-03-03T00:21:00.739Z\",\"MediaKey\":\"NST120726708\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7861529/bc35ede1-8dbf-48e2-a209-e94ae77436fa.jpeg\",\"LongDescription\":\"Fire Pit.JPG\",\"ResourceRecordKey\":\"NST7861529\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaModificationTimestamp\":\"2026-03-03T00:21:00.75Z\",\"MediaKey\":\"NST120726703\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7861529/e074e1fe-96ee-4ef9-85cc-ddbf6b3d53e1.jpeg\",\"LongDescription\":\"Front of Home.JPG\",\"ResourceRecordKey\":\"NST7861529\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-03-03T00:21:00.821Z\",\"MediaKey\":\"NST120726702\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7861529/e80bb415-272f-494d-9f5d-02b81eb1efb4.jpeg\",\"LongDescription\":\"Lights on Shed.JPG\",\"ResourceRecordKey\":\"NST7861529\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-03-03T00:21:00.811Z\",\"MediaKey\":\"NST120726704\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7861529/b663a132-e6a8-4d74-8086-458dd48ec37c.jpeg","Media__LongDescription":"Brent - Eat in Kitchen.jpg","Media__ResourceRecordKey":"NST7861529","Media__Order":"5","Media__MediaObjectID":"NST5","Media__ImageWidth":"1024","Media__ImageHeight":"768","Media__ImageSizeDescription":"1024x768","Media__MediaModificationTimestamp":"3/3/2026 12:21:49 AM","Media__MediaKey":"NST120726714","Rooms":"[{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115977373\",\"RoomType\":\"Bathroom\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"6x8\"},{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115977372\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"8x8\"},{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115977371\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"19x10\"},{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115977370\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"15x10\"},{\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST115977369\",\"RoomType\":\"Loft\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"15x8\"}]","Rooms__RoomLevel":"Main","Rooms__RoomKey":"NST115977373","Rooms__RoomType":"Bathroom","Rooms__NST_RoomSortOrder":"5","Rooms__RoomDimensions":"6x8","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front of Home.JPG\"},{\"Order\":2,\"Remarks\":\"Front Porch.jpg\"},{\"Order\":3,\"Remarks\":\"Lights on Shed.JPG\"},{\"Order\":4,\"Remarks\":\"Fire Pit.JPG\"},{\"Order\":5,\"Remarks\":\"Brent - Eat in Kitchen.jpg\"}]","PhotoOrder":"1,2,3,4,5","CustomVTourURL":""}