404 Stanley Street, Saint Paul, MN 55118

New Listing
$520,000
Property Type: Residential Bedrooms: 4 Baths: 3 Square Footage: 2,602 Lot Size (sq. ft.): 13,068 Status: Active
Current Price: $520,000 List Date: 5/19/2026 Last Modified: 5/20/2026

Overview

Description

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.

Listing Details MLS# 7077427

General Property Information

Common Wall
No
Lot Measurement
Acres
Manufactured Home?
No
Multiple PIDs?
No
New Development
No
Waterfront Present
No
Year Built
1978
Yearly/Seasonal
Yearly
Zoning
Residential-Single Family
Bath Full
2
Bath Half
Yes
Main Floor Total SqFt
1848
Above Grd Total SqFt
1848
Below Grd Total SqFt
754
Total SqFt
2602
Total Finished Sqft
2602.00
FireplaceYN
No
Style
(SF) Single Family
Foundation Size
1848
Garage Stalls
2
Lot Dimensions
50 X 139
Acres
0.3
Assessment Pending
No
Number of Fireplaces
0
Bath Three Quarters
0
Bath Quarter
0
Association Fee
0

Property Features

Accessible: None Air Conditioning: Central Air Amenities Unit: Deck; Exercise Room; Hot Tub; Kitchen Window; Main Floor Primary Bedroom; Patio; Porch; Sun Room Appliances: Cooktop; Dryer; Microwave; Range; Refrigerator Assumable Loan: Not Assumable Basement: Egress Windows; Full Bath Description: Main Floor 1/2 Bath; Main Floor Full Bath; Full Basement Construction Status: Previously Owned Dining Room Description: Eat In Kitchen; Separate/Formal Dining Room Existing Financing: Conventional Exterior: Aluminum Siding Family Room Characteristics: Family Room; Main Level Fencing: Full Foundation: Brick/Mortar Fuel: Natural Gas Heating: Forced Air Laundry: Main Level Lock Box Type: Combo Pool Description: Heated Roof: Age Over 8 Years Sellers Terms: Cash; Conventional; FHA Sewer: City Sewer/Connected Special Search: 3 BR on One Level; All Living Facilities on One Level Stories: One Water: City Water/Connected

Contract Information

Contingency
None
Original List Price
520000
ListPrice
520000
Owner is an Agent?
No
Auction?
No

Location Tax and Other Information

House Number
404
Street Name
Stanley
Street Suffix
Street
Postal City
Saint Paul
County
Dakota
State
MN
Zip Code
55118
Complex/Dev/Subdivision
Koch & Kersts Add

Assessments

Tax With Assessments
5904
Assessment Balance
0

Building Information

Finished SqFt Above Ground
1848
Finished SqFt Below Ground
754

More Information

Lease Details

Land Leased
Not Applicable

Miscellaneous Information

Homestead
Yes

Ownership

Fractional Ownership
No

Parking Characteristics

Garage Square Feet
576

Public Survey Info

Range#
22
Section#
17
Township#
28

Office/Member Info

Association
SPAAR

Location, Tax and Other Information

AssocFeeYN
No
Legal Description
KOCH AND KERSTS ADDITION 2 6 LOT 1 BLK 6 & E 28 FT OF
Listing City
West Saint Paul
Map Page
122
Municipality
West Saint Paul
School District
West St. Paul-Mendota Hts.-Eagan
School District Phone
651-403-7002
Zip Plus 4
1663
Property ID Number
424280006021
Tax Year
2025
Tax Amount
5904
In Foreclosure?
No
Potential Short Sale?
No
Lender Owned?
No

Directions & Remarks

Public Remarks
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.
Directions
Hwy 52, exit Butler, west on Butler to Sperl, right on Sperl, Right on Stanley to home.

Accessible

None
Yes

Air Conditioning

Central Air
Yes

Amenities Unit

Deck
Yes
Exercise Room
Yes
Hot Tub
Yes
Kitchen Window
Yes
Main Floor Primary Bedroom
Yes
Patio
Yes
Porch
Yes
Sun Room
Yes

Appliances

Cooktop
Yes
Dryer
Yes
Microwave
Yes
Range
Yes
Refrigerator
Yes

Assumable Loan

Not Assumable
Yes

Basement

Egress Windows
Yes
Full
Yes

Bath Description

Main Floor 1/2 Bath
Yes
Main Floor Full Bath
Yes
Full Basement
Yes

Construction Status

Previously Owned
Yes

Dining Room Description

Eat In Kitchen
Yes
Separate/Formal Dining Room
Yes

Existing Financing

Conventional
Yes

Exterior

Aluminum Siding
Yes

Family Room Characteristics

Family Room
Yes
Main Level
Yes

Fencing

Full
Yes

Foundation

Brick/Mortar
Yes

Fuel

Natural Gas
Yes

Heating

Forced Air
Yes

Insurance Fee

Insurance Fee
0

Laundry

Main Level
Yes

Lock Box Type

Combo
Yes

Patio, Porch and Deck Features

Deck
Yes
Patio
Yes
Rear Porch
Yes
Screened
Yes

Pool Description

Heated
Yes

Roof

Age Over 8 Years
Yes

Sellers Terms

Cash
Yes
Conventional
Yes
FHA
Yes

Sewer

City Sewer/Connected
Yes

Special Search

3 BR on One Level
Yes
All Living Facilities on One Level
Yes

Stories

One
Yes

Water

City Water/Connected
Yes

Room Information

Room Name Level
Amusement Room Main
Amusement Room Basement
Bonus Room Main
Deck Main
Dining Room Main
First (1st) Bedroom Main
Four Season Porch Main
Fourth (4th) Bedroom Basement
Kitchen Main
Living Room Main
Patio Main
Second (2nd) Bedroom Main
Third (3rd) Bedroom Main
IDX
Listing Office: United Realty
Last Updated: May - 20 - 2026
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity SM Program of the Regional Multiple Listing Service of Minnesota, Inc. The information provided is deemed reliable but not guaranteed. Properties subject to prior sale, change or withdrawal. ©2024 Regional Multiple Listing Service of Minnesota, Inc All rights reserved.