{"Id":1400033,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6777959","MLSAGENTID":"NST506096207","MLSOFFICEID":"NST253060","ADDRESS":"816 Edmund Avenue","ACRES":0.11,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full","CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Stucco","FORECLOSURE":"No","LASTPRICE":239900.0,"LASTPRICEDATE":"2025-08-25T19:18:03.953","LATITUDE":44.958176,"LENDEROWNED":"No","LISTDATE":"2025-08-25T05:00:00","LISTPRICE":239900.0,"LIVINGAREA":1876.0,"LONGITUDE":-93.134613,"MODIFICATIONTIMESTAMP":"2025-08-25T19:52:04.486","NEIGHBORHOOD":"Thomas-Dale (Frogtown)","OFFICE_OFFICENAME":"Jeff Hagel","PHOTOCOUNT":11,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Fantastic investment opportunity! This well-maintained duplex features two spacious units, each offering 2 bedrooms and 1 bathroom. Both units are in good condition and just need a few cosmetic updates, giving you the chance to add your personal touch or increase rental value. Perfect for investors seeking reliable income or for an owner-occupant looking to live in one side while renting out the other.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-25T19:18:03.953","LASTSTATUS":"Active","STREETNAME":"Edmund","STREETNUMBER":"816","STREETSUFFIX":"Avenue","STYLE":"Duplex Up and Down","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1888,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-25T19:18:03.953","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1 Edmund.jpg\"},{\"Order\":2,\"Remarks\":\"2 Edmund.jpg\"},{\"Order\":3,\"Remarks\":\"3 Edmund.jpg\"},{\"Order\":4,\"Remarks\":\"4 Edmund.jpg\"},{\"Order\":5,\"Remarks\":\"5 Edmund.jpg\"},{\"Order\":6,\"Remarks\":\"6 Edmund.jpg\"},{\"Order\":7,\"Remarks\":\"7Edmund.jpg\"},{\"Order\":8,\"Remarks\":\"8Edmund.jpg\"},{\"Order\":9,\"Remarks\":\"9Edmund.jpg\"},{\"Order\":10,\"Remarks\":\"10 Edmund.jpg\"},{\"Order\":11,\"Remarks\":\"11 Edmund.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11","SOURCE":"MG_NST"}
{"ListingKey":"NST7793062","LotSizeArea":"0.11","NST_AgeOfProperty":"137","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AssessmentPending":"No","NST_AttributionContact":"jeffrey.hagel@gmail.com","NST_AttributionName":"Jeffrey Hagel","Basement":"Full","BasementYN":"True","City":"Saint Paul","PropertyType":"Residential Income","NewConstructionYN":"False","Contingency":"None","CountyOrParish":"Ramsey","Directions":"94 TO LEXINGTON NORTH TO EDMUND EAST TO HOME","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ManagerExpense":"0","ElectricExpense":"0","FuelExpense":"0","InsuranceExpense":"0","MaintenanceExpense":"0","OtherExpense":"0","OperatingExpense":"0","TrashExpense":"0","WaterSewerExpense":"0","NST_Expenses":"0.0000","ConstructionMaterials":"Stucco","NST_ForeclosureStatus":"No","FoundationArea":"938","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric","ParkingFeatures":"Detached","NST_GarageSquareFeet":"200","GrossIncome":"0","AccessibilityFeatures":"None","Heating":"Hot Water","OriginalEntryTimestamp":"2025-08-25T19:16:20Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-25","Latitude":"44.958176","NST_LenderOwned":"No","ListAgentKey":"NST102072","ListAgentMlsId":"NST506096207","ListingContractDate":"2025-08-25T05:00:00Z","ListOfficeKey":"NST1001803","ListOfficeName":"Jeff Hagel","ListOfficeMlsId":"NST253060","ListPrice":"239900","LivingArea":"1876","Longitude":"-93.134613","LotSizeDimensions":"125X40","LotSizeUnits":"Acres","ListingId":"NST6777959","SourceSystemName":"RMLS","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Thomas-Dale (Frogtown)","NST_OfficeBoard":"SPAAR","NST_OwnerOccupied":"No","ParcelNumber":"352923130061","GarageSpaces":"1","PhotosCount":"11","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Fantastic investment opportunity! This well-maintained duplex features two spacious units, each offering 2 bedrooms and 1 bathroom. Both units are in good condition and just need a few cosmetic updates, giving you the chance to add your personal touch or increase rental value. Perfect for investors seeking reliable income or for an owner-occupant looking to live in one side while renting out the other.","PublicSurveyRange":"23","PublicSurveySection":"35","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","NST_AboveGradeSqFtTotal":"1876.0000","NST_BelowGradeSqFtTotal":"938.0000","NST_MainLevelFinishedArea":"938.0000","BuildingAreaTotal":"2814","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1876","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Edmund","StreetNumber":"816","StreetNumberNumeric":"816","StreetSuffix":"Avenue","PropertySubType":"Duplex Up and Down","SubdivisionName":"Syndicate 2 Add","NST_TaxWithAssessments":"4398.0000","TaxYear":"2025","TaxAnnualAmount":"4398","NumberOfUnitsTotal":"2","WaterSource":"City Water/Connected","YearBuilt":"1888","ZoningDescription":"Residential-Multi-Family","ModificationTimestamp":"2025-08-25T19:52:04.486Z","PhotosChangeTimestamp":"2025-08-25T19:18:03.953Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7793062\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"1 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/f3814b06-32a6-4ddc-b232-5dc249a3c88d.jpeg\",\"MediaModificationTimestamp\":\"2025-08-25T19:17:50.327Z\",\"MediaKey\":\"68acb6de29dbe850d7852531\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"2 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/8d27f046-487d-4bc3-b609-6930a9eb0b31.jpeg\",\"MediaModificationTimestamp\":\"2025-08-25T19:17:50.42Z\",\"MediaKey\":\"68acb6de29dbe850d7852532\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"3 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/e822b216-c425-4401-84a3-753309da1ab6.jpeg\",\"MediaModificationTimestamp\":\"2025-08-25T19:17:50.373Z\",\"MediaKey\":\"68acb6de29dbe850d7852533\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"4 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/111b8e21-878d-409d-b99d-179afcba341b.jpeg\",\"MediaModificationTimestamp\":\"2025-08-25T19:17:50.386Z\",\"MediaKey\":\"68acb6de29dbe850d7852534\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"5 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/57c5e54e-03e7-4425-b594-b5122fed0aab.jpeg\",\"MediaModificationTimestamp\":\"2025-08-25T19:17:50.39Z\",\"MediaKey\":\"68acb6de29dbe850d7852535\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"6 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/2b850748-bd62-4816-8493-0967a615b2cf.jpeg\",\"MediaModificationTimestamp\":\"2025-08-25T19:17:50.326Z\",\"MediaKey\":\"68acb6de29dbe850d7852536\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"7Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/111e2e42-841f-4628-94dc-83cc4ff9eb0f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-25T19:17:50.362Z\",\"MediaKey\":\"68acb6de29dbe850d7852537\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"8Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/0465439d-9fb6-4da0-90dd-bca4ce537f20.jpeg\",\"MediaModificationTimestamp\":\"2025-08-25T19:17:50.326Z\",\"MediaKey\":\"68acb6de29dbe850d7852538\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"9Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1389,\"ImageSizeDescription\":\"2080x1389\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/ccae2b07-43be-4d18-a647-0f39f666699c.jpeg\",\"MediaModificationTimestamp\":\"2025-08-25T19:17:50.433Z\",\"MediaKey\":\"68acb6de29dbe850d7852539\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"10 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1397,\"ImageSizeDescription\":\"2080x1397\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/2685479b-4c64-44d3-96de-f48e7e2220df.jpeg\",\"MediaModificationTimestamp\":\"2025-08-25T19:17:50.38Z\",\"MediaKey\":\"68acb6de29dbe850d785253a\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"11 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1392,\"ImageSizeDescription\":\"2080x1392\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/9530d676-5326-4eed-9bab-107fcd1682c5.jpeg\",\"MediaModificationTimestamp\":\"2025-08-25T19:17:50.327Z\",\"MediaKey\":\"68acb6de29dbe850d785253b\"}]","UnitTypes":"[{\"UnitTypeKey\":\"NST155477\",\"UnitTypeTotalRent\":0,\"NST_UnitBath3Qtr\":\"0\",\"NST_UnitBathFull\":\"1\",\"NST_UnitBathHalf\":\"0\",\"NST_UnitBathQtr\":\"0\",\"UnitTypeBathsTotal\":1,\"UnitTypeBedsTotal\":2,\"NST_MonthlyExpenses\":\"0.00\",\"NST_UnitID\":\"1\",\"UnitTypeActualRent\":0,\"UnitTypeUnitsTotal\":2,\"NST_UnitRoomsTotal\":\"6\",\"NST_UnitSqFt\":\"936\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1 Edmund.jpg\"},{\"Order\":2,\"Remarks\":\"2 Edmund.jpg\"},{\"Order\":3,\"Remarks\":\"3 Edmund.jpg\"},{\"Order\":4,\"Remarks\":\"4 Edmund.jpg\"},{\"Order\":5,\"Remarks\":\"5 Edmund.jpg\"},{\"Order\":6,\"Remarks\":\"6 Edmund.jpg\"},{\"Order\":7,\"Remarks\":\"7Edmund.jpg\"},{\"Order\":8,\"Remarks\":\"8Edmund.jpg\"},{\"Order\":9,\"Remarks\":\"9Edmund.jpg\"},{\"Order\":10,\"Remarks\":\"10 Edmund.jpg\"},{\"Order\":11,\"Remarks\":\"11 Edmund.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11","CustomVTourURL":""}