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

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!

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
Waterfront Present
No
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

Lake/Waterfront

River View
Yes

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

Kitchen Dimensions: 33x16 Level: Main Dining Room Dimensions: 16x11 Level: Main Living Room Dimensions: 27x16 Level: Main First (1st) Bedroom Dimensions: 17x14 Level: Upper Foyer Dimensions: 25x8 Level: Main Office Dimensions: 19x11 Level: Main Second (2nd) Bedroom Dimensions: 13x11 Level: Upper Sitting Room Dimensions: 15x14 Level: Upper Fourth (4th) Bedroom Dimensions: 15x11 Level: Lower Third (3rd) Bedroom Dimensions: 15x14 Level: Upper Game Room Dimensions: 25x15 Level: Lower Family Room Dimensions: 16x14 Level: Lower Patio Dimensions: 29x15 Level: Main Porch Dimensions: 12x12 Level: Main Loft Dimensions: 25x8 Level: Upper
Listing Office: Lakes Sotheby's International Realty
IDX
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.