London Properties Modesto Real Estate

605 W Union

Modesto, CA 95356

Copy Link Get Directions

$579,000

4 bd

3 ba

2,056 sq ft

0.19 acre

605 W Union

Modesto, CA 95356

Get Directions

Virtual Tour

Listed On: 05/15/2026

Status: Active

Listing Number: 226060445 (Metrolist MLS)

Open House

Sat, May 16
11:00am - 1:00pm
Courtesy of HomeSmart PV & Associates

Sat, May 16
1:00pm - 3:30pm
Courtesy of HomeSmart PV & Associates

Sun, May 17
12:00pm - 3:00pm
Courtesy of HomeSmart PV & Associates

Schedule a Tour

Contact Info

Presented By:

London Properties, Ltd. 559.436.4071 Email Agent

Property Description

Welcome to one of North Modesto's most desirable locations. This spacious 2056 sq ft single‑story home is nestled in an established neighborhood and has been well‑maintained with thoughtful updates throughout with only 1 original owner. A formal entrance welcomes you into a flowing layout featuring new laminate flooring throughout, leading into 4 bedrooms, 2 living areas, a formal dining room, and an inviting kitchen. Recent upgrades include freshly painted interior and exterior walls, adding a crisp, modern feel. The family room offers a cozy fireplace with insert and opens directly to the kitchen, creating a warm and functional gathering space. Vaulted ceilings enhance the open feel, while the kitchen features a spacious island, tile counters, and plenty of room for cooking and entertaining. The interior has been updated with new light fixtures, complementing the fresh paint and brightening each room. The primary bedroom includes a private patio deck with direct access to the pool and backyard, offering a relaxing retreat. Step outside and enjoy your private pool, ideal for summer relaxation. The property also includes RV access with a designated parking site for convenient storage. A treated wood deck provides the perfect space for BBQs and outdoor gatherings.

Property Type

Residential

Property Subtype 1

Single Family Residence

Subtype Description

Detached

Property Condition

Updated/Remodeled, Original

Year Built

1977

Year Built Source

Assessor Auto-Fill

Remodeled/Updated

Yes

Remodeled/Updated Desc

Other-Rmks 0-5YR, Bed 0-5YR

Stories

Levels

One

Home Warranty

Directions to Property

From Hwy 99 take Standiford Ave East (appx 3 miles) Pass Tully Rd...Take Columbine Dr go Left drive to the end (stop) take a left on W Union house is on the Right.

Cross Street

Columbine Dr

County

Stanislaus

Special Listing Conditions

Probate Listing, Other

Main Level

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

Architectural Style

Ranch

Construction Materials

Brick, Frame, Wood Siding

Foundation

Concrete, Raised

Roof

Composition

Heating

Central, Fireplace Insert

Cooling

Ceiling Fan(s), Central

Laundry Features

Cabinets, Ground Floor, Inside Area

Property Faces

South

Other Structures

Other

Interior Features

Cathedral Ceiling, Open Beam Ceiling, Formal Entry

Full Bathrooms

Half Bathrooms

Bath Features

Tile, Tub w/Shower Over, Window, Other

# of Fireplaces

Fireplace Features

Insert, Gas Piped, Other

Flooring

Laminate, Linoleum

Appliances

Built-In Electric Oven, Dishwasher, Disposal, Microwave, Plumbed For Ice Maker, Electric Cook Top

Room Type

Bonus Room, Dining Room

Kitchen Features

Breakfast Area, Island w/Sink, Kitchen/Family Combo, Tile Counter

Dining Room Features

Dining Bar, Space in Kitchen, Formal Area

Living Room Features

Cathedral/Vaulted, Open Beam Ceiling

Primary Bedroom Features

Ground Floor, Walk-In Closet, Outside Access

Primary Bathroom Features

Shower Stall(s), Tile, Window

Patio And Porch Features

Back Porch, Uncovered Deck, Covered Patio

Pool

Yes

Pool Features

Built-In, On Lot, Gunite Construction, Other

Spa

Yes

Spa Features

Spa/Hot Tub Personal

ADU/2nd Unit

Utilities

Public, Electric, Sewer In & Connected, Other

Electric

220 Volts

Irrigation

None

Water Source

Public, Meter on Site, See Remarks

Sewer

Public Sewer, Other

Parking Features

Attached, Boat Storage, RV Access, Enclosed, Garage Door Opener, Garage Facing Front, Interior Access

Garage Spaces

2.00

Lot Features

Auto Sprinkler Front, Shape Regular

APN

055 035 022 000

Driveway/Sidewalks

Sidewalk/Curb/Gutter

Fencing

Back Yard, Chain Link, Wood, Fenced, Other

Horse Property

Road Responsibility

Public Maintained Road

Zoning Description

Redidential

List AOR

MetroList Services, Inc.

Association

Senior Community

School District (County)

Stanislaus

Elementary School District

Stanislaus Union

Middle or Junior School District

Stanislaus Union

Senior High School District

Modesto City

Census Tract

5.06

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 550050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 607950 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) >= 1806 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2306 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` = 1726073 OR `props-main`.`id` = 1726019 OR `props-main`.`id` = 1722317 OR `props-main`.`id` = 1712711 OR `props-main`.`id` = 1725099 OR `props-main`.`id` = 1724593 OR `props-main`.`id` = 1707045 OR `props-main`.`id` = 1726899 OR `props-main`.`id` = 1722465 OR `props-main`.`id` = 1726431 OR `props-main`.`id` = 1702807 OR `props-main`.`id` = 1725005 OR `props-main`.`id` = 1716276 OR `props-main`.`id` = 1723691 OR `props-main`.`id` = 1713162 OR `props-main`.`id` = 1709443 OR `props-main`.`id` = 1724411 OR `props-main`.`id` = 1720968 OR `props-main`.`id` = 1721379 OR `props-main`.`id` = 1722054 OR `props-main`.`id` = 1723462 OR `props-main`.`id` = 1726966 OR `props-main`.`id` = 1721152 OR `props-main`.`id` = 1720807 OR `props-main`.`id` = 1714968 OR `props-main`.`id` = 1725723 OR `props-main`.`id` = 1726121 OR `props-main`.`id` = 1715603 OR `props-main`.`id` = 1722985 OR `props-main`.`id` = 1724364 OR `props-main`.`id` = 1725721 OR `props-main`.`id` = 1714244 OR `props-main`.`id` = 1725612 OR `props-main`.`id` = 1725996 OR `props-main`.`id` = 1722286 OR `props-main`.`id` = 1724418 OR `props-main`.`id` = 1726521 OR `props-main`.`id` = 1723553 OR `props-main`.`id` = 1713189 OR `props-main`.`id` = 1726765 OR `props-main`.`id` = 1723998 OR `props-main`.`id` = 1727045 OR `props-main`.`id` = 1704964 OR `props-main`.`id` = 1723461 OR `props-main`.`id` = 1724573 OR `props-main`.`id` = 1724659 OR `props-main`.`id` = 1666517 OR `props-main`.`id` = 1716594 OR `props-main`.`id` = 1716436 OR `props-main`.`id` = 1725740 OR `props-main`.`id` = 1694971 OR `props-main`.`id` = 1722600 OR `props-main`.`id` = 1717181 OR `props-main`.`id` = 1717240 OR `props-main`.`id` = 1722602 OR `props-main`.`id` = 1725170 OR `props-main`.`id` = 1726514 OR `props-main`.`id` = 1724876 OR `props-main`.`id` = 1724209 OR `props-main`.`id` = 1724019 OR `props-main`.`id` = 1726481 OR `props-main`.`id` = 1727057 OR `props-main`.`id` = 1725186 OR `props-main`.`id` = 1725031 OR `props-main`.`id` = 1726359 OR `props-main`.`id` = 1721491 OR `props-main`.`id` = 1725421 OR `props-main`.`id` = 1726191 OR `props-main`.`id` = 1717558 OR `props-main`.`id` = 1726026 OR `props-main`.`id` = 1715828 OR `props-main`.`id` = 1712982 OR `props-main`.`id` = 1721951 OR `props-main`.`id` = 1694633 OR `props-main`.`id` = 1718681 OR `props-main`.`id` = 1719267 OR `props-main`.`id` = 1724305 OR `props-main`.`id` = 1723601 OR `props-main`.`id` = 1726931 OR `props-main`.`id` = 1720300 OR `props-main`.`id` = 1724821 OR `props-main`.`id` = 1712487 OR `props-main`.`id` = 1720850 OR `props-main`.`id` = 1704269 OR `props-main`.`id` = 1724501 OR `props-main`.`id` = 1725344 OR `props-main`.`id` = 1725801 OR `props-main`.`id` = 1721749 OR `props-main`.`id` = 1719090 OR `props-main`.`id` = 1713231 OR `props-main`.`id` = 1724605 OR `props-main`.`id` = 1722647 OR `props-main`.`id` = 1726849 OR `props-main`.`id` = 1722394)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226060445' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-15' 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();

Similar Properties

$555,000

4
3
2,207
0.11

1813 Mark Mead Ln

Modesto, CA 95356

Courtesy of Mary Salazar-Barrera, HomeSmart PV & Associates
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.

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

605 W Union

Modesto, CA 95356

$579,000

605 W Union

Modesto, CA 95356

Open House

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$555,000

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

605 W Union

Modesto, CA 95356

$579,000

605 W Union

Modesto, CA 95356

Open House

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$555,000

Loading...

Saving...

Deleting...

Searching...