This architecturally designed masterpiece perched gracefully above the expansive Columbia River on 1.60 acres blends modern luxury with elegant sophistication is known as the "Cliff House" in the sun drenched sought after resort community of Crescent Bar. A rare fully furnished 2052sf custom stucco home with commanding views surrounded by the distinct basalt cliffs. The open concept great room with soaring ceilings and floor-to-ceiling windows creates the perfect space for everlasting memories. The chef’s kitchen boasts a grand island, custom cabinetry and stainless appliances. The main floor primary suite features a spa-inspired bathroom with a two sided fireplace, soaking tub and a spacious closet. Designed for a lifestyle of abundance.
Sold
Listed by:
Eric P. Russell,
John L. Scott Leavenworth
Bought with: Windermere RE Greenwood
$965,000
25 Mansfield Road, Quincy, WA 98848
2beds
2,052sqft
Single Family Residence
Built in 2007
1.6 Acres Lot
$989,800 Zestimate®
$470/sqft
$3,035 Estimated rent
Home value
$989,800
$772,000 - $1.28M
$3,035/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: October 23, 2025 at 04:03am
Listed by:
Eric P. Russell,
John L. Scott Leavenworth
Bought with:
Carl Nicholson, 8560
Windermere RE Greenwood
Source: NWMLS,MLS#: 2413715
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 3
- Full bathrooms: 1
- 3/4 bathrooms: 2
- Main level bathrooms: 3
- Main level bedrooms: 2
Primary bedroom
- Description: Soaking Tub, Expansive Closet
- Level: Main
Bedroom
- Level: Main
Bathroom full
- Level: Main
Bathroom three quarter
- Level: Main
Bathroom three quarter
- Level: Main
Den office
- Level: Main
Dining room
- Level: Main
Entry hall
- Level: Main
Family room
- Level: Main
Great room
- Description: Open Concept, Vast Views
- Level: Main
Kitchen with eating space
- Description: High-end Custom Appliances
- Level: Main
Living room
- Level: Main
Utility room
- Level: Main
Heating
- Fireplace, Forced Air, Heat Pump, Electric, Propane
Cooling
- Central Air, Forced Air, Heat Pump
Appliances
- Included: Dishwasher(s), Dryer(s), Microwave(s), Refrigerator(s), Stove(s)/Range(s), Trash Compactor, Washer(s), Water Heater: Electric, Water Heater Location: Garage
Features
- Bath Off Primary, Ceiling Fan(s), Dining Room, High Tech Cabling, Walk-In Pantry
- Flooring: Laminate
- Windows: Double Pane/Storm Window
- Basement: None
- Number of fireplaces: 1
- Fireplace features: Gas, Main Level: 1, Fireplace
Interior area
- Total structure area: 2,052
- Total interior livable area: 2,052 sqft
Property
Parking
- Total spaces: 2
- Parking features: Driveway, Attached Garage, Off Street, RV Parking
- Attached garage spaces: 2
Features
- Levels: One
- Stories: 1
- Entry location: Main
- Patio & porch: Second Primary Bedroom, Bath Off Primary, Ceiling Fan(s), Double Pane/Storm Window, Dining Room, Fireplace, Fireplace (Primary Bedroom), High Tech Cabling, Walk-In Closet(s), Walk-In Pantry, Water Heater, Wine/Beverage Refrigerator
- Pool features: In Ground, In-Ground
- Has view: Yes
- View description: City, Mountain(s), River, Territorial
- Has water view: Yes
- Water view: River
- Waterfront features: Low Bank
Lot
- Size: 1.60 Acres
- Features: Corner Lot, Cul-De-Sac, Dead End Street, Open Lot, Paved, Secluded, Athletic Court, Cable TV, High Speed Internet, Patio, Propane, RV Parking, Shop
- Topography: Level,Partial Slope,Sloped
- Residential vegetation: Brush, Garden Space
Details
- Parcel number: 91001200100
- Zoning description: Jurisdiction: County
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Stucco
- Roof: Tile
Condition
- Very Good
- Year built: 2007
- Major remodel year: 2007
Utilities & green energy
- Electric: Company: Douglas County PUD
- Sewer: Septic Tank
- Water: Shared Well
- Utilities for property: Local Tel
Community & neighborhood
Location
- Region: Quincy
- Subdivision: Trinidad
Other
Other facts
- Listing terms: Cash Out,Conventional,FHA,USDA Loan,VA Loan
- Cumulative days on market: 8 days
Price history
| Date | Event | Price |
|---|---|---|
| 9/22/2025 | Sold | $965,000-2.4%$470/sqft |
Source:  NWMLS #2413715 Report a problem | ||
| 8/13/2025 | Pending sale | $989,000$482/sqft |
Source: NWMLS #2413715 Report a problem | ||
| 8/6/2025 | Listed for sale | $989,000+10%$482/sqft |
Source: NWMLS #2413715 Report a problem | ||
| 1/31/2020 | Listing removed | $899,000$438/sqft |
Source: Windermere Real Estate/FN #1450660 Report a problem | ||
| 7/5/2019 | Price change | $899,000-4.3%$438/sqft |
Source: Windermere Real Estate/FN #1450660 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $5,427 -2.4% | $669,900 0% |
| 2023 | $5,562 -7.5% | $670,200 -0.6% |
| 2022 | $6,011 +3.8% | $674,300 +10.6% |
Find assessor info on the county website
Neighborhood: 98848
Nearby schools
GreatSchools rating
- 3/10Monument Elementary SchoolGrades: K-5Distance: 7 mi
- 5/10Quincy Junior High SchoolGrades: 6-8Distance: 8.2 mi
- 2/10Quincy High SchoolGrades: 9-12Distance: 8.3 mi
Schools provided by the listing agent
- Middle: Quincy Jnr High
- High: Quincy High
Source: NWMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.