175 Sherman Street, #204 Saint Paul, MN 55102

$1,200,000
Pending
estimated monthly payment
3 Beds  |  2 Baths  |  2,638 Sq Ft  |  Low Rise 3- Level  |  MLS # 6781976
estimated monthly payment Pending
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 1
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 2
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 3
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 4
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 5
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 6
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 7
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 8
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 9
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 10
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 11
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 12
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 13
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 14
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 15
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 16
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 17
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 18
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 19
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 20
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 21
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 22
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 23
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 24
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 25
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 26
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 27
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 28
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 29
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 30
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 31
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 32
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 33
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 34
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 35
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 36
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 37
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 38
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 39
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 40
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 41
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 42
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 43
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 44
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 45
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 46
  • 175 Sherman Street, #204, Saint Paul, MN 55102 Listing Photo 47
RATE THIS PROPERTY

Showing
Rate
Get Directions

About The Listing

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.


Listing courtesy of Scott J. Acker, Coldwell Banker Realty

Mortgage Calculator

estimated
monthly payment
Calculation includes only common costs associated with home ownership. Estimates based on local averages and assumptions that may not apply to you and are provided for informational purposes only.
Purchase Price
Loan Type
Down Payment
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
HOA Dues
Private Mortgage Insurance
Ask a Question
Your message has been sent.
Oops! that doesn't seem right.
SEND
Sign Up for a Free Monthly Market Report
Never miss out on the latest stats trends and homes in your community.
Get It Now

Property Details

Features

 
 
 
Property Type: Single Family
Status: Pending
Contingency Type: None
Year Built: 2004
MLS #: 6781976
Bedrooms: 3
Square Feet: 2,638
Bathrooms (Full): 1
Price Per Square Foot: $455
Bathrooms (Half) : 0
Bathrooms (Three Quarters) : 1
Garage Spaces: 2
Parking Description: Garage Door Opener, Heated Garage, Insulated Garage, Secured, Underground
Sewer Description: City Sewer/Connected
Air Conditioning Type: Central Air
Water: City Water/Connected
Heat Type: Forced Air
Basement: None
Construction Description: Brick/Stone
Days On Market (Continuous): 19
Disability Features: Accessible Elevator Installed
Latest Update: 09/25/2025
List Date: 09/06/2025
Listing Agent ID: 502014924
Listing Office: Coldwell Banker Realty
Listing Office ID: 5116
Data Source: NorthstarMLS - The Regional MLS of Minnesota
Appliances: Cooktop, Dishwasher, Dryer, Microwave, Refrigerator, Stainless Steel Appliances, Wall Oven, Washer, Wine Cooler
Fireplace Features: Gas, Stone
Number of Fireplaces: 1
Lot Size: 0.0 Acres
View Description: City Lights, Panoramic, River, South
Waterfront: River View
School District: St. Paul
Tax Year: 2025
HOA: Cedar Management
Estimated Taxes: $20,603
HOA Fee: 769.0
Contingency Type: None
HOA Frequency: Monthly
HOA Fee Inclusions: Hazard Insurance, Lawn Care, Maintenance Grounds, Professional Mgmt, Trash, Sewer, Snow Removal
HOA Requirment: 1
City: Saint Paul
Zip: 55102
County: Ramsey
Subdivision: Cic 511 Riverfront Condo Upper Landi
State: MN

Similar Homes

545 Holly Avenue, Saint Paul, MN 55102 Listing Photo 1
RATE THIS PROPERTY
$1,195,000
  
545 Holly Avenue
Saint Paul, MN 55102
4 BD
4 BTH
3,193 Sqft
Listing courtesy of Brandon Michael Foster, Pemberton RE
$1,195,000
Rate This Home
Contact the Agent
545 Holly Avenue, Saint Paul, MN  55102
4 BD 4 BTH 3,193 Sqft
Listing courtesy of Brandon Michael Foster, Pemberton RE
$1,195,000
545 Holly Avenue, Saint Paul, MN  55102
4 BD 4 BTH 3,193 Sqft
Listing courtesy of Brandon Michael Foster, Pemberton RE
RATE THIS PROPERTY
$1,195,000
545 Holly Avenue, Saint Paul, MN  55102
4 BD 4 BTH 3,193 Sqft
Listing courtesy of Brandon Michael Foster, Pemberton RE
1 - Exterior Front.jpg
RATE THIS PROPERTY
$995,000
  
518 Laurel Avenue
Saint Paul, MN 55102
2,820 Sqft
Listing courtesy of Christopher J Ames, RE/MAX Results
$995,000
Rate This Home
Contact the Agent
518 Laurel Avenue, Saint Paul, MN  55102
2,820 Sqft
Listing courtesy of Christopher J Ames, RE/MAX Results
$995,000
518 Laurel Avenue, Saint Paul, MN  55102
2,820 Sqft
Listing courtesy of Christopher J Ames, RE/MAX Results
RATE THIS PROPERTY
$995,000
518 Laurel Avenue, Saint Paul, MN  55102
2,820 Sqft
Listing courtesy of Christopher J Ames, RE/MAX Results
Listing last updated: 09/25/25

® Copyright 2025 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved. 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, Inc. Real estate listings held by brokerage firms other than the owner of this website are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo and detailed information about them includes the name of the listing brokers. Digital Millennium Copyright Act (DMCA) Notice The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to Michael Bisping, Director, Customer Relations, Regional Multiple Listing Service of Minnesota, Inc, 2550 University Avenue West, Suite 259S Saint Paul, MN 55114 or by email to mbisping@northstarmls.com. Questions can be directed by phone to 651-251-3200. The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint. Information Deemed Reliable but not guaranteed.

Menu