404 Mississippi River Boulevard S, Saint Paul, MN 55105
$2,530,000
Property Type:
Residential
Bedrooms:
4
Baths:
4
Square Footage:
6,248
Lot Size (sq. ft.):
20,038
Status:
Closed
Current Price:
$2,530,000
List Date:
6/26/2023
Last Modified:
8/07/2025
Overview
Description
Listing Details MLS# 6309746
General Property Information
- Common Wall
- No
- Lot Measurement
- Acres
- Manufactured Home?
- No
- Multiple PIDs?
- No
- New Development
- No
- Number of Fireplaces
- 4
- Road Btwn WF & Home?
- Yes
- Year Built
- 2004
- Yearly/Seasonal
- Yearly
- Zoning
- Residential-Single Family
- Bath Full
- Yes
- Bath Three Quarters
- 3
- Main Floor Total SqFt
- 2219
- Above Grd Total SqFt
- 4029
- Below Grd Total SqFt
- 2219
- Total SqFt
- 6248
- Total Finished Sqft
- 5164.00
- FireplaceYN
- Yes
- Lake/Waterfront Name
- Mississippi River
- Style
- (SF) Single Family
- Foundation Size
- 2219
- Garage Stalls
- 3
- Lot Dimensions
- 100x200
- Acres
- 0.46
- # Carport Spaces
- 0
- Bath Half
- 0
- Bath Quarter
- 0
- Association Fee
- 0
Property Features
Accessible:
None
Air Conditioning:
Central Air
Amenities Unit:
Hardwood Floors; Hot Tub; In-Ground Sprinkler; Kitchen Center Island; Natural Woodwork; Panoramic View; Patio; Porch; Primary Bedroom Walk-In Closet; Security System; Walk-In Closet; Wet Bar
Appliances:
Dishwasher; Disposal; Dryer; Microwave; Range; Refrigerator; Washer
Basement:
Drain Tiled; Egress Windows; Full; Sump Pump
Bath Description:
Main Floor 3/4 Bath; Upper Level 3/4 Bath; Full Primary; Private Primary; 3/4 Basement; Jetted Tub; Separate Tub & Shower
Construction Status:
Previously Owned
Dining Room Description:
Breakfast Area; Eat In Kitchen; Kitchen/Dining Room; Separate/Formal Dining Room
Exterior:
Brick/Stone; Stucco
Family Room Characteristics:
Lower Level; Main Level
Fencing:
Full; Privacy; Wood
Financing Terms:
Cash
Fireplace Characteristics:
2-Sided; Gas Burning; Living Room; Primary Bedroom; Wood Burning
Fuel:
Natural Gas
Heating:
Forced Air
Laundry:
Main Level
Parking Characteristics:
Garage Door Opener; Heated Garage
Pool Description:
Below Ground; Heated
Road Frontage:
City Street; Curbs
Road Responsibility:
Public Maintained Road
Roof:
Age Over 8 Years; Asphalt Shingles
Sewer:
City Sewer/Connected
Special Search:
3 BR on One Level; Main Floor Laundry
Stories:
Two
Water:
City Water/Connected
Contract Information
- Off Market Date
- 2023-08-04
- Contingency
- None
- Closed Date
- 2023-08-15
- Original List Price
- 2750000
- Sales Close Price
- 2530000
- ListPrice
- 2750000
- Owner is an Agent?
- No
- Auction?
- No
Location Tax and Other Information
- House Number
- 404
- Street Name
- Mississippi River
- Street Suffix
- Boulevard
- Street Direction Suffix
- S
- Postal City
- Saint Paul
- County
- Ramsey
- State
- MN
- Zip Code
- 55105
Assessments
- Assessment Balance
- 162.42
- Tax With Assessments
- 34740
Building Information
- Finished SqFt Above Ground
- 4029
- Finished SqFt Below Ground
- 1135
More Information
Lease Details
- Land Leased
- Not Applicable
Miscellaneous Information
- Homestead
- No
Ownership
- Fractional Ownership
- No
Parking Characteristics
- Garage Square Feet
- 911
- Garage Door Opener
- Yes
- Heated Garage
- Yes
Office/Member Info
- Association
- MAAR
- MLSID
- RMLS
Location, Tax and Other Information
- AssocFeeYN
- No
- Legal Description
- LOTS 31 AND LOT 32 BLK 3
- Listing City
- Saint Paul
- Map Page
- 121
- Municipality
- Saint Paul
- Rental License?
- No
- School District
- St. Paul
- School District Phone
- 651-767-8100
- DNR Lake ID#
- S9990712
- DNR Lake Classification
- Not Applicable
- Lake Chain
- N
- Country
- US
- Property ID Number
- 082823130006
- Tax Year
- 2023
- Tax Amount
- 34578
- In Foreclosure?
- No
- Potential Short Sale?
- No
- Lender Owned?
- No
Directions & Remarks
- Public Remarks
- Amazing opportunity to own this recently updated home located on the bluffs of Mississippi River Blvd, with panoramic river views. Arguably the most desirable street in Saint Paul. Elevate your daily living with luxury finishes and the most incredible yard. Main level with a stunning, updated kitchen with large center island, high-end appliances and custom built-ins. Style meets function! There is also a large office, dining room, large foyer, and high ceilings. Three bedrooms up, including an unparalleled primary with 15x14 sitting room with 2-way fireplace and luxurious private bath. The lower level offers a guest bedroom, spacious living room, plus room for your pool table and home theater, as well as great storage spaces. There are 2 wet bars and 4 fireplaces, and the backyard of your dreams is complete with pool, spa and beautiful landscaping. Walk or bike the trails or go to the numerous restaurants and coffee shops nearby. Move in & enjoy!
- Directions
- Between Randolph and Jefferson on Mississippi River Blvd South
Accessible
- None
- Yes
Air Conditioning
- Central Air
- Yes
Amenities Unit
- Hardwood Floors
- Yes
- Hot Tub
- Yes
- In-Ground Sprinkler
- Yes
- Kitchen Center Island
- Yes
- Natural Woodwork
- Yes
- Panoramic View
- Yes
- Patio
- Yes
- Porch
- Yes
- Primary Bedroom Walk-In Closet
- Yes
- Security System
- Yes
- Walk-In Closet
- Yes
- Wet Bar
- Yes
Appliances
- Dishwasher
- Yes
- Disposal
- Yes
- Dryer
- Yes
- Microwave
- Yes
- Range
- Yes
- Refrigerator
- Yes
- Washer
- Yes
Basement
- Drain Tiled
- Yes
- Egress Windows
- Yes
- Full
- Yes
- Sump Pump
- Yes
Bath Description
- Main Floor 3/4 Bath
- Yes
- Upper Level 3/4 Bath
- Yes
- Full Primary
- Yes
- Private Primary
- Yes
- 3/4 Basement
- Yes
- Jetted Tub
- Yes
- Separate Tub & Shower
- Yes
Construction Status
- Previously Owned
- Yes
Dining Room Description
- Breakfast Area
- Yes
- Eat In Kitchen
- Yes
- Kitchen/Dining Room
- Yes
- Separate/Formal Dining Room
- Yes
Exterior
- Brick/Stone
- Yes
- Stucco
- Yes
Family Room Characteristics
- Lower Level
- Yes
- Main Level
- Yes
Fencing
- Full
- Yes
- Privacy
- Yes
- Wood
- Yes
Financing Terms
- Cash
- Yes
Fireplace Characteristics
- 2-Sided
- Yes
- Gas Burning
- Yes
- Living Room
- Yes
- Primary Bedroom
- Yes
- Wood Burning
- Yes
Fuel
- Natural Gas
- Yes
Heating
- Forced Air
- Yes
Insurance Fee
- Insurance Fee
- 0
Laundry
- Main Level
- Yes
Patio, Porch and Deck Features
- Front Porch
- Yes
- Patio
- Yes
- Rear Porch
- Yes
Pool Description
- Below Ground
- Yes
- Heated
- Yes
Road Frontage
- City Street
- Yes
- Curbs
- Yes
Road Responsibility
- Public Maintained Road
- Yes
Roof
- Age Over 8 Years
- Yes
- Asphalt Shingles
- Yes
Sewer
- City Sewer/Connected
- Yes
Special Search
- 3 BR on One Level
- Yes
- Main Floor Laundry
- Yes
Stories
- Two
- Yes
Water
- City Water/Connected
- Yes
Room Information
| Room Name | Dimensions | Level |
|---|---|---|
| Kitchen | 33x16 | Main |
| Dining Room | 16x11 | Main |
| Living Room | 27x16 | Main |
| First (1st) Bedroom | 17x14 | Upper |
| Foyer | 25x8 | Main |
| Office | 19x11 | Main |
| Second (2nd) Bedroom | 13x11 | Upper |
| Sitting Room | 15x14 | Upper |
| Fourth (4th) Bedroom | 15x11 | Lower |
| Third (3rd) Bedroom | 15x14 | Upper |
| Game Room | 25x15 | Lower |
| Family Room | 16x14 | Lower |
| Patio | 29x15 | Main |
| Porch | 12x12 | Main |
| Loft | 25x8 | Upper |
Listing Office:
Lakes Sotheby's International Realty
Last Updated: August - 07 - 2025
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.
