London Properties Atwater Real Estate

Tiffany Wilson

REALTOR^®

Tiffany Wilson | 209.617.7030 | twilson@londonproperties.com | LIC #02067966

Tiffany Wilson

(209) 617-7030

Home Buying Selling About Contact Weekly Blog Socials Vendors Business Card

Create Account

Fields marked with * are required. However, providing more information will allow us to better serve your needs.
* First Name:
* Last Name:
* Email Address:
* Password:
* Confirm Password:
Street Address:
City:
State:
Zip:
Cell Phone:
Other Phone:

Home

Buying

Selling

Home Value Calculator

About

Socials

Vendors

Landscaping Maintenance

Business Card

Create Account | Login

Fresno Bee People's Choice Award Winner - #1 Best Real Estate Company

851 BOULDER

Atwater, CA 95301

Copy Link Get Directions

Photo Gallery

$479,000

4 bd

3 ba

2,310 sq ft

0.17 acre

851 BOULDER

Atwater, CA 95301

Get Directions

Virtual Tour

Listed On: 09/25/2025

Status: Active

Listing Number: 225125891 (Metrolist MLS)

Schedule a Tour

Contact Info

Presented By:

Tiffany Wilson 209.617.7030 Email Agent

Property Description

**Stunning New Listing in Stone Creek!** **Move-In Ready Perfection** 2017 Build, 4 Bedrooms, 3 Full Baths, 2,310 sq ft OVERSIZE GARAGE, Single Story, Spacious living on a 7,352 sq ft lot. Updated with new Interior Paint, blinds, flooring, & ceiling fans. Stainless steel appliances included. Brand new concrete in the backyard and extended driveway. Steps from Bellevue Elementary and nearby walking trails. Close to shopping. This is more than just a house; it's your next chapter in a desirable Atwater neighborhood. Act fast, it won't last long!

Property Type

Residential

Property Subtype 1

Single Family Residence

Subtype Description

Detached

Property Condition

Updated/Remodeled

Year Built

2017

Year Built Source

Assessor Agent-Fill

Remodeled/Updated

Yes

Remodeled/Updated Desc

Other-Rmks 0-5YR

Stories

Levels

One

Pets Allowed

Yes, Service Animals OK, Cats OK

Home Warranty

Directions to Property

Follow CA-99 S to Atwater-Merced Expy. Take exit 193 from CA-99 S Continue on Atwater-Merced Expy. Take Green Sands Ave, N Buhach Rd, and E Bellevue Rd to Boulder Dr in Atwater

Cross Street

STONE CREEK DR

County

Merced

Special Listing Conditions

None

Main Level

Bedroom(s), Living Room, Dining Room, Family Room, Full Bath(s), Garage, Kitchen, Street Entrance

Architectural Style

Ranch, Craftsman

Construction Materials

Concrete, Wood

Foundation

Concrete, Slab

Roof

Tile

Heating

Central

Laundry Features

Dryer Included, Washer Included, Inside Area, Inside Room

Window Features

Dual Pane Full

Property Faces

South

Full Bathrooms

Bath Features

Closet, Shower Stall(s), Double Sinks, Tile, Tub, Window

Possible Bedrooms

Flooring

Carpet, Tile, Wood

Appliances

Free Standing Gas Range, Ice Maker, Dishwasher, Microwave, Tankless Water Heater, Free Standing Gas Oven

Kitchen Features

Granite Counter, Island, Stone Counter, Island w/Sink, Kitchen/Family Combo

Dining Room Features

Dining/Family Combo

Living Room Features

Other

Primary Bedroom Features

Sitting Area

Primary Bathroom Features

Shower Stall(s), Double Sinks, Tile, Tub, Walk-In Closet, Window

Patio And Porch Features

Front Porch

Pool

Spa

ADU/2nd Unit

Utilities

Cable Available, Cable Connected, Sewer Connected, Sewer In & Connected, Electric, Underground Utilities, Natural Gas Available

Electric

220 Volts

Irrigation

Public District

Water Source

Meter on Site, Public

Sewer

Sewer in Street, Public Sewer

Parking Features

Attached, Garage Facing Front

Garage Spaces

2.00

Open Parking Spaces

2.00

Lot Features

Auto Sprinkler F&R, Landscape Back, Landscape Front

APN

004 412 018 000

Land Use

Residential

Driveway/Sidewalks

Paved Driveway

Fencing

Wood

Horse Property

Road Surface Type

Asphalt

Road Responsibility

Public Maintained Road

Zoning Description

Subdivision

STONE CREEK

List AOR

MetroList Services, Inc.

Association

Senior Community

School District (County)

Merced

Elementary School District

Atwater Elementary

Middle or Junior School District

Atwater Elementary

Senior High School District

Merced Union High

Distance To Shopping

4+ Blocks

Distance to Public Transportation

1 Mile

Census Tract

8.01

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 455050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 502950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2060 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2560 AND ((`props-main`.`PropertyType` = 'Residential' AND ( `props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR `props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR `props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR `props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR `props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR `props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR `props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 159004 OR `props-main`.`id` = 1687278 OR `props-main`.`id` = 1687269 OR `props-main`.`id` = 1677931 OR `props-main`.`id` = 1684475 OR `props-main`.`id` = 1684473 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687248 OR `props-main`.`id` = 1681454 OR `props-main`.`id` = 1687267 OR `props-main`.`id` = 1680386 OR `props-main`.`id` = 1680392 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1622894 OR `props-main`.`id` = 1678715 OR `props-main`.`id` = 1686457 OR `props-main`.`id` = 1686562 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1678728 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 1675208 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 1688612 OR `props-main`.`id` = 1688631 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1680711 OR `props-main`.`id` = 1682226 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1689533 OR `props-main`.`id` = 1685091 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1639779 OR `props-main`.`id` = 1675140 OR `props-main`.`id` = 1627752 OR `props-main`.`id` = 1651865 OR `props-main`.`id` = 1688038 OR `props-main`.`id` = 1674298 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1676559 OR `props-main`.`id` = 1682532 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1684138 OR `props-main`.`id` = 1685928 OR `props-main`.`id` = 1673216 OR `props-main`.`id` = 1673221 OR `props-main`.`id` = 1686760 OR `props-main`.`id` = 1683616 OR `props-main`.`id` = 1686268 OR `props-main`.`id` = 1686740 OR `props-main`.`id` = 1680693 OR `props-main`.`id` = 1680717 OR `props-main`.`id` = 1680723 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1689674 OR `props-main`.`id` = 1689667 OR `props-main`.`id` = 1685842 OR `props-main`.`id` = 1688930 OR `props-main`.`id` = 1690040 OR `props-main`.`id` = 1644663 OR `props-main`.`id` = 1642699 OR `props-main`.`id` = 1622885 OR `props-main`.`id` = 1663976 OR `props-main`.`id` = 1682782 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1668924 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1677622 OR `props-main`.`id` = 1686912 OR `props-main`.`id` = 1677617 OR `props-main`.`id` = 1677620 OR `props-main`.`id` = 1651866 OR `props-main`.`id` = 1651867 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1687151 OR `props-main`.`id` = 1686888 OR `props-main`.`id` = 1686925 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 1690092 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1688966 OR `props-main`.`id` = 1688440 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1690054 OR `props-main`.`id` = 1688767 OR `props-main`.`id` = 1688816 OR `props-main`.`id` = 1686506 OR `props-main`.`id` = 1689672 OR `props-main`.`id` = 1675292 OR `props-main`.`id` = 1675274 OR `props-main`.`id` = 1675278 OR `props-main`.`id` = 1656550 OR `props-main`.`id` = 1656714 OR `props-main`.`id` = 1656726 OR `props-main`.`id` = 1672924 OR `props-main`.`id` = 1678627 OR `props-main`.`id` = 1678617 OR `props-main`.`id` = 1684436 OR `props-main`.`id` = 1684479 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1690176 OR `props-main`.`id` = 1690198)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225125891' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-20' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();

Courtesy of Maria Lomeli, EXIT Realty Consultants
IDX provided by Reliance Marketing

Metrolist
Terms of Use

The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.

Get More Info

Print A Flyer

Get A Home Loan

Share

851 BOULDER

Atwater, CA 95301

Photo Gallery

$479,000

851 BOULDER

Atwater, CA 95301

Schedule a Tour

Contact Info

Presented By: