{"Id":1407517,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6787830","MLSAGENTID":"NST506014902","MLSOFFICEID":"NST10669","ADDRESS":"419 Rose Avenue E","ACRES":0.11,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":259900.0,"LASTPRICEDATE":"2025-09-12T01:26:03.537","LATITUDE":44.976711,"LENDEROWNED":"No","LISTDATE":"2025-09-08T05:00:00","LISTPRICE":259900.0,"LIVINGAREA":2088.0,"LONGITUDE":-93.082904,"MODIFICATIONTIMESTAMP":"2025-09-12T10:13:04.076","NEIGHBORHOOD":"Payne-Phalen","OFFICE_OFFICENAME":"National Realty Guild","PHOTOCOUNT":4,"POSTALCODE":"55130","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-12T01:26:03.537","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"Rose","STREETNUMBER":"419","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1919,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-12T03:16:04.486","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_6992.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_6993.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_6994.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_6995.jpeg\"}]","PHOTOORDER":"1,2,3,4","SOURCE":"MG_NST"}
{"ListingKey":"NST7801657","LotSizeArea":"0.11","NST_AgeOfProperty":"106","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Block","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"4","CumulativeDaysOnMarket":"4","Directions":"MARYLAND EAST OF 35E TO CLARK AND SOUTH TO ROSE AVE","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"84","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric,Natural Gas","ParkingFeatures":"Detached","NST_GarageSquareFeet":"144","AccessibilityFeatures":"Wheelchair Ramp(s)","Heating":"Forced Air","OriginalEntryTimestamp":"2025-09-12T01:21:59Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-12","Latitude":"44.976711","NST_LenderOwned":"No","ListAgentKey":"NST108806","ListAgentMlsId":"NST506014902","ListingContractDate":"2025-09-08T05:00:00Z","ListOfficeKey":"NST17725","ListOfficeName":"National Realty Guild","ListOfficeMlsId":"NST10669","ListPrice":"259900","LivingArea":"2088","Longitude":"-93.082904","LotSizeDimensions":"38*122","LotSizeSquareFeet":"4617.36","LotSizeUnits":"Acres","ListingId":"NST6787830","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Payne-Phalen","NST_OfficeBoard":"SPAAR","ParcelNumber":"292922220020","GarageSpaces":"2","PhotosCount":"4","PostalCity":"Saint Paul","PostalCode":"55130","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicSurveyRange":"22","PublicSurveySection":"29","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","NST_AboveGradeSqFtTotal":"1252.0000","NST_BelowGradeSqFtTotal":"844.0000","NST_MainLevelFinishedArea":"844.0000","BuildingAreaTotal":"2096","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1244","BelowGradeFinishedArea":"844","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One and One Half","StreetDirSuffix":"E","StreetName":"Rose","StreetNumber":"419","StreetNumberNumeric":"419","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Zachrisons Add","NST_TaxWithAssessments":"3680.0000","TaxYear":"2025","TaxAnnualAmount":"3680","WaterSource":"City Water/Connected","YearBuilt":"1919","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-12T10:13:04.076Z","PhotosChangeTimestamp":"2025-09-12T03:16:04.486Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7801657\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"IMG_6992.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7801657/09a69749-5807-48bc-8609-76b15fb811a7.jpeg\",\"MediaModificationTimestamp\":\"2025-09-12T02:07:27.398Z\",\"MediaKey\":\"68c3805f95201979919aee06\"},{\"ResourceRecordKey\":\"NST7801657\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"IMG_6993.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7801657/13c1efd6-7fb5-4ce2-8c95-cc5fe026ae1d.jpeg\",\"MediaModificationTimestamp\":\"2025-09-12T02:07:27.415Z\",\"MediaKey\":\"68c3805f95201979919aee07\"},{\"ResourceRecordKey\":\"NST7801657\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"IMG_6994.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7801657/105d2f9a-c2bd-4bb7-a35a-0c8bf5021d66.jpeg\",\"MediaModificationTimestamp\":\"2025-09-12T03:15:05.387Z\",\"MediaKey\":\"68c390393e28030bc0c3ecc7\"},{\"ResourceRecordKey\":\"NST7801657\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"IMG_6995.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7801657/74bec67c-b32f-4bc6-9053-a415c648eb96.jpeg\",\"MediaModificationTimestamp\":\"2025-09-12T03:15:05.377Z\",\"MediaKey\":\"68c390393e28030bc0c3ecc8\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_6992.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_6993.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_6994.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_6995.jpeg\"}]","PhotoOrder":"1,2,3,4","CustomVTourURL":""}