Sold336d on market
204 Columbia Ave
Roseville, CA, 95678 • Folsom Road • Placer County
$785,000
$432/sqft
3Beds
2Baths
1,819Sqft
0.13 acLot
1945Built
Property DNA
Cape Cod Style
Built 1945 · 81 years of history
1 Fireplace
Family Room
Guest House
Guest House
Wood Floors
Quality flooring throughout
This home is in high demand
Listed 336 days ago · 29 views · 1 saves · Top 1% likely to sell soon
Market activity
Demand and pricing signals for this listing
29 views
People checking out this listing
1 saves
Buyers have saved this home
336 days on market
Established listing
$432/sqft
Price per square foot
Selling Soon Prediction
Very HighThis home ranks in the top 1% of listings most likely to go under contract soon, based on market activity and demand signals.
Likelihood score
Want the full market analysis?
Get the detailed selling prediction score, comparable sales data, and price trend forecast for this property.
Free · Delivered to your inbox in minutes
About this home
Single Family · Built 1945
🏡 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!
Standout features identified
Our analysis highlights finished basement, mature trees, and koi pond as key attractions of this home.
Estimated monthly payment
Based on current rates
$4,851/month
Principal & Interest$3,804
Property Tax$785
Insurance$262
Down payment20% ($157,000)
3%50%
Est. 6.10% rate · 30yr fixed · $628,000 loan
Full calculator →At a glance
Key facts and listing details
TypeSingle Family Residence
Year Built1945
HeatingCentral, Fireplace(s)
CoolingCentral Air, Whole House Fan
ParkingNo Garage, Alley Access
Lot5,762 sqft
Property
Home typeSingle Family
Sub-typeSingle Family Residence
StyleCape Cod
Year built1945
Stories2
Systems
HeatingCentral, Fireplace(s)
CoolingCentral Air, Whole House Fan
RoofComposition
ConstructionFrame, Wood
Water / SewerPublic / Public Sewer
Parking & Outdoor
ParkingNo Garage, Alley Access
Fireplaces1
FencingBack Yard,Fenced,Front Yard
Lot5,762 sqft
Location & Tax
NeighborhoodFolsom Road
Annual tax$5,442
Parcel013114001000
Bathrooms & Fees
Full baths2
Features & details
11 categories of property features
Interior Features
Appliances
Built-In Electric Oven
Free-Standing Gas Range
Gas Plumbed
Built-In Gas Range
Dishwasher
Disposal
Flooring
Carpet
Wood
Heating
Central
Fireplace(s)
Cooling
Central Air
Whole House Fan
Laundry
Electric Dryer Hookup
Gas Dryer Hookup
Fireplace
Family Room
Exterior Features
Parking
No Garage
Alley Access
Construction
Frame
Wood
Lot Features
Landscape Back
Landscape Front
Utilities
Public
Other Structures
Guest House
Room details
2 rooms detailed
Dining Room
Bar
Kitchen
Granite Counters
Listing insights
Market data and value estimates
StatusSold
Days on market336
Est. value$779,600
Est. rent$2,772/mo
Tax rate1.07%
Price/sqft$432
On marketJul 5, 2025
PostedJul 5, 2025
Last sold$785,000
MLS statusClosed
MLS updatedMay 6, 2025
Tour days6
Views29
Favorites1
How are the schools in Roseville?
3 schools rated nearby
Location
Roseville, CA, 95678
Price history
4 events
DateEventPrice$/sqftSource
May 6, 2025Sold$785,000$432MetroList Services of CA
Apr 7, 2025Pending Sale$750,000$412MetroList Services of CA
Apr 3, 2025Listed For Sale$750,000$412MetroList Services of CA
Jun 27, 2003Sold$362,000$199Public Record
Sold$785,000
May 6, 2025•$432/sqft•MetroList Services of CA
Pending Sale$750,000
Apr 7, 2025•$412/sqft•MetroList Services of CA
Listed For Sale$750,000
Apr 3, 2025•$412/sqft•MetroList Services of CA
Sold$362,000
Jun 27, 2003•$199/sqft•Public Record
Tax history
26 years of records
YearTax paidAssessed value
Apr 8, 2025$5,442$524,273
Apr 8, 2024$5,371$513,994
Apr 8, 2023$4,138$395,000
Apr 8, 2022$4,458$416,000
Apr 8, 2021$5,127$480,697
Apr 8, 2020$4,622$427,558
Apr 8, 2019$4,622$462,212
Apr 8, 2018$4,476$419,212
Apr 8, 2017$3,829$356,789
Apr 8, 2016$3,881$351,879
Apr 8, 2015$3,778$344,028
Apr 8, 2014$3,033$274,335
Apr 8, 2013—$229,371
Apr 8, 2012—$181,000
Apr 8, 2011—$181,000
Apr 8, 2010—$224,839
Apr 8, 2009—$240,899
Apr 8, 2008—$297,109
Apr 8, 2007—$391,326
Apr 8, 2006—$383,654
Apr 8, 2005—$376,132
Apr 8, 2004—$368,758
Apr 8, 2003—$184,185
Apr 8, 2002—$180,575
Apr 8, 2001—$177,035
Apr 8, 2000—$173,565
Nearby homes
Neighborhood details
Local context around this listing
Roseville, CA • Placer County
Nearby neighborhoods
Blue OaksFiddyment FarmFoothills JunctionHighland ReserveKaseberg-KingswoodQuail GlenStoneridgeSun CityWestparkWoodcreek Oaks
Nearby cities
AuburnColfaxElvertaGranite BayLincolnLoomisNewcastleRocklin
Nearby zip codes
956619567895747
Similar homes
No obligation · Same-day response