{"Id":583236,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7104651","MLSAGENTID":"NST502043396","MLSOFFICEID":"NST11542","ADDRESS":"2075 Hawthorne Avenue E","ACRES":0.151,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Block,Partially Finished","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":299900.0,"LASTPRICEDATE":"2026-07-08T21:52:08.493","LATITUDE":44.979147,"LENDEROWNED":"No","LISTDATE":"2026-07-08T05:00:00","LISTPRICE":299900.0,"LIVINGAREA":1310.0,"LONGITUDE":-93.012733,"MODIFICATIONTIMESTAMP":"2026-07-09T15:00:09.616","NEIGHBORHOOD":"92","OFFICE_OFFICENAME":"Trilogy Properties of MN, LLC","PHOTOCOUNT":10,"POSTALCODE":"55119","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to 2075 Hawthorne Ave!\n\nThis rehabbed, modern yet cozy 3-bedroom, 1-bath home is ready for new owners. Cook a meal in the updated kitchen with a tile backsplash, quartz countertops, and stainless-steel appliances.\n\nMany of the big-ticket items have already been taken care of in this gem. It truly is move-in ready. Don't miss the basement bar area, which is awaiting your final touches. Man cave? Movie room? Make it yours today.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-07-08T21:52:08.493","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"Hawthorne","STREETNUMBER":"2075","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1955,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-07-08T21:50:08.185","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10","SOURCE":"MG_NST"}
{"ListingKey":"NST7930321","NST_AboveGradeSqFtTotal":"988","AboveGradeFinishedArea":"988","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","Appliances":"Dishwasher,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Partially Finished","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"322","BelowGradeFinishedArea":"322","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"Ruth St N to Hawthorne","DocumentsCount":"3","DocumentsChangeTimestamp":"2026-07-09T14:59:07.645Z","DaysOnMarket":"0","ExteriorFeatures":"Wood","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"988","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"308","NST_GarageDimensions":"14x22","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.979147","NST_LenderOwned":"No","Levels":"One","ListPrice":"299900","ListingContractDate":"2026-07-08T05:00:00Z","ListingId":"NST7104651","LivingArea":"1310","Longitude":"-93.012733","LotSizeArea":"0.151","LotSizeDimensions":"110x60","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"988","NST_ManufacturedHome":"N","NST_NeighborhoodName":"Greater East Side","NST_NeighborhoodNumber":"92","OriginalEntryTimestamp":"2026-07-08T16:48:29Z","ParcelNumber":"232922430093","ParkingFeatures":"Detached Garage","PhotosCount":"10","PhotosChangeTimestamp":"2026-07-08T21:50:08.185Z","PostalCity":"Saint Paul","PostalCode":"55119","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Welcome to 2075 Hawthorne Ave!\n\nThis rehabbed, modern yet cozy 3-bedroom, 1-bath home is ready for new owners. Cook a meal in the updated kitchen with a tile backsplash, quartz countertops, and stainless-steel appliances.\n\nMany of the big-ticket items have already been taken care of in this gem. It truly is move-in ready. Don't miss the basement bar area, which is awaiting your final touches. Man cave? Movie room? Make it yours today.","PublicSurveyRange":"22","PublicSurveySection":"23","PublicSurveyTownship":"29","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"E","StreetName":"Hawthorne","StreetNumber":"2075","StreetNumberNumeric":"2075","StreetSuffix":"Avenue","SubdivisionName":"Murray Lane Add 2","TaxAnnualAmount":"3162","NST_TaxWithAssessments":"3162","TaxYear":"2025","NST_TotalArea":"1310","BuildingAreaTotal":"1310","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1955","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST100426","ListAgentMlsId":"NST502043396","ListOfficeMlsId":"NST11542","ListOfficeName":"Trilogy Properties of MN, LLC","ListOfficeKey":"NST19465","ModificationTimestamp":"2026-07-09T15:00:09.616Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7930321\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7930321/23b7c695-4563-4c36-83d1-7b80d5b7d0fa.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1276,\"ImageSizeDescription\":\"1920x1276\",\"MediaModificationTimestamp\":\"2026-07-08T21:49:14.974Z\",\"MediaKey\":\"NST123441957\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7930321\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7930321/b3f2a0b4-a776-42d0-a27b-f09d2a7d4f15.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-07-08T21:49:14.977Z\",\"MediaKey\":\"NST123441954\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7930321\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7930321/e6527e4a-e00c-4d8e-8e0d-88d47fa8e0da.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-07-08T21:49:14.993Z\",\"MediaKey\":\"NST123441952\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7930321\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7930321/4c785b42-7d3e-49d2-966b-486011c33f8f.jpeg\",\"ImageWidth\":1902,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1902x1280\",\"MediaModificationTimestamp\":\"2026-07-08T21:49:14.985Z\",\"MediaKey\":\"NST123441958\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7930321\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7930321/f133040f-0906-480e-859a-761d4cab9a0c.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-07-08T21:49:14.978Z\",\"MediaKey\":\"NST123441939\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7930321\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7930321/26ccaa49-b517-4583-8261-8eda45552d79.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-07-08T21:49:15.056Z\",\"MediaKey\":\"NST123441953\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7930321\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7930321/6cc1415e-7436-4dd4-bc20-80a0d7d536cd.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-07-08T21:49:15.048Z\",\"MediaKey\":\"NST123441955\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7930321\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7930321/8eb593ff-ef46-4a0c-876e-74a411850d7c.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-07-08T21:49:14.988Z\",\"MediaKey\":\"NST123441956\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7930321\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7930321/e3fed3eb-5b2a-438b-ab63-f7371cc3d4d9.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1279,\"ImageSizeDescription\":\"1920x1279\",\"MediaModificationTimestamp\":\"2026-07-08T21:49:15.019Z\",\"MediaKey\":\"NST123441938\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7930321\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7930321/065911d2-00ee-4adf-ad14-f317e7ec9785.jpeg\",\"ImageWidth\":1907,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1907x1280\",\"MediaModificationTimestamp\":\"2026-07-08T21:49:15.014Z\",\"MediaKey\":\"NST123441951\"}]","Media__Order":"5","Media__MediaObjectID":"NST5","Media__ResourceRecordKey":"NST7930321","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7930321/23b7c695-4563-4c36-83d1-7b80d5b7d0fa.jpeg","Media__ImageWidth":"1920","Media__ImageHeight":"1276","Media__ImageSizeDescription":"1920x1276","Media__MediaModificationTimestamp":"7/8/2026 9:49:14 PM","Media__MediaKey":"NST123441957","Rooms":"[{\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116427218\",\"RoomDimensions\":\"10x7\",\"RoomLevel\":\"Main\",\"RoomType\":\"Dining Room\"},{\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116427223\",\"RoomDimensions\":\"20x12\",\"RoomLevel\":\"Basement\",\"RoomType\":\"Family Room\"},{\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116427220\",\"RoomDimensions\":\"12x9\",\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom\"},{\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116427219\",\"RoomDimensions\":\"9x8\",\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\"},{\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116427217\",\"RoomDimensions\":\"19x13\",\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\"},{\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116427221\",\"RoomDimensions\":\"12x8\",\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom 2\"},{\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116427222\",\"RoomDimensions\":\"12x8\",\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom 3\"}]","Rooms__NST_RoomSortOrder":"2","Rooms__RoomKey":"NST116427218","Rooms__RoomDimensions":"10x7","Rooms__RoomLevel":"Main","Rooms__RoomType":"Dining Room","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10","CustomVTourURL":""}