{"Id":574007,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7070930","MLSAGENTID":"NST502048451","MLSOFFICEID":"NST3075","ADDRESS":"589 Lexington Parkway N","ACRES":0.06,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":190000.0,"LASTPRICEDATE":"2026-06-17T18:58:07.827","LATITUDE":44.959013,"LENDEROWNED":"No","LISTDATE":"2026-06-17T05:00:00","LISTPRICE":190000.0,"LIVINGAREA":1332.0,"LONGITUDE":-93.146998,"MODIFICATIONTIMESTAMP":"2026-06-18T09:17:11.721","NEIGHBORHOOD":"93","OFFICE_OFFICENAME":"Edina Realty, Inc.","PHOTOCOUNT":10,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Priced to reflect needed updates and being sold AS-IS.\n\nWhether you're searching for you next renovation project or an affordable home with the opportunity to build equity over time, this property offers exceptional potential.\nClassic 3-bedroom, 1-bath Dutch Colonial with loads of opportunity. Perfect for investors, renovators, or buyers looking to build equity, this home offers solid structure, original charm, and endless potential for customization.\nAn upstairs bathroom remodel has been initiated but not completed, providing a ready-made canvas for finishing touches. An additional toilet and shower are in the basement and an attached 1-car garage adds everyday convenience.\nIdeally situated near light rail, public transit, shopping, dining and major freeway access, this property delivers strong connectivity along with compelling, long-term appreciation potential.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-18T05:02:12.66","LASTSTATUS":"Coming Soon","STREETDIRSUFFIX":"N","STREETNAME":"Lexington","STREETNUMBER":"589","STREETSUFFIX":"Parkway","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1922,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-17T20:59:10.321","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"589 Lexington Pkwy N\"},{\"Order\":2,\"Remarks\":\"Kitchen\"},{\"Order\":3,\"Remarks\":\"Dining Room\"},{\"Order\":4,\"Remarks\":\"Charming Staircase\"},{\"Order\":5,\"Remarks\":\"Living Room Fireplace\"},{\"Order\":6,\"Remarks\":\"589 Lexington Pkwy N\"},{\"Order\":7,\"Remarks\":\"Main Floor\"},{\"Order\":8,\"Remarks\":\"2nd Floor\"},{\"Order\":9,\"Remarks\":\"Basement\"},{\"Order\":10,\"Remarks\":\"Floorplans\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10","SOURCE":"MG_NST"}
{"ListingKey":"NST7898953","NST_AboveGradeSqFtTotal":"1332","AboveGradeFinishedArea":"1332","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"Go north on Lexington Pkwy. After Edmund Ave W, home is on left side.","DocumentsCount":"0","DaysOnMarket":"0","NST_ExpectedMarketDate":"2026-06-18","ExteriorFeatures":"Wood","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"667","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"286","NST_GarageDimensions":"9x30","GarageSpaces":"1","Heating":"Hot Water","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.959013","NST_LenderOwned":"No","Levels":"Two","ListPrice":"190000","ListingContractDate":"2026-06-17T05:00:00Z","ListingId":"NST7070930","LivingArea":"1332","LockBoxType":"Supra","Longitude":"-93.146998","LotSizeArea":"0.06","LotSizeDimensions":"61x40","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"665","NST_ManufacturedHome":"N","NST_NeighborhoodName":"Hamline-Midway","NST_NeighborhoodNumber":"93","OriginalEntryTimestamp":"2026-06-18T00:00:12Z","ParcelNumber":"342923140002","ParkingFeatures":"Attached Garage","PhotosCount":"10","PhotosChangeTimestamp":"2026-06-17T20:59:10.321Z","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Priced to reflect needed updates and being sold AS-IS.\n\nWhether you're searching for you next renovation project or an affordable home with the opportunity to build equity over time, this property offers exceptional potential.\nClassic 3-bedroom, 1-bath Dutch Colonial with loads of opportunity. Perfect for investors, renovators, or buyers looking to build equity, this home offers solid structure, original charm, and endless potential for customization.\nAn upstairs bathroom remodel has been initiated but not completed, providing a ready-made canvas for finishing touches. An additional toilet and shower are in the basement and an attached 1-car garage adds everyday convenience.\nIdeally situated near light rail, public transit, shopping, dining and major freeway access, this property delivers strong connectivity along with compelling, long-term appreciation potential.","PublicSurveyRange":"23","PublicSurveySection":"34","PublicSurveyTownship":"29","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Lexington","StreetNumber":"589","StreetNumberNumeric":"589","StreetSuffix":"Parkway","SubdivisionName":"Sanborns Midway Addition, To S","TaxAnnualAmount":"4414","NST_TaxWithAssessments":"4414","TaxYear":"2026","NST_TotalArea":"1332","BuildingAreaTotal":"1332","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1922","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST112361","ListAgentMlsId":"NST502048451","ListOfficeMlsId":"NST3075","ListOfficeName":"Edina Realty, Inc.","ListOfficeKey":"NST16488","ModificationTimestamp":"2026-06-18T09:17:11.721Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"Basement\",\"ResourceRecordKey\":\"NST7898953\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7898953/deee3cf4-988a-4c82-bde6-d1f103d4cb5b.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-17T20:53:11.003Z\",\"MediaKey\":\"NST123028154\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"Floorplans\",\"ResourceRecordKey\":\"NST7898953\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7898953/1bff999d-9dd6-4c70-b284-b11b791416e7.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-17T20:53:11.015Z\",\"MediaKey\":\"NST123028152\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"Main Floor\",\"ResourceRecordKey\":\"NST7898953\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7898953/dabf5508-5536-4614-ab78-52d14cc252bc.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-17T20:58:12.962Z\",\"MediaKey\":\"NST123028153\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"Charming Staircase\",\"ResourceRecordKey\":\"NST7898953\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7898953/b1a381fb-27c4-4c5f-bc2f-9a37854c1ed3.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-17T20:19:13.041Z\",\"MediaKey\":\"NST123034993\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"Kitchen\",\"ResourceRecordKey\":\"NST7898953\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7898953/53d3f374-b895-4d24-b2ad-282cf6d92f36.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-06-17T16:21:12.587Z\",\"MediaKey\":\"NST123021946\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"589 Lexington Pkwy N\",\"ResourceRecordKey\":\"NST7898953\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7898953/4de296f6-1f49-4705-ab52-195dcf97822f.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-17T20:53:11.093Z\",\"MediaKey\":\"NST123021950\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"589 Lexington Pkwy N\",\"ResourceRecordKey\":\"NST7898953\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7898953/5a9e857e-e750-47f4-bd1d-005116e8f177.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-17T20:57:09.024Z\",\"MediaKey\":\"NST123021856\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"2nd Floor\",\"ResourceRecordKey\":\"NST7898953\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7898953/97f9deb4-b6a4-485a-879a-0bd7cfd0bec5.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-17T20:58:12.825Z\",\"MediaKey\":\"NST123028151\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"Dining Room\",\"ResourceRecordKey\":\"NST7898953\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7898953/45a7ead0-b215-442c-9f8e-8addb18c424c.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-17T20:57:09.018Z\",\"MediaKey\":\"NST123021947\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"Living Room Fireplace\",\"ResourceRecordKey\":\"NST7898953\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7898953/253572c8-48c7-4f0d-ae0a-a0f55c047671.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-17T20:53:11.037Z\",\"MediaKey\":\"NST123036303\"}]","Media__Order":"9","Media__MediaObjectID":"NST9","Media__LongDescription":"Basement","Media__ResourceRecordKey":"NST7898953","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7898953/deee3cf4-988a-4c82-bde6-d1f103d4cb5b.jpeg","Media__ImageWidth":"2080","Media__ImageHeight":"1560","Media__ImageSizeDescription":"2080x1560","Media__MediaModificationTimestamp":"6/17/2026 8:53:11 PM","Media__MediaKey":"NST123028154","DocumentsChangeTimestamp":"2026-06-17T18:58:07.828Z","Rooms":"[{\"RoomKey\":\"NST116366707\",\"RoomDimensions\":\"8x6\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST116366702\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116366704\",\"RoomDimensions\":\"11x23\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST116366703\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116366701\",\"RoomDimensions\":\"15x23\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116366705\",\"RoomDimensions\":\"11x8\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST116366706\",\"RoomDimensions\":\"8x7\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\"}]","Rooms__RoomKey":"NST116366707","Rooms__RoomDimensions":"8x6","Rooms__NST_RoomSortOrder":"7","Rooms__RoomType":"Bathroom","Rooms__RoomLevel":"Upper","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"589 Lexington Pkwy N\"},{\"Order\":2,\"Remarks\":\"Kitchen\"},{\"Order\":3,\"Remarks\":\"Dining Room\"},{\"Order\":4,\"Remarks\":\"Charming Staircase\"},{\"Order\":5,\"Remarks\":\"Living Room Fireplace\"},{\"Order\":6,\"Remarks\":\"589 Lexington Pkwy N\"},{\"Order\":7,\"Remarks\":\"Main Floor\"},{\"Order\":8,\"Remarks\":\"2nd Floor\"},{\"Order\":9,\"Remarks\":\"Basement\"},{\"Order\":10,\"Remarks\":\"Floorplans\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10","CustomVTourURL":""}