MLS# 7087752
404 Stanley Street West Saint Paul, MN 55118
United Realty is the brokerage office representing the seller for this listing.
Copyright 2026, 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. Jim Christensen is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Jim Christensen, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
$LABEL$
$CONTENT$
$DESC$
{"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":""}
