{"Id":568227,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7087752","MLSAGENTID":"NST506069195","MLSOFFICEID":"NST10044","ADDRESS":"404 Stanley Street","ACRES":0.3,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":3.0,"BEDROOMS":4.0,"CITY":"West Saint Paul","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":499000.0,"LASTPRICEDATE":"2026-06-05T16:27:08.68","LATITUDE":44.912999,"LENDEROWNED":"No","LISTDATE":"2026-06-05T05:00:00","LISTPRICE":499000.0,"LIVINGAREA":2602.0,"LONGITUDE":-93.068042,"MODIFICATIONTIMESTAMP":"2026-06-05T16:39:07.569","OFFICE_OFFICENAME":"United Realty","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":13,"POSTALCODE":"55118","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to the perfect blend of comfort, convenience, and resort-style living. This incredible home offers easy one-level living with everything you need on the main floor, including three bedrooms, an eat-in kitchen, formal dining room, cozy family room, and an additional bonus space perfect for a home office, playroom, or flex room. But the true showstopper is the breathtaking outdoor oasis. Step outside to your own private retreat featuring a full-size sport court designed for pickleball, racquetball, volleyball, and basketball, alongside a stunning in-ground pool surrounded by an expansive patio ideal for entertaining. A generous deck, screened-in porch, and oversized hot tub overlooking the backyard create the ultimate setting for relaxing summer nights or hosting unforgettable gatherings. This is more than a home, it’s a lifestyle. You truly have to see it to believe it.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"197-West St. Paul-Mendota Hts.-Eagan","SCHOOLDISTRICTPHONE":"6514037002","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-05T16:27:08.68","LASTSTATUS":"Active","STREETNAME":"Stanley","STREETNUMBER":"404","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1978,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-05T16:39:07.569","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"image000000.heic (5).jpg\"},{\"Order\":2,\"Remarks\":\"image000000.heic.jpg\"},{\"Order\":3,\"Remarks\":\"image000000.heic (4).jpg\"},{\"Order\":4,\"Remarks\":\"10dbb0c1-5e11-4541-986f-fb02451766fe~1.jpg\"},{\"Order\":5,\"Remarks\":\"27d43591-07ff-4a57-a8fa-2875b2752866~1.jpg\"},{\"Order\":6,\"Remarks\":\"8e1c4791-a2ca-44ef-bcb1-451785d9d23d~1.jpg\"},{\"Order\":7,\"Remarks\":\"e08d50a4-63a2-44e2-ba2e-699c26b25c22~1.jpg\"},{\"Order\":8,\"Remarks\":\"353fd658-f08f-46d5-8018-9a0998dbd993~1.jpg\"},{\"Order\":9,\"Remarks\":\"20260419_141536.jpg\"},{\"Order\":10,\"Remarks\":\"fbac7740-e94a-4714-94fa-209af455bcb8~1.jpg\"},{\"Order\":11,\"Remarks\":\"image000000.heic (1).jpg\"},{\"Order\":12,\"Remarks\":\"image000000.heic (2).jpg\"},{\"Order\":13,\"Remarks\":\"image000000.heic (3).jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13","SOURCE":"MG_NST"}
{"ListingKey":"NST7913633","NST_AboveGradeSqFtTotal":"2602","AboveGradeFinishedArea":"1848","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Cooktop,Dryer,Microwave,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","AssociationFeeFrequency":"N/A","Basement":"Finished","BasementYN":"True","NST_BathDesc":"Full Basement,Main Floor 1/2 Bath,Main Floor Full Bath","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"754","BelowGradeFinishedArea":"754","CumulativeDaysOnMarket":"4","City":"West Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Dakota","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"Hwy 52, exit Butler, west on Butler to Sperl, right on Sperl, Right on Stanley to home.","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Aluminum Siding","Fencing":"Full","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"148","FoundationDetails":"Combination","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"576","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"West St. Paul-Mendota Hts.-Eagan","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.912999","LaundryFeatures":"Lower Level,Main Level","NST_LenderOwned":"No","Levels":"One","ListPrice":"499000","ListingContractDate":"2026-06-05T05:00:00Z","ListingId":"NST7087752","LivingArea":"2602","LockBoxType":"Combo","Longitude":"-93.068042","LotSizeArea":"0.3","LotSizeDimensions":"50 X 139","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1848","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-06-05T11:25:04Z","OtherStructures":"Storage Shed","ParcelNumber":"424280006021","ParkingFeatures":"Attached Garage","NST_PatioPorchType":"Deck,Patio,Screened","PhotosCount":"13","PhotosChangeTimestamp":"2026-06-05T16:39:07.569Z","PoolFeatures":"Heated,Outdoor","PostalCity":"Saint Paul","PostalCode":"55118","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Welcome to the perfect blend of comfort, convenience, and resort-style living. This incredible home offers easy one-level living with everything you need on the main floor, including three bedrooms, an eat-in kitchen, formal dining room, cozy family room, and an additional bonus space perfect for a home office, playroom, or flex room. But the true showstopper is the breathtaking outdoor oasis. Step outside to your own private retreat featuring a full-size sport court designed for pickleball, racquetball, volleyball, and basketball, alongside a stunning in-ground pool surrounded by an expansive patio ideal for entertaining. A generous deck, screened-in porch, and oversized hot tub overlooking the backyard create the ultimate setting for relaxing summer nights or hosting unforgettable gatherings. This is more than a home, it’s a lifestyle. You truly have to see it to believe it.","PublicSurveyRange":"22","PublicSurveySection":"17","PublicSurveyTownship":"28","NST_SchoolDistrictFullName":"197 - West St. Paul-Mendota Hts.-Eagan","NST_SchoolDistrictNumber":"197","NST_SchoolDistrictPhone":"6514037002","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Stanley","StreetNumber":"404","StreetNumberNumeric":"404","StreetSuffix":"Street","SubdivisionName":"Koch & Kersts Add","TaxAnnualAmount":"5904","NST_TaxWithAssessments":"5904","TaxYear":"2025","NST_TotalArea":"3356","BuildingAreaTotal":"3356","Township":"West Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1978","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST47577","ListAgentMlsId":"NST506069195","ListOfficeMlsId":"NST10044","ListOfficeName":"United Realty","ListOfficeKey":"NST15578","ModificationTimestamp":"2026-06-05T16:39:07.569Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"image000000.heic.jpg\",\"ResourceRecordKey\":\"NST7913633\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7913633/c773126f-251e-44f4-8125-d4e128f48c0d.jpeg\",\"ImageWidth\":720,\"ImageHeight\":960,\"ImageSizeDescription\":\"720x960\",\"MediaModificationTimestamp\":\"2026-06-05T16:38:12.515Z\",\"MediaKey\":\"NST122756138\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"image000000.heic (2).jpg\",\"ResourceRecordKey\":\"NST7913633\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7913633/3897c93c-ddf5-4bd3-93a2-1ecdda788f77.jpeg\",\"ImageWidth\":1135,\"ImageHeight\":1514,\"ImageSizeDescription\":\"1135x1514\",\"MediaModificationTimestamp\":\"2026-06-05T16:38:12.536Z\",\"MediaKey\":\"NST122756142\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"image000000.heic (4).jpg\",\"ResourceRecordKey\":\"NST7913633\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7913633/d2b95730-64c4-4ec3-a961-15411425a8aa.jpeg\",\"ImageWidth\":1269,\"ImageHeight\":1692,\"ImageSizeDescription\":\"1269x1692\",\"MediaModificationTimestamp\":\"2026-06-05T16:38:12.509Z\",\"MediaKey\":\"NST122756140\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"image000000.heic (1).jpg\",\"ResourceRecordKey\":\"NST7913633\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7913633/cebe0cfe-bfaf-42b7-8ebb-6eb945683d0d.jpeg\",\"ImageWidth\":1559,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1559x2080\",\"MediaModificationTimestamp\":\"2026-06-05T16:38:12.539Z\",\"MediaKey\":\"NST122756143\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"e08d50a4-63a2-44e2-ba2e-699c26b25c22~1.jpg\",\"ResourceRecordKey\":\"NST7913633\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7913633/8dab9586-e5e3-4389-bdba-6197ddeae4b8.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-05T16:38:12.551Z\",\"MediaKey\":\"NST122756145\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"image000000.heic (3).jpg\",\"ResourceRecordKey\":\"NST7913633\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7913633/c275a52c-785c-4f2f-bd8a-dcc58ad2b3d3.jpeg\",\"ImageWidth\":1371,\"ImageHeight\":1828,\"ImageSizeDescription\":\"1371x1828\",\"MediaModificationTimestamp\":\"2026-06-05T16:38:12.554Z\",\"MediaKey\":\"NST122756141\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"27d43591-07ff-4a57-a8fa-2875b2752866~1.jpg\",\"ResourceRecordKey\":\"NST7913633\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7913633/ff44f8f5-0399-40dc-a1bf-2a4f7e39f78a.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-05T16:38:12.536Z\",\"MediaKey\":\"NST122756148\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"fbac7740-e94a-4714-94fa-209af455bcb8~1.jpg\",\"ResourceRecordKey\":\"NST7913633\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7913633/5e8d96a9-db3d-4828-9e84-d7b506b4f0b1.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-05T16:38:12.565Z\",\"MediaKey\":\"NST122756144\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"20260419_141536.jpg\",\"ResourceRecordKey\":\"NST7913633\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7913633/19ea03f0-0069-43ab-a3a3-e020b6a866e9.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-05T16:38:12.497Z\",\"MediaKey\":\"NST122756146\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"image000000.heic (5).jpg\",\"ResourceRecordKey\":\"NST7913633\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7913633/048697eb-c9d5-4322-a3e5-38b3e6389d2c.jpeg\",\"ImageWidth\":1559,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1559x2080\",\"MediaModificationTimestamp\":\"2026-06-05T16:38:12.534Z\",\"MediaKey\":\"NST122756139\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"8e1c4791-a2ca-44ef-bcb1-451785d9d23d~1.jpg\",\"ResourceRecordKey\":\"NST7913633\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7913633/ee2d97d7-eef8-42d6-82b6-b116a5abfb2e.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-05T16:38:12.593Z\",\"MediaKey\":\"NST122756150\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"353fd658-f08f-46d5-8018-9a0998dbd993~1.jpg\",\"ResourceRecordKey\":\"NST7913633\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7913633/a8e59aae-2bbc-4798-b007-304149da4634.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-05T16:38:12.594Z\",\"MediaKey\":\"NST122756147\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"10dbb0c1-5e11-4541-986f-fb02451766fe~1.jpg\",\"ResourceRecordKey\":\"NST7913633\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7913633/56ac5b15-af2c-49cf-aba6-2d54c742a4bd.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-05T16:38:12.639Z\",\"MediaKey\":\"NST122756149\"}]","Media__Order":"2","Media__MediaObjectID":"NST2","Media__LongDescription":"image000000.heic.jpg","Media__ResourceRecordKey":"NST7913633","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7913633/c773126f-251e-44f4-8125-d4e128f48c0d.jpeg","Media__ImageWidth":"720","Media__ImageHeight":"960","Media__ImageSizeDescription":"720x960","Media__MediaModificationTimestamp":"6/5/2026 4:38:12 PM","Media__MediaKey":"NST122756138","DocumentsChangeTimestamp":"2026-06-05T16:26:09.48Z","Rooms":"[{\"NST_RoomSortOrder\":15,\"RoomKey\":\"NST116320366\",\"RoomType\":\"Three Season Porch\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":9,\"RoomKey\":\"NST116320360\",\"RoomType\":\"Athletic Court\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":10,\"RoomKey\":\"NST116320361\",\"RoomType\":\"Deck\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116320353\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":11,\"RoomKey\":\"NST116320362\",\"RoomType\":\"Exercise Room\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116320354\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\"},{\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116320356\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116320359\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\"},{\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116320355\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":12,\"RoomKey\":\"NST116320363\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":13,\"RoomKey\":\"NST116320364\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Lower\"},{\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116320352\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":14,\"RoomKey\":\"NST116320365\",\"RoomType\":\"Patio\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116320357\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116320358\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\"}]","Rooms__NST_RoomSortOrder":"15","Rooms__RoomKey":"NST116320366","Rooms__RoomType":"Three Season Porch","Rooms__RoomLevel":"Main","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"image000000.heic (5).jpg\"},{\"Order\":2,\"Remarks\":\"image000000.heic.jpg\"},{\"Order\":3,\"Remarks\":\"image000000.heic (4).jpg\"},{\"Order\":4,\"Remarks\":\"10dbb0c1-5e11-4541-986f-fb02451766fe~1.jpg\"},{\"Order\":5,\"Remarks\":\"27d43591-07ff-4a57-a8fa-2875b2752866~1.jpg\"},{\"Order\":6,\"Remarks\":\"8e1c4791-a2ca-44ef-bcb1-451785d9d23d~1.jpg\"},{\"Order\":7,\"Remarks\":\"e08d50a4-63a2-44e2-ba2e-699c26b25c22~1.jpg\"},{\"Order\":8,\"Remarks\":\"353fd658-f08f-46d5-8018-9a0998dbd993~1.jpg\"},{\"Order\":9,\"Remarks\":\"20260419_141536.jpg\"},{\"Order\":10,\"Remarks\":\"fbac7740-e94a-4714-94fa-209af455bcb8~1.jpg\"},{\"Order\":11,\"Remarks\":\"image000000.heic (1).jpg\"},{\"Order\":12,\"Remarks\":\"image000000.heic (2).jpg\"},{\"Order\":13,\"Remarks\":\"image000000.heic (3).jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13","CustomVTourURL":""}