{"Id":572903,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7093379","MLSAGENTID":"NST506094338","MLSOFFICEID":"NST10071","ADDRESS":"719 Sherburne Avenue","ACRES":0.113,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full","BATHSTOTAL":2.0,"BEDROOMS":6.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":134900.0,"LASTPRICEDATE":"2026-08-28T20:21:24.707","LATITUDE":44.956886,"LENDEROWNED":"Yes","LISTDATE":"2026-06-15T05:00:00","LISTPRICE":124900.0,"LIVINGAREA":1976.0,"LONGITUDE":-93.130477,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-08-28T20:21:24.708","NEIGHBORHOOD":"102","OFFICE_OFFICENAME":"Keller Williams Integrity Realty","PHOTOCOUNT":12,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Investor Opportunity! This duplex offers tremendous potential for renovation and value-add investors. Conveniently located just one block from the light rail, the property provides excellent access to transportation and nearby amenities. The building is currently classified as a Category 2 vacant property and requires a complete rehabilitation. Priced to sell and offered as-is.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-15T20:07:07.127","LASTSTATUS":"Active","STREETNAME":"Sherburne","STREETNUMBER":"719","STREETSUFFIX":"Avenue","STYLE":"Duplex Up and Down","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1908,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-18T15:32:07.321","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12","SOURCE":"MG_NST"}
{"ListingKey":"NST7918548","NST_AboveGradeSqFtTotal":"1976","AboveGradeFinishedArea":"1976","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","Basement":"Full","BasementYN":"True","BathroomsTotalInteger":"2","BedroomsTotal":"6","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"Dale St to Sherburne, go West to property.","DocumentsCount":"3","DocumentsChangeTimestamp":"2026-07-09T17:39:06.891Z","DaysOnMarket":"0","ElectricExpense":"0","ExteriorFeatures":"Aluminum Siding,Metal,Vinyl","Fencing":"Chain Link,Partial","FoundationArea":"988","FoundationDetails":"Brick/Mortar","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","FuelExpense":"0","NST_GarageSquareFeet":"480","GarageSpaces":"2","GrossIncome":"0","Heating":"Boiler,Hot Water,Radiant","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InsuranceExpense":"0","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.956886","NST_LenderOwned":"Yes","Levels":"More Than 2 Stories","ListPrice":"124900","ListingContractDate":"2026-06-15T05:00:00Z","ListingId":"NST7093379","LivingArea":"1976","Longitude":"-93.130477","LotFeatures":"Public Transit (w/in 6 blks),Tree Coverage - Light","LotSizeArea":"0.113","LotSizeDimensions":"40x124","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"988","MaintenanceExpense":"0","ManagerExpense":"0","NST_NeighborhoodName":"Thomas-Dale (Frogtown)","NST_NeighborhoodNumber":"102","NumberOfUnitsTotal":"2","OperatingExpense":"0","OriginalEntryTimestamp":"2026-06-15T15:06:02Z","OtherExpense":"0","NST_OwnerOccupied":"No","ParcelNumber":"352923140174","ParkingFeatures":"Detached Garage","NST_PatioPorchType":"Front Porch","PhotosCount":"12","PhotosChangeTimestamp":"2026-06-18T15:32:07.321Z","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertySubType":"Duplex Up and Down","PropertyType":"Residential Income","PublicRemarks":"Investor Opportunity! This duplex offers tremendous potential for renovation and value-add investors. Conveniently located just one block from the light rail, the property provides excellent access to transportation and nearby amenities. The building is currently classified as a Category 2 vacant property and requires a complete rehabilitation. Priced to sell and offered as-is.","PublicSurveyRange":"23","PublicSurveySection":"35","PublicSurveyTownship":"29","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Asphalt,Pitched","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Sherburne","StreetNumber":"719","StreetNumberNumeric":"719","StreetSuffix":"Avenue","SubdivisionName":"Chute Brothers Division, No 7","TaxAnnualAmount":"4725.14","NST_TaxWithAssessments":"24196","TaxYear":"2026","NST_TotalArea":"1976","BuildingAreaTotal":"1976","Township":"Saint Paul","TrashExpense":"0","VideosCount":"0","WaterSewerExpense":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1908","ZoningDescription":"Residential-Multi-Family","ListAgentKey":"NST53356","ListAgentMlsId":"NST506094338","ListOfficeMlsId":"NST10071","ListOfficeName":"Keller Williams Integrity Realty","ListOfficeKey":"NST16710","ModificationTimestamp":"2026-08-28T20:21:24.708Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7918548/6dea89a2-d5ad-4c02-a47c-ad1b571c6a2a.jpeg\",\"ResourceRecordKey\":\"NST7918548\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2026-06-18T15:31:15.925Z\",\"MediaKey\":\"NST122975595\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7918548/14f8e3ad-15ec-4fdb-9b11-9489d653ed50.jpeg\",\"ResourceRecordKey\":\"NST7918548\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2026-06-15T20:59:13.521Z\",\"MediaKey\":\"NST122975420\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7918548/68f1322b-cea0-44ba-99b9-d645e53261c3.jpeg\",\"ResourceRecordKey\":\"NST7918548\",\"ImageWidth\":1949,\"ImageHeight\":1463,\"ImageSizeDescription\":\"1949x1463\",\"MediaModificationTimestamp\":\"2026-06-15T20:59:13.493Z\",\"MediaKey\":\"NST122975283\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7918548/033234e9-49a8-4afb-8c07-127de375a945.jpeg\",\"ResourceRecordKey\":\"NST7918548\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2026-06-15T20:59:13.487Z\",\"MediaKey\":\"NST122975284\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7918548/62e19a7d-fc68-43f9-afd2-d50972d2c59d.jpeg\",\"ResourceRecordKey\":\"NST7918548\",\"ImageWidth\":1933,\"ImageHeight\":1451,\"ImageSizeDescription\":\"1933x1451\",\"MediaModificationTimestamp\":\"2026-06-18T15:31:15.883Z\",\"MediaKey\":\"NST122975424\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7918548/907ec077-05e8-4ecb-abf0-b575c7923c94.jpeg\",\"ResourceRecordKey\":\"NST7918548\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2026-06-18T15:31:15.874Z\",\"MediaKey\":\"NST122975459\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7918548/ca47981d-61f7-4d39-a929-f8581e96ad8b.jpeg\",\"ResourceRecordKey\":\"NST7918548\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2026-06-18T15:31:15.916Z\",\"MediaKey\":\"NST122975458\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7918548/fcb512e0-b582-421c-aad6-60aa119766b8.jpeg\",\"ResourceRecordKey\":\"NST7918548\",\"ImageWidth\":1949,\"ImageHeight\":1463,\"ImageSizeDescription\":\"1949x1463\",\"MediaModificationTimestamp\":\"2026-06-18T15:31:15.898Z\",\"MediaKey\":\"NST122975460\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7918548/5be6bc83-8ba4-4bc5-8a3e-3da95f9df260.jpeg\",\"ResourceRecordKey\":\"NST7918548\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2026-06-15T20:59:13.507Z\",\"MediaKey\":\"NST122975426\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7918548/c1172815-39b1-42cd-90cd-41f7ef67c22c.jpeg\",\"ResourceRecordKey\":\"NST7918548\",\"ImageWidth\":1971,\"ImageHeight\":1477,\"ImageSizeDescription\":\"1971x1477\",\"MediaModificationTimestamp\":\"2026-06-15T20:59:13.468Z\",\"MediaKey\":\"NST122975419\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7918548/c5bce7df-da3c-4857-bb37-26a6c8fe2a80.jpeg\",\"ResourceRecordKey\":\"NST7918548\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2026-06-15T20:59:13.531Z\",\"MediaKey\":\"NST122975285\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7918548/cedba777-fc85-4dda-9814-09a0625bd8c0.jpeg\",\"ResourceRecordKey\":\"NST7918548\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2026-06-15T20:59:13.486Z\",\"MediaKey\":\"NST122975421\"}]","Media__Order":"12","Media__MediaObjectID":"NST12","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7918548/6dea89a2-d5ad-4c02-a47c-ad1b571c6a2a.jpeg","Media__ResourceRecordKey":"NST7918548","Media__ImageWidth":"2016","Media__ImageHeight":"1512","Media__ImageSizeDescription":"2016x1512","Media__MediaModificationTimestamp":"6/18/2026 3:31:15 PM","Media__MediaKey":"NST122975595","UnitTypes":"[{\"NST_UnitIsLeased\":\"N\",\"UnitTypeBathsTotal\":1,\"NST_UnitSqFt\":988,\"UnitTypeBedsTotal\":3,\"NST_UnitBathFull\":1,\"NST_UnitID\":1,\"NST_UnitRoomsTotal\":5,\"UnitTypeTotalRent\":0,\"UnitTypeKey\":\"NST160612\",\"UnitTypeUnitsTotal\":1},{\"NST_UnitIsLeased\":\"N\",\"UnitTypeBathsTotal\":1,\"NST_UnitAppl\":[\"Cooktop\",\"Range\",\"Stainless Steel Appliances\"],\"NST_UnitSqFt\":988,\"UnitTypeBedsTotal\":3,\"NST_UnitBathFull\":1,\"NST_UnitID\":2,\"NST_UnitRoomsTotal\":5,\"UnitTypeTotalRent\":0,\"UnitTypeKey\":\"NST160613\",\"UnitTypeUnitsTotal\":1}]","UnitTypes__NST_UnitIsLeased":"N","UnitTypes__UnitTypeBathsTotal":"1","UnitTypes__NST_UnitSqFt":"988","UnitTypes__UnitTypeBedsTotal":"3","UnitTypes__NST_UnitBathFull":"1","UnitTypes__NST_UnitID":"1","UnitTypes__NST_UnitRoomsTotal":"5","UnitTypes__UnitTypeTotalRent":"0","UnitTypes__UnitTypeKey":"NST160612","UnitTypes__UnitTypeUnitsTotal":"1","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12","CustomVTourURL":""}