mike@minnesotarealestatesales.com
Phone: 218-821-4775
- About
- Pelican Lake
- Ossawinnamakee Lake
- Horseshoe Lake
- Advanced Search
- Daily Hotsheets
- Buyers
- Sellers
- Estimate Request
- Popular Listings
- Favorite Listings
- Pelican Lakes Association
- Conservation Club
- DNR Lake Information
Contact me here...
$STITLE$
$SCONTENT$
$LABEL$
$SCONTENT$
RE/MAX Professionals 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. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
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. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":540672,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST7053278","MLSAGENTID":"NST506091438","MLSOFFICEID":"NST10185","ADDRESS":"804 Hawthorne Avenue E","ACRES":0.111,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Unfinished","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":2700.0,"LASTPRICEDATE":"2026-04-11T19:39:06.343","LATITUDE":44.97816,"LENDEROWNED":"No","LISTDATE":"2026-04-11T05:00:00","LISTPRICE":2700.0,"LIVINGAREA":1217.0,"LONGITUDE":-93.066635,"MODIFICATIONTIMESTAMP":"2026-04-11T19:39:06.342","NEIGHBORHOOD":"98","OFFICE_OFFICENAME":"RE/MAX Professionals","PHOTOCOUNT":43,"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. This 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. The 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. Located 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,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-04-11T19:39:06.343","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"Hawthorne","STREETNUMBER":"804","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Rent","WATER":"City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1912,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-04-11T19:36:06.224","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1-web-or-mls-DSC00900-1.JPG\"},{\"Order\":2,\"Remarks\":\"2-web-or-mls-DSC00906-1.JPG\"},{\"Order\":3,\"Remarks\":\"3-web-or-mls-DSC00903_.jpg\"},{\"Order\":4,\"Remarks\":\"4-web-or-mls-DSC00797.jpg\"},{\"Order\":5,\"Remarks\":\"5-web-or-mls-DSC00800.jpg\"},{\"Order\":6,\"Remarks\":\"6-web-or-mls-DSC00803.jpg\"},{\"Order\":7,\"Remarks\":\"7-web-or-mls-DSC00803 virtually staged.jpeg\"},{\"Order\":8,\"Remarks\":\"8-web-or-mls-DSC00806.jpg\"},{\"Order\":9,\"Remarks\":\"9-web-or-mls-DSC00806 virtually staged.jpeg\"},{\"Order\":10,\"Remarks\":\"10-web-or-mls-DSC00809.jpg\"},{\"Order\":11,\"Remarks\":\"11-web-or-mls-DSC00812.jpg\"},{\"Order\":12,\"Remarks\":\"12-web-or-mls-DSC00815.jpg\"},{\"Order\":13,\"Remarks\":\"13-web-or-mls-DSC00818.jpg\"},{\"Order\":14,\"Remarks\":\"14-web-or-mls-DSC00821.jpg\"},{\"Order\":15,\"Remarks\":\"15-web-or-mls-DSC00824.jpg\"},{\"Order\":16,\"Remarks\":\"16-web-or-mls-DSC00827.jpg\"},{\"Order\":17,\"Remarks\":\"17-web-or-mls-DSC00830.jpg\"},{\"Order\":18,\"Remarks\":\"18-web-or-mls-DSC00833.jpg\"},{\"Order\":19,\"Remarks\":\"19-web-or-mls-DSC00836.jpg\"},{\"Order\":20,\"Remarks\":\"20-web-or-mls-DSC00839.jpg\"},{\"Order\":21,\"Remarks\":\"21-web-or-mls-DSC00842.jpg\"},{\"Order\":22,\"Remarks\":\"22-web-or-mls-DSC00845.jpg\"},{\"Order\":23,\"Remarks\":\"23-web-or-mls-DSC00845 virtually staged.jpeg\"},{\"Order\":24,\"Remarks\":\"24-web-or-mls-DSC00848.jpg\"},{\"Order\":25,\"Remarks\":\"25-web-or-mls-DSC00851.jpg\"},{\"Order\":26,\"Remarks\":\"26-web-or-mls-DSC00851 virtually staged.jpeg\"},{\"Order\":27,\"Remarks\":\"27-web-or-mls-DSC00854.jpg\"},{\"Order\":28,\"Remarks\":\"28-web-or-mls-DSC00857.jpg\"},{\"Order\":29,\"Remarks\":\"29-web-or-mls-DSC00860.jpg\"},{\"Order\":30,\"Remarks\":\"30-web-or-mls-DSC00863.jpg\"},{\"Order\":31,\"Remarks\":\"31-web-or-mls-DSC00866.jpg\"},{\"Order\":32,\"Remarks\":\"32-web-or-mls-DSC00869.jpg\"},{\"Order\":33,\"Remarks\":\"33-web-or-mls-DSC00873-1.JPG\"},{\"Order\":34,\"Remarks\":\"34-web-or-mls-DSC00875.jpg\"},{\"Order\":35,\"Remarks\":\"35-web-or-mls-DSC00878.jpg\"},{\"Order\":36,\"Remarks\":\"36-web-or-mls-DSC00882-1.JPG\"},{\"Order\":37,\"Remarks\":\"37-web-or-mls-DSC00885-1.JPG\"},{\"Order\":38,\"Remarks\":\"38-web-or-mls-DSC00888-1.JPG\"},{\"Order\":39,\"Remarks\":\"39-web-or-mls-DSC00891-1.JPG\"},{\"Order\":40,\"Remarks\":\"40-web-or-mls-DSC00894-1.JPG\"},{\"Order\":41,\"Remarks\":\"41-web-or-mls-DSC00897-1.JPG\"},{\"Order\":42,\"Remarks\":\"42-web-or-mls-DSC00903-1.JPG\"},{\"Order\":43,\"Remarks\":\"43-web-or-mls-DSC00903.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43","SOURCE":"MG_NST"}
{"ListingKey":"NST7883487","NST_AboveGradeSqFtTotal":"1217","AboveGradeFinishedArea":"1217","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Range,Refrigerator","NST_ApplicationFee":"45","LivingAreaUnits":"Square Feet","AssociationYN":"False","AssociationFee":"0","AvailabilityDate":"2026-04-13T05:00:00Z","NST_BackgroundCheckReq":"Y","Basement":"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":"Separate/Formal Dining Room","Directions":"Hwy 61 to hawthorne","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-04-11T19:39:06.342Z","DaysOnMarket":"0","Fencing":"Chain Link","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"734","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","Furnished":"Unfurnished","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":"Lower Level","NST_LeasePrice":"2700","NST_LenderOwned":"No","Levels":"Two","ListingContractDate":"2026-04-11T05:00:00Z","ListingId":"NST7053278","LivingArea":"1217","Longitude":"-93.066635","LotSizeArea":"0.111","LotSizeDimensions":"40x121","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"734","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"98","OriginalEntryTimestamp":"2026-04-11T14:34:38Z","OwnerPays":"Insurance,Taxes","ParcelNumber":"202922440152","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Detached Garage","NST_PatioPorchType":"Porch","PhotosCount":"43","PhotosChangeTimestamp":"2026-04-11T19:36:06.224Z","PostalCity":"Saint Paul","PostalCode":"55106","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential Lease","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. This 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. The 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. Located 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","NST_RentSpreeYN":"N","NST_SchoolDistrictPhone":"6517678100","NST_SecurityDeposit":"2700","Sewer":"City Sewer - In Street","NST_SmokingPermitted":"N","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"E","StreetName":"Hawthorne","StreetNumber":"804","StreetNumberNumeric":"804","StreetSuffix":"Avenue","SubdivisionName":"Oak Ville Park","TenantPays":"Electricity,Gas,Hot Water,Lawn Care,Sewer,Snow Removal","BuildingAreaTotal":"1951","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water - In Street","YearBuilt":"1912","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST49964","ListAgentMlsId":"NST506091438","ListOfficeMlsId":"NST10185","ListOfficeName":"RE/MAX Professionals","ListOfficeKey":"NST16539","ModificationTimestamp":"2026-04-11T19:39:06.342Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"22-web-or-mls-DSC00845.jpg\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/10faa09c-9451-49d2-bca1-bafebfaa9e1b.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.544Z\",\"MediaKey\":\"NST121457150\"},{\"LongDescription\":\"27-web-or-mls-DSC00854.jpg\",\"Order\":27,\"MediaObjectID\":\"NST27\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/480f8c70-5ed3-472a-9056-9be1be9f85ff.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.592Z\",\"MediaKey\":\"NST121457145\"},{\"LongDescription\":\"21-web-or-mls-DSC00842.jpg\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/cd2d5a6f-47cd-41b6-9f05-15be0461a97b.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":1536,\"ImageSizeDescription\":\"1024x1536\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.567Z\",\"MediaKey\":\"NST121457151\"},{\"LongDescription\":\"6-web-or-mls-DSC00803.jpg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/8aec96d2-4b72-4e11-93a4-dc87476b2741.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.595Z\",\"MediaKey\":\"NST121457166\"},{\"LongDescription\":\"4-web-or-mls-DSC00797.jpg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/b965e883-d2b0-4e79-a6c4-dd8f9bd6e7f3.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.547Z\",\"MediaKey\":\"NST121457168\"},{\"LongDescription\":\"8-web-or-mls-DSC00806.jpg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/f3f8ee3d-534d-4d54-918e-87ad1054e964.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.51Z\",\"MediaKey\":\"NST121457164\"},{\"LongDescription\":\"19-web-or-mls-DSC00836.jpg\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/bbe2f770-c81a-4bf7-be7d-d1a5881e790e.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.534Z\",\"MediaKey\":\"NST121457153\"},{\"LongDescription\":\"20-web-or-mls-DSC00839.jpg\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/172bdb55-2cdd-451d-aac5-5315bc8bc401.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":1536,\"ImageSizeDescription\":\"1024x1536\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.509Z\",\"MediaKey\":\"NST121457152\"},{\"LongDescription\":\"41-web-or-mls-DSC00897-1.JPG\",\"Order\":41,\"MediaObjectID\":\"NST41\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/108766bc-1c63-4884-b006-0d6cfa5e692a.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.612Z\",\"MediaKey\":\"NST121457131\"},{\"LongDescription\":\"30-web-or-mls-DSC00863.jpg\",\"Order\":30,\"MediaObjectID\":\"NST30\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/f2767572-f9f4-45f9-ac5b-5baecae85215.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.531Z\",\"MediaKey\":\"NST121457142\"},{\"LongDescription\":\"18-web-or-mls-DSC00833.jpg\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/f6601bef-36fa-4171-bec9-6f9701fc6fa3.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.54Z\",\"MediaKey\":\"NST121457154\"},{\"LongDescription\":\"31-web-or-mls-DSC00866.jpg\",\"Order\":31,\"MediaObjectID\":\"NST31\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/9c42c012-4fd2-4401-9d0b-c5c7fbd61722.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.569Z\",\"MediaKey\":\"NST121457141\"},{\"LongDescription\":\"34-web-or-mls-DSC00875.jpg\",\"Order\":34,\"MediaObjectID\":\"NST34\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/767175bd-29c1-451f-9950-b25cb989c210.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.531Z\",\"MediaKey\":\"NST121457138\"},{\"LongDescription\":\"16-web-or-mls-DSC00827.jpg\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/060a4d8c-b774-4885-8909-2cb25c6da9cd.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.534Z\",\"MediaKey\":\"NST121457156\"},{\"LongDescription\":\"39-web-or-mls-DSC00891-1.JPG\",\"Order\":39,\"MediaObjectID\":\"NST39\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/d35e3af9-db44-4d29-8f7d-ad5b21973460.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.634Z\",\"MediaKey\":\"NST121457133\"},{\"LongDescription\":\"1-web-or-mls-DSC00900-1.JPG\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/c70319e1-baed-4fb2-ab4b-9f20b569f845.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.633Z\",\"MediaKey\":\"NST121457171\"},{\"LongDescription\":\"14-web-or-mls-DSC00821.jpg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/1f59abdf-2ffd-4fca-920c-c2e94e2bc6c2.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.51Z\",\"MediaKey\":\"NST121457158\"},{\"LongDescription\":\"24-web-or-mls-DSC00848.jpg\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/e20717ce-832c-4b67-926c-7d380552a5c7.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.509Z\",\"MediaKey\":\"NST121457148\"},{\"LongDescription\":\"35-web-or-mls-DSC00878.jpg\",\"Order\":35,\"MediaObjectID\":\"NST35\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/a0859a28-a4a5-4e0e-bd94-0abe4b0d23f5.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.546Z\",\"MediaKey\":\"NST121457137\"},{\"LongDescription\":\"5-web-or-mls-DSC00800.jpg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/c8d23355-4a26-4fae-b294-88d1f7704192.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.51Z\",\"MediaKey\":\"NST121457167\"},{\"LongDescription\":\"32-web-or-mls-DSC00869.jpg\",\"Order\":32,\"MediaObjectID\":\"NST32\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/1cc0850a-528a-4e81-a7b3-fd23352395c0.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.51Z\",\"MediaKey\":\"NST121457140\"},{\"LongDescription\":\"25-web-or-mls-DSC00851.jpg\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/811db40c-054c-4d84-ac0c-37d96865326d.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.509Z\",\"MediaKey\":\"NST121457147\"},{\"LongDescription\":\"42-web-or-mls-DSC00903-1.JPG\",\"Order\":42,\"MediaObjectID\":\"NST42\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/0770315b-42e9-4b4e-a61b-c985c13431ea.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.625Z\",\"MediaKey\":\"NST121457130\"},{\"LongDescription\":\"12-web-or-mls-DSC00815.jpg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/b464ee4e-3be8-4ad2-9e74-5f10c303ad8a.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.534Z\",\"MediaKey\":\"NST121457160\"},{\"LongDescription\":\"11-web-or-mls-DSC00812.jpg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/469c19af-3e00-480f-afbd-cfa5840663e0.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.51Z\",\"MediaKey\":\"NST121457161\"},{\"LongDescription\":\"13-web-or-mls-DSC00818.jpg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/3617e1f4-8c00-4f40-8848-8803894592be.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.539Z\",\"MediaKey\":\"NST121457159\"},{\"LongDescription\":\"28-web-or-mls-DSC00857.jpg\",\"Order\":28,\"MediaObjectID\":\"NST28\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/c62207ee-ea34-4a4a-b963-f637b06c32ef.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.536Z\",\"MediaKey\":\"NST121457144\"},{\"LongDescription\":\"3-web-or-mls-DSC00903_.jpg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/96ad929c-0676-41a0-b75a-4752c78e2cb2.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.556Z\",\"MediaKey\":\"NST121457169\"},{\"LongDescription\":\"10-web-or-mls-DSC00809.jpg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/103866a9-6a16-4f96-a348-f34e881b12a7.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.509Z\",\"MediaKey\":\"NST121457162\"},{\"LongDescription\":\"33-web-or-mls-DSC00873-1.JPG\",\"Order\":33,\"MediaObjectID\":\"NST33\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/6e882f85-ba60-4021-9078-e5a414e8b61d.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.557Z\",\"MediaKey\":\"NST121457139\"},{\"LongDescription\":\"36-web-or-mls-DSC00882-1.JPG\",\"Order\":36,\"MediaObjectID\":\"NST36\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/e86f6675-3688-4903-ae12-5ebaaba23405.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.556Z\",\"MediaKey\":\"NST121457136\"},{\"LongDescription\":\"9-web-or-mls-DSC00806 virtually staged.jpeg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/2e629780-680c-45b8-ad43-ed9a9c368425.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.546Z\",\"MediaKey\":\"NST121457163\"},{\"LongDescription\":\"15-web-or-mls-DSC00824.jpg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/7d372df5-ed7f-4cab-ab1a-0d5ec23a0251.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1368,\"ImageSizeDescription\":\"2048x1368\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.51Z\",\"MediaKey\":\"NST121457157\"},{\"LongDescription\":\"7-web-or-mls-DSC00803 virtually staged.jpeg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/3445fdd8-ee61-47a3-9335-f4d9d1adfe12.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.587Z\",\"MediaKey\":\"NST121457165\"},{\"LongDescription\":\"29-web-or-mls-DSC00860.jpg\",\"Order\":29,\"MediaObjectID\":\"NST29\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/0e38257b-0244-4e97-8cb5-f235f6ba2ba4.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.51Z\",\"MediaKey\":\"NST121457143\"},{\"LongDescription\":\"17-web-or-mls-DSC00830.jpg\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/2eeac4ea-3683-43cd-ac29-44a5c4b29509.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.539Z\",\"MediaKey\":\"NST121457155\"},{\"LongDescription\":\"23-web-or-mls-DSC00845 virtually staged.jpeg\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/99ab0eb5-2e81-4e13-a73f-bcbb0debd9d6.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.534Z\",\"MediaKey\":\"NST121457149\"},{\"LongDescription\":\"40-web-or-mls-DSC00894-1.JPG\",\"Order\":40,\"MediaObjectID\":\"NST40\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/5fc6b4ae-a538-4fa2-a805-f51bad34700d.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.568Z\",\"MediaKey\":\"NST121457132\"},{\"LongDescription\":\"43-web-or-mls-DSC00903.jpg\",\"Order\":43,\"MediaObjectID\":\"NST43\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/81a69839-5099-4849-8b17-ade980a6e80c.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.557Z\",\"MediaKey\":\"NST121457129\"},{\"LongDescription\":\"2-web-or-mls-DSC00906-1.JPG\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/51fe9e15-4f26-41e1-85dc-33645eb93ed8.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.612Z\",\"MediaKey\":\"NST121457170\"},{\"LongDescription\":\"37-web-or-mls-DSC00885-1.JPG\",\"Order\":37,\"MediaObjectID\":\"NST37\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/b611fb75-0a62-4e22-9693-1b3652a6266b.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.567Z\",\"MediaKey\":\"NST121457135\"},{\"LongDescription\":\"26-web-or-mls-DSC00851 virtually staged.jpeg\",\"Order\":26,\"MediaObjectID\":\"NST26\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/b396740e-9bbc-4e49-a2d1-ac48842a8c96.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.556Z\",\"MediaKey\":\"NST121457146\"},{\"LongDescription\":\"38-web-or-mls-DSC00888-1.JPG\",\"Order\":38,\"MediaObjectID\":\"NST38\",\"ResourceRecordKey\":\"NST7883487\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7883487/c8d3b834-8762-43b5-b57a-37fafb12e8c4.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-11T19:35:13.587Z\",\"MediaKey\":\"NST121457134\"}]","Media__LongDescription":"22-web-or-mls-DSC00845.jpg","Media__Order":"22","Media__MediaObjectID":"NST22","Media__ResourceRecordKey":"NST7883487","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7883487/10faa09c-9451-49d2-bca1-bafebfaa9e1b.jpeg","Media__ImageWidth":"2048","Media__ImageHeight":"1365","Media__ImageSizeDescription":"2048x1365","Media__MediaModificationTimestamp":"4/11/2026 7:35:13 PM","Media__MediaKey":"NST121457150","Rooms":"[{\"RoomDimensions\":\"13x13\",\"RoomKey\":\"NST116106045\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2},{\"RoomDimensions\":\"12x11\",\"RoomKey\":\"NST116106047\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":4},{\"RoomDimensions\":\"10x12\",\"RoomKey\":\"NST116106046\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3},{\"RoomDimensions\":\"14x14\",\"RoomKey\":\"NST116106044\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1},{\"RoomDimensions\":\"13x10\",\"RoomKey\":\"NST116106050\",\"RoomType\":\"Porch\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":7},{\"RoomDimensions\":\"13x10\",\"RoomKey\":\"NST116106048\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":5},{\"RoomDimensions\":\"11x7\",\"RoomKey\":\"NST116106049\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":6}]","Rooms__RoomDimensions":"13x13","Rooms__RoomKey":"NST116106045","Rooms__RoomType":"Dining Room","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"2","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1-web-or-mls-DSC00900-1.JPG\"},{\"Order\":2,\"Remarks\":\"2-web-or-mls-DSC00906-1.JPG\"},{\"Order\":3,\"Remarks\":\"3-web-or-mls-DSC00903_.jpg\"},{\"Order\":4,\"Remarks\":\"4-web-or-mls-DSC00797.jpg\"},{\"Order\":5,\"Remarks\":\"5-web-or-mls-DSC00800.jpg\"},{\"Order\":6,\"Remarks\":\"6-web-or-mls-DSC00803.jpg\"},{\"Order\":7,\"Remarks\":\"7-web-or-mls-DSC00803 virtually staged.jpeg\"},{\"Order\":8,\"Remarks\":\"8-web-or-mls-DSC00806.jpg\"},{\"Order\":9,\"Remarks\":\"9-web-or-mls-DSC00806 virtually staged.jpeg\"},{\"Order\":10,\"Remarks\":\"10-web-or-mls-DSC00809.jpg\"},{\"Order\":11,\"Remarks\":\"11-web-or-mls-DSC00812.jpg\"},{\"Order\":12,\"Remarks\":\"12-web-or-mls-DSC00815.jpg\"},{\"Order\":13,\"Remarks\":\"13-web-or-mls-DSC00818.jpg\"},{\"Order\":14,\"Remarks\":\"14-web-or-mls-DSC00821.jpg\"},{\"Order\":15,\"Remarks\":\"15-web-or-mls-DSC00824.jpg\"},{\"Order\":16,\"Remarks\":\"16-web-or-mls-DSC00827.jpg\"},{\"Order\":17,\"Remarks\":\"17-web-or-mls-DSC00830.jpg\"},{\"Order\":18,\"Remarks\":\"18-web-or-mls-DSC00833.jpg\"},{\"Order\":19,\"Remarks\":\"19-web-or-mls-DSC00836.jpg\"},{\"Order\":20,\"Remarks\":\"20-web-or-mls-DSC00839.jpg\"},{\"Order\":21,\"Remarks\":\"21-web-or-mls-DSC00842.jpg\"},{\"Order\":22,\"Remarks\":\"22-web-or-mls-DSC00845.jpg\"},{\"Order\":23,\"Remarks\":\"23-web-or-mls-DSC00845 virtually staged.jpeg\"},{\"Order\":24,\"Remarks\":\"24-web-or-mls-DSC00848.jpg\"},{\"Order\":25,\"Remarks\":\"25-web-or-mls-DSC00851.jpg\"},{\"Order\":26,\"Remarks\":\"26-web-or-mls-DSC00851 virtually staged.jpeg\"},{\"Order\":27,\"Remarks\":\"27-web-or-mls-DSC00854.jpg\"},{\"Order\":28,\"Remarks\":\"28-web-or-mls-DSC00857.jpg\"},{\"Order\":29,\"Remarks\":\"29-web-or-mls-DSC00860.jpg\"},{\"Order\":30,\"Remarks\":\"30-web-or-mls-DSC00863.jpg\"},{\"Order\":31,\"Remarks\":\"31-web-or-mls-DSC00866.jpg\"},{\"Order\":32,\"Remarks\":\"32-web-or-mls-DSC00869.jpg\"},{\"Order\":33,\"Remarks\":\"33-web-or-mls-DSC00873-1.JPG\"},{\"Order\":34,\"Remarks\":\"34-web-or-mls-DSC00875.jpg\"},{\"Order\":35,\"Remarks\":\"35-web-or-mls-DSC00878.jpg\"},{\"Order\":36,\"Remarks\":\"36-web-or-mls-DSC00882-1.JPG\"},{\"Order\":37,\"Remarks\":\"37-web-or-mls-DSC00885-1.JPG\"},{\"Order\":38,\"Remarks\":\"38-web-or-mls-DSC00888-1.JPG\"},{\"Order\":39,\"Remarks\":\"39-web-or-mls-DSC00891-1.JPG\"},{\"Order\":40,\"Remarks\":\"40-web-or-mls-DSC00894-1.JPG\"},{\"Order\":41,\"Remarks\":\"41-web-or-mls-DSC00897-1.JPG\"},{\"Order\":42,\"Remarks\":\"42-web-or-mls-DSC00903-1.JPG\"},{\"Order\":43,\"Remarks\":\"43-web-or-mls-DSC00903.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43","CustomVTourURL":""}
$MLSDESCRIPTION$
804 Hawthorne Avenue E Saint Paul, MN 55106
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
804 Hawthorne Avenue E Saint Paul, MN 55106
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$