{"Id":1437473,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6822601","MLSAGENTID":"NST506091438","MLSOFFICEID":"NST10185","ADDRESS":"804 Hawthorne Avenue E","ACRES":0.111,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Unfinished","BATHSTOTAL":1.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":269900.0,"LASTPRICEDATE":"2025-12-08T23:34:05.977","LATITUDE":44.97816,"LENDEROWNED":"No","LISTDATE":"2025-12-08T06:00:00","LISTPRICE":269900.0,"LIVINGAREA":1217.0,"LONGITUDE":-93.066635,"MODIFICATIONTIMESTAMP":"2025-12-08T23:34:05.975","NEIGHBORHOOD":"98","OFFICE_OFFICENAME":"RE/MAX Professionals","PHOTOCOUNT":0,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to 804 Hawthorne Avenue East in St. Paul, a beautifully updated home that combines modern amenities with classic charm. Inside, you'll find fresh paint throughout and refinished hardwood floors that enhance the home's timeless appeal. The updated bathroom provides a stylish retreat, while newer HVAC ensures year-round comfort.\nThis home offers three cozy bedrooms and one well-appointed bathroom, making it ideal for a variety of living situations. The spacious 3-season porch at the back of the house adds additional living space, perfect for enjoying the outdoors in any season.\nThe fenced backyard provides privacy and a great space for pets, play, or gardening. The one-car garage offers convenience, while the large driveway provides ample parking.\nLocated in a desirable St. Paul neighborhood, this home is truly move-in ready, with all the updates and features you need for easy, comfortable living. Don't miss out on the opportunity to make this gem your own!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-12-08T23:34:05.977","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"Hawthorne","STREETNUMBER":"804","STREETSUFFIX":"Avenue","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1912,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-12-08T23:32:06.189","SOURCE":"MG_NST"}
{"ListingKey":"NST7831574","NST_AboveGradeSqFtTotal":"1217","AboveGradeFinishedArea":"1217","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Window,Natural Woodwork,Porch,Washer/Dryer Hookup","Appliances":"Range,Refrigerator","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Full,Unfinished","BasementYN":"True","NST_BathDesc":"Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"734","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Living/Dining Room","Directions":"Arcade to Hawthorne on Left.","DaysOnMarket":"0","Fencing":"Chain Link","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"734","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"285","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.97816","LaundryFeatures":"In Basement,Washer Hookup","NST_LenderOwned":"No","Levels":"One and One Half","ListPrice":"269900","ListingContractDate":"2025-12-08T06:00:00Z","ListingId":"NST6822601","LivingArea":"1217","Longitude":"-93.066635","LotSizeArea":"0.111","LotSizeDimensions":"40x121","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"734","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"98","OriginalEntryTimestamp":"2025-12-08T17:31:29Z","ParcelNumber":"202922440152","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Detached Garage","NST_PatioPorchType":"Porch","PhotosCount":"0","PhotosChangeTimestamp":"2025-12-08T23:32:06.189Z","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertyType":"Residential","PublicRemarks":"Welcome to 804 Hawthorne Avenue East in St. Paul, a beautifully updated home that combines modern amenities with classic charm. Inside, you'll find fresh paint throughout and refinished hardwood floors that enhance the home's timeless appeal. The updated bathroom provides a stylish retreat, while newer HVAC ensures year-round comfort.\nThis home offers three cozy bedrooms and one well-appointed bathroom, making it ideal for a variety of living situations. The spacious 3-season porch at the back of the house adds additional living space, perfect for enjoying the outdoors in any season.\nThe fenced backyard provides privacy and a great space for pets, play, or gardening. The one-car garage offers convenience, while the large driveway provides ample parking.\nLocated in a desirable St. Paul neighborhood, this home is truly move-in ready, with all the updates and features you need for easy, comfortable living. Don't miss out on the opportunity to make this gem your own!","PublicSurveyRange":"22","PublicSurveySection":"20","PublicSurveyTownship":"29","Roof":"Asphalt","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"E","StreetName":"Hawthorne","StreetNumber":"804","StreetNumberNumeric":"804","StreetSuffix":"Avenue","SubdivisionName":"Oak Ville Park","TaxAnnualAmount":"3811","NST_TaxWithAssessments":"4154","TaxYear":"2025","Township":"Saint Paul","WaterSource":"City Water/Connected","YearBuilt":"1912","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST49964","ListAgentMlsId":"NST506091438","ListOfficeMlsId":"NST10185","ListOfficeName":"RE/MAX Professionals","ListOfficeKey":"NST16539","ModificationTimestamp":"2025-12-08T23:34:05.975Z","OriginatingSystemName":"northstar","Rooms":"[{\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST115801966\",\"RoomDimensions\":\"14x14\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST115801964\",\"RoomDimensions\":\"12x11\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST115801965\",\"RoomDimensions\":\"10x13\",\"RoomType\":\"Porch\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST115801962\",\"RoomDimensions\":\"13x13\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST115801963\",\"RoomDimensions\":\"12x11\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST115801960\",\"RoomDimensions\":\"10x12\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST115801961\",\"RoomDimensions\":\"7x11\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\"}]","MlgCanView":"True","MlgCanUse":"IDX","CustomVTourURL":""}