175 Sherman Street Unit 204, Saint Paul, MN 55102

$1,100,000
3
BD
2
BA
2,638
SqFt

Show Photos

Verify your account to unlock exclusive photos, mortgage tools, and more.

Sold Price
$1,100,000
List Price
$1,200,000
Closing Date
Dec 05, 2025
MLS#
6781976
Status
CLOSED
Type
Condo
Style
(CC) Low Rise (3- Levels)
Bedrooms
3
Bathrooms
2
Living Area
2,638
Subdivision
Cic 511 Riverfront Condo Upper Landi
Neighborhood
103
Year Built
2004

Property Description

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.

Additional Information

School District
St. Paul
Amenities Shared
Elevator(s), Fire Sprinkler System, In-Ground Sprinkler System, Security Building
Amenities Unit
Ceiling Fan(s), Deck, Hardwood Floors, Kitchen Center Island, Primary Bedroom Walk-In Closet, Main Floor Primary Bedroom, Sun Room, Tile Floors, Washer/Dryer Hookup, Walk-In Closet
Appliances
Cooktop, Dishwasher, Dryer, Microwave, Refrigerator, Stainless Steel Appliances, Wall Oven, Washer, Wine Cooler
Tax Year
2025
Waterfront Features
River View
Fuel
Natural Gas
Water Body Name
Mississippi River
Sewer
City Sewer/Connected
Common Wall
Yes
Air Conditioning
Central Air
Heating
Forced Air
Water
City Water/Connected
Basement
None
Parking
Garage Door Opener, Heated Garage, Insulated Garage, Secured, Underground
Garage Spaces
2

How much is your home worth?

...get instant property value now!

Mortgage Calculator

Amount of Loan
Annual Interest Rate
%
Term of Loan
Years

Does not include any taxes or fees.
Please consult a financial professional.
Calculator source: Real Geeks

Listing courtesy of Coldwell Banker Realty - Lakes.

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the Regional Multiple Listing Service of Minnesota. Real estate listings held by brokerage firms other this firm are marked with the Broker Reciprocity logo. Information Deemed Reliable But Not Guaranteed. Property locations as displayed on any map are best approximations only and exact locations should be independently verified.

Listing data © 2026 Regional Multiple Listing Service of Minnesota. All rights reserved. By searching, you agree to the EULA.