{"Id":1388709,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6762865","MLSAGENTID":"NST506094338","MLSOFFICEID":"NST10071","ADDRESS":"595 Hawthorne Avenue E","ACRES":0.08,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full","BATHSTOTAL":1.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Metal Siding,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":234900.0,"LASTPRICEDATE":"2025-07-29T15:52:04.253","LATITUDE":44.978589,"LENDEROWNED":"No","LISTDATE":"2025-07-28T05:00:00","LISTPRICE":234900.0,"LIVINGAREA":883.0,"LONGITUDE":-93.075288,"MODIFICATIONTIMESTAMP":"2025-07-30T10:07:04.985","NEIGHBORHOOD":"Payne-Phalen","OFFICE_OFFICENAME":"Keller Williams Integrity Realty","PHOTOCOUNT":11,"POSTALCODE":"55130","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this bright and cheerful home, featuring a lovely screened-in front porch—perfect for relaxing\nsummer evenings. Inside, you'll find beautiful hardwood floors in the living room and a versatile\nmain-floor bedroom that can easily double as a home office. The updated kitchen includes brand-new cabinetry, countertops, flooring, and a new dishwasher—ideal for both everyday living and entertaining. A brand-new washer and dryer add even more convenience. Outside, enjoy a fenced backyard and a concrete parking pad in the rear for off-street parking. This move-in-ready gem combines comfort, functionality, and character.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected,City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-07-29T15:52:04.253","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"Hawthorne","STREETNUMBER":"595","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected,City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1906,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-07-30T03:01:04.383","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Exterior Front.jpg\"},{\"Order\":2,\"Remarks\":\"Living Room.jpg\"},{\"Order\":3,\"Remarks\":\"Living Room.jpg\"},{\"Order\":4,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":5,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":6,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":7,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":8,\"Remarks\":\"2nd Floor Primary Bathroom.jpg\"},{\"Order\":9,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":10,\"Remarks\":\"Backyard.jpg\"},{\"Order\":11,\"Remarks\":\"Exterior Rear.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11","SOURCE":"MG_NST"}
{"ListingKey":"NST7779857","LotSizeArea":"0.08","NST_AgeOfProperty":"119","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Hardwood Floors,Porch,Washer/Dryer Hookup","Appliances":"Dishwasher,Dryer,Range,Refrigerator,Washer","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Full","BasementYN":"True","NST_BathDesc":"Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"2","CumulativeDaysOnMarket":"2","NST_DiningRoomDescription":"Eat In Kitchen,Living/Dining Room","Directions":"1 BLOCK NO.OF MARYLAND AND 1 BLK W. OF EDGERTON","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Metal Siding,Vinyl Siding","Fencing":"Chain Link","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"526","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Concrete,Open","AccessibilityFeatures":"None","Heating":"Boiler,Hot Water","OriginalEntryTimestamp":"2025-07-29T15:47:43Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-07-30","Latitude":"44.978589","NST_LenderOwned":"No","ListAgentKey":"NST53356","ListAgentMlsId":"NST506094338","ListingContractDate":"2025-07-28T05:00:00Z","ListOfficeKey":"NST16710","ListOfficeName":"Keller Williams Integrity Realty","ListOfficeMlsId":"NST10071","ListPrice":"234900","LivingArea":"883","Longitude":"-93.075288","LotSizeDimensions":"30x121","LotSizeSquareFeet":"3615.48","LotSizeUnits":"Acres","ListingId":"NST6762865","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Payne-Phalen","NST_OfficeBoard":"SPAAR","ParcelNumber":"202922430059","GarageSpaces":"0","NST_ParkingOpen":"1","NST_PatioPorchType":"Front Porch","PhotosCount":"11","PostalCity":"Saint Paul","PostalCode":"55130","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Welcome to this bright and cheerful home, featuring a lovely screened-in front porch—perfect for relaxing\nsummer evenings. Inside, you'll find beautiful hardwood floors in the living room and a versatile\nmain-floor bedroom that can easily double as a home office. The updated kitchen includes brand-new cabinetry, countertops, flooring, and a new dishwasher—ideal for both everyday living and entertaining. A brand-new washer and dryer add even more convenience. Outside, enjoy a fenced backyard and a concrete parking pad in the rear for off-street parking. This move-in-ready gem combines comfort, functionality, and character.","PublicSurveyRange":"22","PublicSurveySection":"20","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3","NST_AboveGradeSqFtTotal":"883.0000","NST_BelowGradeSqFtTotal":"526.0000","NST_MainLevelFinishedArea":"883.0000","BuildingAreaTotal":"1409","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected,City Sewer - In Street","NST_SpecialSearch":"Main Floor Bedroom","AboveGradeFinishedArea":"883","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One and One Half","StreetDirSuffix":"E","StreetName":"Hawthorne","StreetNumber":"595","StreetNumberNumeric":"595","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Joseph R Weides 2nd Add","NST_TaxWithAssessments":"3126.0000","TaxYear":"2025","TaxAnnualAmount":"2783","WaterSource":"City Water/Connected,City Water - In Street","YearBuilt":"1906","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-07-30T10:07:04.985Z","PhotosChangeTimestamp":"2025-07-30T03:01:04.383Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7779857\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Exterior Front.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779857/bac69e79-61e4-4e65-8842-51387392b517.jpeg\",\"MediaModificationTimestamp\":\"2025-07-30T03:01:02.782Z\",\"MediaKey\":\"68898aeeab040c47406c5b8a\"},{\"ResourceRecordKey\":\"NST7779857\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Living Room.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779857/613f4ead-65de-48af-82ed-af4ac4b51b77.jpeg\",\"MediaModificationTimestamp\":\"2025-07-30T03:01:02.773Z\",\"MediaKey\":\"68898aeeab040c47406c5b8b\"},{\"ResourceRecordKey\":\"NST7779857\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Living Room.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779857/d5fa92b4-dc58-4380-a764-e3a848d65fa1.jpeg\",\"MediaModificationTimestamp\":\"2025-07-30T03:01:02.755Z\",\"MediaKey\":\"68898aeeab040c47406c5b8c\"},{\"ResourceRecordKey\":\"NST7779857\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Kitchen.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779857/c4343777-8614-454d-ae6a-aac849fed9e5.jpeg\",\"MediaModificationTimestamp\":\"2025-07-30T03:01:02.8Z\",\"MediaKey\":\"68898aeeab040c47406c5b8d\"},{\"ResourceRecordKey\":\"NST7779857\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Kitchen.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779857/4a92be0b-4665-48f5-8e94-eaeeeec78642.jpeg\",\"MediaModificationTimestamp\":\"2025-07-30T03:01:02.723Z\",\"MediaKey\":\"68898aeeab040c47406c5b8e\"},{\"ResourceRecordKey\":\"NST7779857\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Bedroom.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779857/a1520b81-8562-4c69-870e-eb99f74afb20.jpeg\",\"MediaModificationTimestamp\":\"2025-07-30T03:01:02.737Z\",\"MediaKey\":\"68898aeeab040c47406c5b8f\"},{\"ResourceRecordKey\":\"NST7779857\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"2nd Floor Primary Bedroom.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779857/b93f8ba9-b82b-4fd5-8fc9-68afaebbed6e.jpeg\",\"MediaModificationTimestamp\":\"2025-07-30T03:01:02.793Z\",\"MediaKey\":\"68898aeeab040c47406c5b90\"},{\"ResourceRecordKey\":\"NST7779857\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"2nd Floor Primary Bathroom.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779857/9551fe7d-1f1b-4275-8745-ec520f60f229.jpeg\",\"MediaModificationTimestamp\":\"2025-07-30T03:01:02.777Z\",\"MediaKey\":\"68898aeeab040c47406c5b91\"},{\"ResourceRecordKey\":\"NST7779857\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"2nd Floor Bedroom.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779857/e4221a81-cee2-4c7d-ae5c-759714c0fe90.jpeg\",\"MediaModificationTimestamp\":\"2025-07-30T03:01:02.787Z\",\"MediaKey\":\"68898aeeab040c47406c5b92\"},{\"ResourceRecordKey\":\"NST7779857\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Backyard.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779857/e3d24de9-dced-4015-933d-4a60010dd31b.jpeg\",\"MediaModificationTimestamp\":\"2025-07-30T03:01:02.816Z\",\"MediaKey\":\"68898aeeab040c47406c5b93\"},{\"ResourceRecordKey\":\"NST7779857\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Exterior Rear.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779857/fa989215-6cfb-4bec-89ca-3a98659661ca.jpeg\",\"MediaModificationTimestamp\":\"2025-07-30T03:01:02.818Z\",\"MediaKey\":\"68898aeeab040c47406c5b94\"}]","Rooms":"[{\"RoomKey\":\"NST115462961\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x10\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115462962\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x13\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115462963\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x12\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115462964\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x10\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115462965\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10x13\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115462966\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10x13\",\"NST_RoomSortOrder\":\"6\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Exterior Front.jpg\"},{\"Order\":2,\"Remarks\":\"Living Room.jpg\"},{\"Order\":3,\"Remarks\":\"Living Room.jpg\"},{\"Order\":4,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":5,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":6,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":7,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":8,\"Remarks\":\"2nd Floor Primary Bathroom.jpg\"},{\"Order\":9,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":10,\"Remarks\":\"Backyard.jpg\"},{\"Order\":11,\"Remarks\":\"Exterior Rear.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11","CustomVTourURL":""}