🏡 2 Homes on 1 Lot in Family-Friendly Lincoln Estates! Rare opportunity in sought-after Lincoln Estates! This unique Roseville property features two homes on one lot currently generating passive income. The main home boasts 1,819 sq ft, 3 bedrooms, 2 baths, and a finished basement. Step into the backyard oasis, complete with a covered porch, market lights, mature trees, Koi pond, and Japanese hot tub a serene retreat. The second home is a fully furnished, professionally managed Airbnb with a private entrance, offering steady income and complete privacy from the main house. Located walking distance to Downtown Roseville and Vernon Street's shops and dining, thisproperty sits in a vibrant, family-friendly neighborhood a prime spot in Roseville. Live in the main home, airbnb the other an investment with endless potential!
Closed
$785,000
204 Columbia Ave, Roseville, CA 95678
3beds
1,819sqft
Single Family Residence
Built in 1945
5,762 Square Feet Lot
$786,100 Zestimate®
$432/sqft
$2,871 Estimated rent
Home value
$786,100
$723,000 - $857,000
$2,871/mo
Zestimate® history
Owner options
List your home for rent
$2,871/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$2,871/mo
Rent Zestimate®
Refinance and save
$4,968/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$4,968/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
Finished basementMature treesKoi pondBackyard oasisJapanese hot tubCovered porchMarket lights
Zillow last checked:
Listing updated:
Listed by:
Shawn Habermehl DRE #02199875 916-788-8800,
Keller Williams Realty
Bought with:
PCH Realtors
Source: MetroList Services of CA,MLS#: 225026605Originating MLS: MetroList Services, Inc.
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Rooms
- Room types: In Law Apartment
Dining room
- Features: Bar
Kitchen
- Features: Granite Counters
Heating
- Central, Fireplace(s)
Cooling
- Central Air, Whole House Fan
Appliances
- Included: Built-In Electric Oven, Free-Standing Gas Range, Gas Plumbed, Built-In Gas Range, Dishwasher, Disposal
- Laundry: Electric Dryer Hookup, Gas Dryer Hookup
Features
- Flooring: Carpet, Wood
- Number of fireplaces: 1
- Fireplace features: Family Room
Interior area
- Total interior livable area: 1,819 sqft
Property
Parking
- Parking features: No Garage, Alley Access
Features
- Stories: 2
- Fencing: Back Yard,Fenced,Front Yard
Lot
- Size: 5,762 Square Feet
- Features: Landscape Back, Landscape Front
Details
- Additional structures: Guest House
- Parcel number: 013114001000
- Zoning description: RES
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Cape Cod
- Property subtype: Single Family Residence
Materials
- Frame, Wood
- Foundation: Raised
- Roof: Composition
Condition
- Year built: 1945
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public
Community & HOA
Location
- Region: Roseville
Financial & listing details
- Price per square foot: $432/sqft
- Tax assessed value: $524,273
- Annual tax amount: $5,442
- Date on market: 7/5/2025
Price history
| Date | Event | Price |
|---|---|---|
| 5/6/2025 | Sold | $785,000+4.7%$432/sqft |
Source: MetroList Services of CA #225026605 Report a problem | ||
| 4/7/2025 | Pending sale | $750,000$412/sqft |
Source: MetroList Services of CA #225026605 Report a problem | ||
| 4/3/2025 | Listed for sale | $750,000+107.2%$412/sqft |
Source: MetroList Services of CA #225026605 Report a problem | ||
| 6/27/2003 | Sold | $362,000$199/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $5,442 +1.3% | $524,273 +2% |
| 2024 | $5,371 +29.8% | $513,994 +30.1% |
| 2023 | $4,138 -7.2% | $395,000 -5% |
| 2022 | $4,458 -13% | $416,000 -13.5% |
| 2021 | $5,127 +10.9% | $480,697 +12.4% |
| 2020 | $4,622 | $427,558 -7.5% |
| 2019 | $4,622 +3.3% | $462,212 +10.3% |
| 2018 | $4,476 +16.9% | $419,212 +17.5% |
| 2017 | $3,829 -1.4% | $356,789 +1.4% |
| 2016 | $3,881 +2.7% | $351,879 +2.3% |
| 2015 | $3,778 +24.6% | $344,028 +25.4% |
| 2014 | $3,033 | $274,335 +19.6% |
| 2013 | -- | $229,371 +26.7% |
| 2012 | -- | $181,000 |
| 2011 | -- | $181,000 -19.5% |
| 2010 | -- | $224,839 -6.7% |
| 2009 | -- | $240,899 -18.9% |
| 2008 | -- | $297,109 -24.1% |
| 2007 | -- | $391,326 +2% |
| 2006 | -- | $383,654 +2% |
| 2005 | -- | $376,132 +2% |
| 2004 | -- | $368,758 +100.2% |
| 2003 | -- | $184,185 +2% |
| 2002 | -- | $180,575 +2% |
| 2001 | -- | $177,035 +2% |
| 2000 | -- | $173,565 |
Find assessor info on the county website
Neighborhood: Folsom Road
Nearby homes
- $503,9003 bd1 ba1.7k sqft208 Columbia Ave, Roseville, CA 95678Off Market
- $635,9002 bd1 ba1.9k sqft212 Columbia Ave, Roseville, CA 95678Off Market
- $439,7002 bd1 ba1.3k sqft120 Columbia Ave, Roseville, CA 95678Off Market
- $512,0003 bd2 ba1.4k sqft215 Folsom Rd, Roseville, CA 95678Off Market
- $547,9003 bd3 ba1.4k sqft217 Folsom Rd, Roseville, CA 95678Off Market
- $473,1003 bd1 ba1.5k sqft219 Folsom Rd, Roseville, CA 95678Off Market
- $511,9005 bd1 ba1.8k sqft216 Columbia Ave, Roseville, CA 95678Off Market
- $409,5002 bd1 ba1.3k sqft114 Columbia Ave, Roseville, CA 95678Off Market
Nearby schools
GreatSchools rating
- 8/10Ferris Spanger Elementary SchoolGrades: K-5Distance: 0.8 mi
- 5/10George A. Buljan Middle SchoolGrades: 6-8Distance: 2.4 mi
- 7/10Roseville High SchoolGrades: 9-12Distance: 0.7 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
$786,100
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
$786,100
- California
- Placer County
- Roseville
- 95678
- Folsom Road
- 204 Columbia Ave
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Roseville Topics
