{"Id":1413280,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6794713","MLSAGENTID":"NST506005328","MLSOFFICEID":"NST25873","ADDRESS":"594 Charles Avenue","ACRES":0.11,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Unfinished","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":199000.0,"LASTPRICEDATE":"2025-09-25T16:01:03.797","LATITUDE":44.957285,"LENDEROWNED":"No","LISTDATE":"2025-09-25T05:00:00","LISTPRICE":199000.0,"LIVINGAREA":952.0,"LONGITUDE":-93.125238,"MODIFICATIONTIMESTAMP":"2025-09-26T10:07:04.273","NEIGHBORHOOD":"Thomas-Dale (Frogtown)","OFFICE_OFFICENAME":"Strata Real Estate Resources","PHOTOCOUNT":10,"POSTALCODE":"55103","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this newly remodeled home in the heart of Saint Paul! Conveniently located just steps away from ample amenities like restaurants, grocery stores, and more, this house offers a quiet neighborhood feel with all the convenience of a large city. Newly updated flooring throughout the house with new stainless steel appliances in an open kitchen layout. Large yard as well makes for perfect hosting.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected,City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-25T16:01:03.797","LASTSTATUS":"Active","STREETNAME":"Charles","STREETNUMBER":"594","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected,City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1884,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-26T03:14:05.268","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Beautiful front yard with a nice wooden fence to create privacy between the front and back of house.\"},{\"Order\":2,\"Remarks\":\"Newly updated kitchen with stainless steel appliances and a very open layout.\"},{\"Order\":3,\"Remarks\":\"594-Charles-Kitchen 1.jpg\"},{\"Order\":4,\"Remarks\":\"Tiled bathroom with new fixtures and gorgeous natural light create a spa like feel in this bathroom.\"},{\"Order\":5,\"Remarks\":\"This downstairs half bath is convenient for guest use.\"},{\"Order\":6,\"Remarks\":\"Spacious upstairs bathroom receives ample light throughout the day.\"},{\"Order\":7,\"Remarks\":\"Spacious upstairs bathroom receives ample light throughout the day.\"},{\"Order\":8,\"Remarks\":\"Upstairs bedroom\"},{\"Order\":9,\"Remarks\":\"Downstairs bedroom that connects directly to the living room\"},{\"Order\":10,\"Remarks\":\"Open living room leads directly into the kitchen\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10","SOURCE":"MG_NST"}
{"ListingKey":"NST7807542","LotSizeArea":"0.11","NST_AgeOfProperty":"141","NST_AgentOwner":"Yes","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Unfinished","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"99","Directions":"From I-94, take Dale St exit south, turn left on University Ave, then right on Charles Ave. Continue to 594 Charles.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"544","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric,Natural Gas","ParkingFeatures":"None","AccessibilityFeatures":"None","Heating":"Baseboard","OriginalEntryTimestamp":"2025-09-25T15:59:27Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-26","Latitude":"44.957285","NST_LenderOwned":"No","ListAgentKey":"NST88202","ListAgentMlsId":"NST506005328","ListingContractDate":"2025-09-25T05:00:00Z","ListOfficeKey":"NST25873","ListOfficeName":"Strata Real Estate Resources","ListOfficeMlsId":"NST25873","ListPrice":"199000","LivingArea":"952","Longitude":"-93.125238","LotSizeDimensions":"0","LotSizeSquareFeet":"4704.48","LotSizeUnits":"Acres","ListingId":"NST6794713","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Thomas-Dale (Frogtown)","NST_OfficeBoard":"SPAAR","ParcelNumber":"362923230197","GarageSpaces":"0","PhotosCount":"10","PostalCity":"Saint Paul","PostalCode":"55103","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Welcome to this newly remodeled home in the heart of Saint Paul! Conveniently located just steps away from ample amenities like restaurants, grocery stores, and more, this house offers a quiet neighborhood feel with all the convenience of a large city. Newly updated flooring throughout the house with new stainless steel appliances in an open kitchen layout. Large yard as well makes for perfect hosting.","PublicSurveyRange":"23","PublicSurveySection":"36","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","NST_AboveGradeSqFtTotal":"952.0000","NST_BelowGradeSqFtTotal":"126.0000","NST_MainLevelFinishedArea":"544.0000","BuildingAreaTotal":"1078","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected,City Sewer - In Street","AboveGradeFinishedArea":"952","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Charles","StreetNumber":"594","StreetNumberNumeric":"594","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Subd Of Blk 13 Stinsons Div","NST_TaxWithAssessments":"2358.0000","TaxYear":"2024","TaxAnnualAmount":"2358","WaterSource":"City Water/Connected,City Water - In Street","YearBuilt":"1884","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-26T10:07:04.273Z","PhotosChangeTimestamp":"2025-09-26T03:14:05.268Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7807542\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Beautiful front yard with a nice wooden fence to create privacy between the front and back of house.\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807542/4bdbfa56-fdd9-4d8c-a402-b206fe2f02e7.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T03:13:35.947Z\",\"MediaKey\":\"68d604e0d70f773b48ce6f2a\"},{\"ResourceRecordKey\":\"NST7807542\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Newly updated kitchen with stainless steel appliances and a very open layout.\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807542/368cd2d5-830f-48ff-a57c-2c0240612c97.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T03:13:35.93Z\",\"MediaKey\":\"68d604e0d70f773b48ce6f2b\"},{\"ResourceRecordKey\":\"NST7807542\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"594-Charles-Kitchen 1.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807542/666b4185-3d24-4426-aeb6-d68b27160575.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T03:13:35.931Z\",\"MediaKey\":\"68d604e0d70f773b48ce6f2c\"},{\"ResourceRecordKey\":\"NST7807542\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Tiled bathroom with new fixtures and gorgeous natural light create a spa like feel in this bathroom.\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807542/69269b13-395a-4209-aeea-d983bee8f25c.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T03:13:35.956Z\",\"MediaKey\":\"68d604e0d70f773b48ce6f2d\"},{\"ResourceRecordKey\":\"NST7807542\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"This downstairs half bath is convenient for guest use.\",\"ImageWidth\":2080,\"ImageHeight\":1169,\"ImageSizeDescription\":\"2080x1169\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807542/1a618045-19b3-4bd7-9e88-ffa55903881e.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T03:13:35.968Z\",\"MediaKey\":\"68d604e0d70f773b48ce6f2e\"},{\"ResourceRecordKey\":\"NST7807542\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Spacious upstairs bathroom receives ample light throughout the day.\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807542/eaa4b9ec-e5cf-439f-91c1-45e51a13da48.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T03:13:36.011Z\",\"MediaKey\":\"68d604e0d70f773b48ce6f2f\"},{\"ResourceRecordKey\":\"NST7807542\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Spacious upstairs bathroom receives ample light throughout the day.\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807542/ee5974c1-ff96-40de-9ce5-b8b07eaa22cc.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T03:13:36.009Z\",\"MediaKey\":\"68d604e0d70f773b48ce6f30\"},{\"ResourceRecordKey\":\"NST7807542\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Upstairs bedroom\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807542/d1c3d9c6-f59e-4564-b706-096037d19556.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T03:13:36.077Z\",\"MediaKey\":\"68d604e0d70f773b48ce6f31\"},{\"ResourceRecordKey\":\"NST7807542\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Downstairs bedroom that connects directly to the living room\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807542/379bf1fa-1bc4-42d3-938c-d93e30db7b59.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T03:13:36.032Z\",\"MediaKey\":\"68d604e0d70f773b48ce6f32\"},{\"ResourceRecordKey\":\"NST7807542\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Open living room leads directly into the kitchen\",\"ImageWidth\":2080,\"ImageHeight\":1169,\"ImageSizeDescription\":\"2080x1169\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807542/6f0e7271-ab50-484a-85d1-d11084cb09be.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T03:13:36.09Z\",\"MediaKey\":\"68d604e0d70f773b48ce6f33\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Beautiful front yard with a nice wooden fence to create privacy between the front and back of house.\"},{\"Order\":2,\"Remarks\":\"Newly updated kitchen with stainless steel appliances and a very open layout.\"},{\"Order\":3,\"Remarks\":\"594-Charles-Kitchen 1.jpg\"},{\"Order\":4,\"Remarks\":\"Tiled bathroom with new fixtures and gorgeous natural light create a spa like feel in this bathroom.\"},{\"Order\":5,\"Remarks\":\"This downstairs half bath is convenient for guest use.\"},{\"Order\":6,\"Remarks\":\"Spacious upstairs bathroom receives ample light throughout the day.\"},{\"Order\":7,\"Remarks\":\"Spacious upstairs bathroom receives ample light throughout the day.\"},{\"Order\":8,\"Remarks\":\"Upstairs bedroom\"},{\"Order\":9,\"Remarks\":\"Downstairs bedroom that connects directly to the living room\"},{\"Order\":10,\"Remarks\":\"Open living room leads directly into the kitchen\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10","CustomVTourURL":""}