Save
Ask
Tour
Hide
Share
$1,200,000
55 Days On Site

175 Sherman Street 204
Saint Paul, MN55102

For Sale|Condominium|Pending
3
Beds
2
Total Baths
1
Full Bath
1
Partial Bath
2,638
SqFt
$455
/SqFt
2004
Built
Subdivision:
Cic 511 Riverfront Condo Upper Landi
County:
Ramsey
Listing courtesy of Coldwell Banker Realty
Call Now: 612.729.7130
Is this the listing for you? We can help make it yours.
612.729.7130
175 Sherman Street 204175 Sherman Street 204175 Sherman Street 204175 Sherman Street 204
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$5,475
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2025 Information is deemed reliable but not guaranteed.

One of the most graciously spectacular residences in Saint Paul, with walls of windows overlooking the tranquil Mississippi River, delightful gardens and verdant woodlands - captivatingly paired with the dynamic skyline as the backdrop. This exceptional condo beautifully blends: light-infused inviting interiors, harmonious scale, enduring design, custom finishes and picturesque vistas. Perfectly proportioned living spaces, warm wood tones with bespoke detailing, extensive built-ins, well-appointed open-concept kitchen and informal dining adjacent to welcoming family room with fireplace, ethereal primary retreat with spa-inspired bathroom and customized walk-in closet, expansive art walls, spacious secondary bedrooms (one currently used as office with streamlined built-ins), unique hand-painted bathroom mural, laundry room with work area, abundant storage, private two-car doored garage within the building, and two magnificent outdoor living areas - a breathtaking river facing balcony and calming three-season sunroom off kitchen. A one-of-kind home with matching location, unforgettable views, memorable experiences and unrivaled walkability - the ultimate Zen-like urban sanctuary. Enjoy all things Saint Paul - lovely walking/biking trails, lush parks, restaurants, shopping, artist studios, farmers market, sporting events, theatre and much more.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,200,000
Days On Site 
55 Days
Bedrooms 
3
Inside Area (SqFt) 
2,638 sqft
Total Baths 
2
Full Baths 
1
Partial Baths 
1
Lot Size 
N/A
Year Built 
2004
MLS® Number 
6781976
Status 
Pending
Property Tax 
$20,603
HOA/Condo/Coop Fees 
$769 monthly
Sq Ft Source 
N/A
Friends & Family
Recent Activity
a month agoListing updated with changes from the MLS®
a month agoStatus changed to Pending
2 months agoListing first seen on site
General Features
Garage 
Yes
Garage Spaces 
2
Land Lease 
No
Parking 
Garage Door OpenerHeated GarageSecuredUnderground
Property Sub Type 
Condominium
Sewer 
Public Sewer
SqFt Above 
2638
SqFt Total 
2748
Water Source 
Public
Zoning 
Residential-Single Family
Interior Features
Appliances 
OvenCooktopDishwasherDryerMicrowaveRefrigeratorStainless Steel Appliance(s)WasherWine Cooler
Basement 
None
Cooling 
Ceiling Fan(s)Central Air
Fireplace 
Yes
Fireplace Features 
GasStone
Fireplaces 
1
Flooring 
Hardwood
Heating 
Natural GasForced Air
Interior 
ElevatorKitchen IslandWalk-In Closet(s)
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Brick
Patio And Porch 
Deck
View 
CityRiverCity LightsPanoramic
Waterfront Features 
Mississippi River
Waterview 
CityRiverCity LightsPanoramic
Community Features
Accessibility Features 
Accessible Elevator Installed
Association Amenities 
Elevator(s)Security
Association Dues 
769
HOA Fee Frequency 
Monthly
Roads 
Paved
School District 
St. Paul
Schools
School District
St. Paul
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Coldwell Banker Realty



Listing information is provided by Participants of the Northstar MLS. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Copyright 2025, Northstar MLS.
Last checked: 2025-10-30 07:21 PM UTC

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share