{"Id":1400817,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6778377","MLSAGENTID":"NST506007470","MLSOFFICEID":"NST8036","ADDRESS":"1828 Arlington Avenue E","ACRES":0.12,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":1.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Metal Siding,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":255000.0,"LASTPRICEDATE":"2025-08-27T16:13:03.887","LATITUDE":44.984459,"LENDEROWNED":"No","LISTDATE":"2025-08-27T05:00:00","LISTPRICE":255000.0,"LIVINGAREA":1322.0,"LONGITUDE":-93.023244,"LOTDESCRIPTION":"Many Trees","MODIFICATIONTIMESTAMP":"2025-08-28T02:55:04.272","NEIGHBORHOOD":"Greater East Side","OFFICE_OFFICENAME":"Cardinal Realty Co.","PHOTOCOUNT":24,"POSTALCODE":"55119","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Investment property! Bring your vision and creativity, and bring this home back to life. Located near public transportation and freeway access. Lots of potential to create more square footage.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-27T16:13:03.887","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"Arlington","STREETNUMBER":"1828","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1947,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-28T02:55:04.272","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24","SOURCE":"MG_NST"}
{"ListingKey":"NST7793424","LotSizeArea":"0.12","NST_AgeOfProperty":"78","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Cable,Ceiling Fan(s),Deck,Kitchen Window,Local Area Network,Main Floor Primary Bedroom,Security System,Security Lights,Tile Floors,Washer/Dryer Hookup","Appliances":"Exhaust Fan,Microwave,Refrigerator,Stainless Steel Appliances","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"None","BasementYN":"False","NST_BathDesc":"Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","Directions":"White Bear Avenue to Arlington Avenue East, then East to 1828","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Metal Siding,Vinyl Siding","Fencing":"Chain Link,Partial","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"840","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks,Street Lights,Storm Sewer","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached,Asphalt","NST_GarageSquareFeet":"0","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-27T16:11:46Z","NST_InternetOptions":"Cable","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-27","Latitude":"44.984459","NST_LenderOwned":"No","ListAgentKey":"NST95203","ListAgentMlsId":"NST506007470","ListingContractDate":"2025-08-27T05:00:00Z","ListOfficeKey":"NST16435","ListOfficeName":"Cardinal Realty Co.","ListOfficeMlsId":"NST8036","ListPrice":"255000","LivingArea":"1322","NST_LockBoxSource":"SPAAR","LockBoxType":"Supra","Longitude":"-93.023244","LotFeatures":"Many Trees","LotSizeDimensions":"40x126","LotSizeSquareFeet":"5227.2","LotSizeUnits":"Acres","ListingId":"NST6778377","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Greater East Side","NST_OfficeBoard":"SPAAR","ParcelNumber":"232922320020","GarageSpaces":"2","NST_PatioPorchType":"Deck","PhotosCount":"24","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55119","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PublicRemarks":"Investment property! Bring your vision and creativity, and bring this home back to life. Located near public transportation and freeway access. Lots of potential to create more square footage.","PublicSurveyRange":"22","PublicSurveySection":"23","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Age Over 8 Years,Asphalt","RoomType":"Living Room,Family Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Deck","NST_AboveGradeSqFtTotal":"1042.0000","NST_BelowGradeSqFtTotal":"280.0000","NST_MainLevelFinishedArea":"1042.0000","BuildingAreaTotal":"1322","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Main Floor Bedroom","AboveGradeFinishedArea":"1042","BelowGradeFinishedArea":"280","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One and One Half","StreetDirSuffix":"E","StreetName":"Arlington","StreetNumber":"1828","StreetNumberNumeric":"1828","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Hayden Heights","NST_TaxWithAssessments":"4158.0000","TaxYear":"2025","TaxAnnualAmount":"4158","WaterSource":"City Water/Connected","YearBuilt":"1947","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-28T02:55:04.272Z","PhotosChangeTimestamp":"2025-08-28T02:55:04.272Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7793424\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/3d2e7115-491f-4927-906e-f7335ddb49fe.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.345Z\",\"MediaKey\":\"68afc4e2275f11140fb0bca7\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/8b25d272-f9bb-4796-aaa0-6c7e0ac01546.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.663Z\",\"MediaKey\":\"68afc4e2275f11140fb0bca8\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/2a6b96fc-0993-4818-8ae8-9233cfe45580.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.314Z\",\"MediaKey\":\"68afc4e2275f11140fb0bca9\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/62f69d5b-16b2-44ba-be54-5b0fd8353bde.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.336Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcaa\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/1f32e25d-9504-41f7-9e6e-ce12b8b81218.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.322Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcab\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/44195987-985c-4c72-91b2-92d549a30632.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.336Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcac\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/cc2ccadb-8115-4f57-8f22-6bec22b62920.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.349Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcad\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/e7e1fc0d-d918-4f09-8176-3b95c3d734c3.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.286Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcae\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/714283ea-244d-4064-b7cc-0ae6bb0d315b.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.296Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcaf\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/3f96c546-cd47-4eab-90b6-ea0b52da8903.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.318Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcb0\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/58ec0473-c517-4d8d-92dd-ddfa644fe922.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.294Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcb1\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/bb83c150-dabd-43fb-90b0-ed726b67d5c0.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.328Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcb2\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/928777f4-782d-4fd0-bb05-5e532b57e610.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.284Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcb3\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/6f10ea96-478f-4c75-8c3c-ddf787bbdc1f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.324Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcb4\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/c9382b37-1abc-4cea-87e5-f201518a8218.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.312Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcb5\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/3b71a73e-2b7e-4c45-835f-9f095da96e5a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.271Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcb6\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/4a70d32f-47e4-48d8-a45a-54f7a03d9013.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.329Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcb7\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":18,\"MediaObjectID\":\"18\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/ceeb8ec3-01db-4370-86d6-296ce550a22a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.351Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcb8\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":19,\"MediaObjectID\":\"19\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/9e8c433d-cb2d-468a-bd49-432cbc277273.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.374Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcb9\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":20,\"MediaObjectID\":\"20\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/cfca749b-29eb-494d-a935-26d33fcecd04.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.346Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcba\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":21,\"MediaObjectID\":\"21\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/df3ea8ff-7b74-4f0c-884b-db1e11310c4f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.379Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcbb\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":22,\"MediaObjectID\":\"22\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/950060a3-0143-4c78-be90-8f818b4e1e95.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.379Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcbc\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":23,\"MediaObjectID\":\"23\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/71e7e3ba-b83f-4be9-a562-220402d15823.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.379Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcbd\"},{\"ResourceRecordKey\":\"NST7793424\",\"Order\":24,\"MediaObjectID\":\"24\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793424/c98ad069-52b3-4ac8-a0e3-d78c4d364108.jpeg\",\"MediaModificationTimestamp\":\"2025-08-28T02:54:26.396Z\",\"MediaKey\":\"68afc4e2275f11140fb0bcbe\"}]","Rooms":"[{\"RoomKey\":\"NST115552231\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"17x13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115552232\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"15x10\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115552233\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x10\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115552234\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115552235\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115552236\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"16x12\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115552237\",\"RoomType\":\"Deck\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"22x11\",\"NST_RoomSortOrder\":\"7\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24","CustomVTourURL":""}