3 2 1,819 5,762 –
Beds Baths Sq Ft Sq Ft Lot Yr Built

Property Details

Neighborhood Map
About this Property

🏡 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!

Mortgage Calculator

Your path to home ownership starts here. Let us help you calculate your monthly costs.

MLS Listing Information

MLS #

ME225026605

MLS Source

MetroList Services, Inc.

Interior Features

Kitchen

Countertop - Granite, Hookups - Gas, Updated

Appliances

Dishwasher, Garbage Disposal, Oven - Built-In, Oven - Electric, Oven Range - Built-In, Gas, Oven Range - Gas

Dining Room

Dining Bar

Fireplace

Family Room

Flooring

Carpet, Wood

Laundry

Hookup - Electric, Hookup - Gas Dryer

Cooling

Central Forced Air, Whole House Fan

Heating

Central Forced Air, Fireplace

Exterior Features

Roof

Composition

Foundation

Raised

Pool

Pool - No

Style

Cape Cod

Parking, School, and Other Information

Garage/Parking

Access - Alley, No Garage, Garage: 0 Car(s)

Sewer

Public Sewer

Water

Public

Zoning

RES

Unit Information
# Buildings # Leased Units # Total Units
0 – –
Listing Agent

Shawn Habermehl

Keller Williams Realty

License #: 02199875

Phone: (916) 788-8800

Neighborhood: Around This Home

Neighborhood: Local Demographics

204 Columbia Ave is a Single Family Residence in Roseville, CA 95678. This 1,819 square foot property sits on a 5,762 Sq Ft Lot and features 3 bedrooms & 2 full bathrooms. It is currently priced at $785,000 and was built in –. This address can also be written as 204 Columbia Ave, Roseville, CA 95678.

©2025 MetroList Services, Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MetroList Services, Inc.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of May 06, 2025. For the most current information, please contact Shawn Habermehl, (916) 788-8800