Menu
  • Home Page
  • Featured Listings
  • Daily Hotlist
  • Map Search
  • Your Favorites
  • Quick Print
  • Contact Mark
Client Portal

MLS# 6762865
595 Hawthorne Avenue E Saint Paul, MN 55130

Neighborhoods

Keller Williams Integrity Realty is the brokerage office representing the seller for this listing.

Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.

The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Mark Tietjen - Rusty's Up North Realty is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mark Tietjen - Rusty's Up North Realty, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

{"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":""}

Rusty's Up North Realty
Mark Tietjen - REALTOR®

4687 28th Ave NE
Longville, MN 56655

Phone: 218-947-3800
Toll Free: 218-536-0008
Fax: 218-363-3001
Email: mark@UpNorthRealtyMN.com

Direct Links

    Site Map

    • Home Page
    • Estimate Request
    • Featured Listings
    • Daily Hotlist
    • Map Search
    • Your Favorites
    • Contact Me
    • Notifications
    • Quick Print
    • DNR Lake Search

    Created & Designed by

    Real Estate Create


    © Copyright 2025
    All Rights Reserved