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.
Closed
$1,100,000
175 Sherman St Unit 204, Saint Paul, MN 55102
3beds
2,638sqft
Low Rise
Built in 2004
-- sqft lot
$1,131,800 Zestimate®
$417/sqft
$3,251 Estimated rent
Home value
$1,131,800
$1.02M - $1.26M
$3,251/mo
Zestimate® history
Owner options
List your home for rent
$3,251/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,251/mo
Rent Zestimate®
Refinance and save
$7,857/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$7,857/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
Scott J. Acker 612-920-5605,
Coldwell Banker Realty - Lakes
Bought with:
Nicole A. Lettner
Edina Realty, Inc.
Source: NorthstarMLS as distributed by MLS GRID,MLS#: 6781976
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 1
- 3/4 bathrooms: 1
Bedroom
- Level: Main
- Area: 324 Square Feet
- Dimensions: 18x18
Bedroom 2
- Level: Main
- Area: 168 Square Feet
- Dimensions: 14x12
Bedroom 3
- Level: Main
- Area: 156 Square Feet
- Dimensions: 13x12
Deck
- Level: Main
- Area: 120 Square Feet
- Dimensions: 15x8
Dining room
- Level: Main
- Area: 180 Square Feet
- Dimensions: 15x12
Family room
- Level: Main
- Area: 252 Square Feet
- Dimensions: 18x14
Kitchen
- Level: Main
- Area: 391 Square Feet
- Dimensions: 23x17
Laundry
- Level: Main
- Area: 54 Square Feet
- Dimensions: 9x6
Living room
- Level: Main
- Area: 486 Square Feet
- Dimensions: 18x27
Sun room
- Level: Main
- Area: 110 Square Feet
- Dimensions: 11x10
Utility room
- Level: Main
- Area: 108 Square Feet
- Dimensions: 12x9
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Cooktop, Dishwasher, Dryer, Microwave, Refrigerator, Stainless Steel Appliance(s), Wall Oven, Washer, Wine Cooler
- Laundry: Laundry Room
Features
- Basement: None
- Number of fireplaces: 1
- Fireplace features: Gas, Stone
Interior area
- Total structure area: 2,638
- Total interior livable area: 2,638 sqft
- Finished area above ground: 2,638
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Garage Door Opener, Heated Garage, Insulated Garage, Secured, Underground
- Garage spaces: 2
- Has uncovered spaces: Yes
- Details: Garage Dimensions (24x21), Garage Door Height (7), Garage Door Width (16)
Accessibility
- Accessibility features: Accessible Elevator Installed
Features
- Levels: More Than 2 Stories
- Patio & porch: Deck
- Has view: Yes
- View description: City Lights, Panoramic, River, South
- Has water view: Yes
- Water view: River
- Waterfront features: River View
Details
- Foundation area: 2748
- Parcel number: 062822320198
- Zoning description: Residential-Single Family
Construction
Type & style
- Home type: Condo
- Property subtype: Low Rise
- Attached to another structure: Yes
Condition
- New construction: No
- Year built: 2004
Utilities & green energy
- Gas: Natural Gas
- Sewer: City Sewer/Connected
- Water: City Water/Connected
Community & HOA
Community
- Security: Fire Sprinkler System, Secured Garage/Parking
- Subdivision: Cic 511 Riverfront Condo Upper Landi
HOA
- Has HOA: Yes
- Amenities included: Elevator(s), Fire Sprinkler System, In-Ground Sprinkler System, Security Building
- Services included: Hazard Insurance, Lawn Care, Maintenance Grounds, Professional Mgmt, Sanitation, Sewer, Snow Removal, Water
- HOA fee: $769 monthly
- HOA name: Cedar Management
- HOA phone: 763-231-9825
Location
- Region: Saint Paul
Financial & listing details
- Price per square foot: $417/sqft
- Tax assessed value: $1,137,300
- Annual tax amount: $20,603
- Date on market: 9/4/2025
- Cumulative days on market: 19 days
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 12/5/2025 | Sold | $1,100,000-8.3%$417/sqft |
Source:  NorthstarMLS as distributed by MLS GRID #6781976 Report a problem | ||
| 9/26/2025 | Pending sale | $1,200,000$455/sqft |
Source: NorthstarMLS as distributed by MLS GRID #6781976 Report a problem | ||
| 9/6/2025 | Listed for sale | $1,200,000+23%$455/sqft |
Source: NorthstarMLS as distributed by MLS GRID #6781976 Report a problem | ||
| 8/12/2016 | Sold | $975,625-2.4%$370/sqft |
Source: NorthstarMLS as distributed by MLS GRID #4725407 Report a problem | ||
| 7/12/2016 | Pending sale | $999,900$379/sqft |
Source: RE/MAX Results #4725407 Report a problem | ||
| 6/7/2016 | Listed for sale | $999,900-18.4%$379/sqft |
Source: RE/MAX Results #4725407 Report a problem | ||
| 5/26/2006 | Sold | $1,224,960$464/sqft |
Source: Public Record Report a problem | ||
| 1/31/2006 | Sold | $1,224,960$464/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $20,776 +8.9% | $1,137,300 +0.8% |
| 2024 | $19,076 -0.9% | $1,128,700 +0.8% |
| 2023 | $19,248 -3.7% | $1,119,800 +0.8% |
| 2022 | $19,984 +6.2% | $1,110,800 +0.2% |
| 2021 | $18,814 -7% | $1,108,200 +1.8% |
| 2020 | $20,238 +18.3% | $1,088,100 +10.8% |
| 2019 | $17,111 | $982,200 |
| 2018 | $17,111 -0.5% | $982,200 +3.9% |
| 2017 | $17,194 | $945,700 |
| 2016 | $17,194 +12.6% | -- |
| 2015 | $15,274 +11.9% | $845,700 |
| 2014 | $13,650 +2.7% | -- |
| 2013 | $13,286 +4.4% | -- |
| 2012 | $12,722 -2.1% | -- |
| 2011 | $12,990 | -- |
| 2010 | -- | -- |
| 2009 | $12,706 +5.6% | -- |
| 2008 | $12,034 +6.6% | -- |
| 2007 | $11,288 -16.7% | -- |
| 2006 | $13,544 +793.4% | -- |
| 2005 | $1,516 | -- |
Find assessor info on the county website
Neighborhood: West 7th
Nearby homes
- $530,0002 bd3 ba2.1k sqft304 Spring St, Saint Paul, MN 55102Sold
- $490,0002 bd3 ba2.2k sqft198 Elm St, Saint Paul, MN 55102Sold
- $560,0002 bd2 ba1.7k sqft312 Spring St APT 401, Saint Paul, MN 55102Sold
- $399,5002 bd3 ba1.8k sqft294 Spring St, Saint Paul, MN 55102Sold
- $740,0002 bd2 ba1.9k sqft312 Spring St APT 410, Saint Paul, MN 55102Sold
- $550,0002 bd2 ba1.7k sqft312 Spring St APT 310, Saint Paul, MN 55102Sold
- $685,0003 bd3 ba2.6k sqft312 Spring St APT 309, Saint Paul, MN 55102Sold
- $430,0002 bd2 ba1.8k sqft300 Spring St, Saint Paul, MN 55102Sold
Nearby schools
GreatSchools rating
- 1/10Maxfield Magnet Elementary SchoolGrades: PK-5Distance: 1.9 mi
- 3/10Hidden River Middle SchoolGrades: 6-8Distance: 3.2 mi
- 7/10Central Senior High SchoolGrades: 9-12Distance: 2.4 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,131,800
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,131,800
- Minnesota
- Ramsey County
- Saint Paul
- 55102
- West 7th
- 175 Sherman St Unit 204
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Saint Paul Topics
