Step into this beautifully updated home, where a bright open-concept layout creates an inviting, airy feel from the moment you enter. The modern kitchen flows seamlessly into the main living areas and features quartz countertops, stainless steel appliances, and stylish finishes throughout. Situated on an expansive 7k+ sq ft. lot, the backyard offers exceptional space for entertaining, gardening, or even adding a future pool. The detached two-car garage provides added flexibility for storage or the possibility of an ADU conversion.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1979
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Home Warranty
No
Directions to Property
From Highway 99, take the Monte Vista Avenue exit and head east. Turn right on Geer Road, then left on Christoffersen Parkway. Turn right on Fosberg Road, left on Castleview Drive, and right on Bridgeport Court. Property will be on the left-hand side of the cul-de-sac.
Cross Street
Hedstrom
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Architectural Style
Traditional
Construction Materials
Stucco, Frame, Wood
Foundation
Slab
Roof
Composition
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
In Garage
Full Bathrooms
2
Bath Features
Tub w/Shower Over, Window
# of Fireplaces
1
Fireplace Features
Living Room, Gas Piped
Flooring
Carpet, Vinyl, Wood
Appliances
Hood Over Range, Dishwasher, Disposal, Microwave, Electric Cook Top, Free Standing Electric Range
Kitchen Features
Breakfast Area, Quartz Counter
Dining Room Features
Breakfast Nook, Dining/Family Combo, Space in Kitchen
Living Room Features
Great Room, View
Primary Bathroom Features
Shower Stall(s)
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public
Electric
220 Volts
Irrigation
None
Water Source
Public
Sewer
Sewer in Street
Parking Features
Detached, Garage Door Opener, Garage Facing Front
Garage Spaces
1.00
Carport Spaces
2.00
Lot Features
Cul-De-Sac, Garden
APN
072 012 047 000
Driveway/Sidewalks
Paved Sidewalk, Paved Driveway
Fencing
Wood
Horse Property
No
Zoning Description
R1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Turlock Unified
Middle or Junior School District
Turlock Unified
Senior High School District
Turlock Unified
Census Tract
39.07
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 503500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 556500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1204 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1704 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` = 1710716 OR `props-main`.`id` = 1701905 OR `props-main`.`id` = 1710339 OR `props-main`.`id` = 1710533 OR `props-main`.`id` = 1711046 OR `props-main`.`id` = 1711296 OR `props-main`.`id` = 1710477 OR `props-main`.`id` = 1710640 OR `props-main`.`id` = 1709756 OR `props-main`.`id` = 1703512 OR `props-main`.`id` = 1710737 OR `props-main`.`id` = 1711033 OR `props-main`.`id` = 1677473 OR `props-main`.`id` = 1707090 OR `props-main`.`id` = 1710290 OR `props-main`.`id` = 1711231 OR `props-main`.`id` = 1710871 OR `props-main`.`id` = 1709757 OR `props-main`.`id` = 1694952 OR `props-main`.`id` = 1694953 OR `props-main`.`id` = 1711003 OR `props-main`.`id` = 1711239 OR `props-main`.`id` = 1705977 OR `props-main`.`id` = 1697666 OR `props-main`.`id` = 1706065 OR `props-main`.`id` = 1702685 OR `props-main`.`id` = 1711294 OR `props-main`.`id` = 1706873 OR `props-main`.`id` = 1707054 OR `props-main`.`id` = 1704004 OR `props-main`.`id` = 1710657 OR `props-main`.`id` = 1676645 OR `props-main`.`id` = 1708249 OR `props-main`.`id` = 1705694 OR `props-main`.`id` = 1697637 OR `props-main`.`id` = 1708451 OR `props-main`.`id` = 1708510 OR `props-main`.`id` = 1710412 OR `props-main`.`id` = 1707980 OR `props-main`.`id` = 1710973 OR `props-main`.`id` = 1691726 OR `props-main`.`id` = 1699229 OR `props-main`.`id` = 1710846 OR `props-main`.`id` = 1705845 OR `props-main`.`id` = 1703135 OR `props-main`.`id` = 1709450 OR `props-main`.`id` = 1709469 OR `props-main`.`id` = 1704861 OR `props-main`.`id` = 1678680 OR `props-main`.`id` = 1705815 OR `props-main`.`id` = 1703425 OR `props-main`.`id` = 1711001 OR `props-main`.`id` = 1710559 OR `props-main`.`id` = 1707187 OR `props-main`.`id` = 1701116 OR `props-main`.`id` = 1705932 OR `props-main`.`id` = 1710986 OR `props-main`.`id` = 1703705 OR `props-main`.`id` = 1697608 OR `props-main`.`id` = 1690894 OR `props-main`.`id` = 1698127 OR `props-main`.`id` = 1709433 OR `props-main`.`id` = 1703055 OR `props-main`.`id` = 1704379 OR `props-main`.`id` = 280750 OR `props-main`.`id` = 1697927 OR `props-main`.`id` = 1690291 OR `props-main`.`id` = 1711002 OR `props-main`.`id` = 1701428 OR `props-main`.`id` = 1702679 OR `props-main`.`id` = 1703892 OR `props-main`.`id` = 1702988 OR `props-main`.`id` = 1706148 OR `props-main`.`id` = 1703421 OR `props-main`.`id` = 1701345 OR `props-main`.`id` = 1701214 OR `props-main`.`id` = 1690323)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225135499' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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();
2
Similar Properties
$514,950
3
2
1,637
0.14
2345 Tokay Ave
Turlock, CA 95380
$509,997
4
3
1,658
0.10
2352 Hidden Springs Ct
Turlock, CA 95382
Courtesy of Celeste Robles, HomeSmart PV & Associates IDX provided by Reliance Marketing
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.
