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) >= 532000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 588000 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` = 1694200 OR `props-main`.`id` = 1692681 OR `props-main`.`id` = 1695927 OR `props-main`.`id` = 1695523 OR `props-main`.`id` = 1692711 OR `props-main`.`id` = 1693076 OR `props-main`.`id` = 1693449 OR `props-main`.`id` = 1693375 OR `props-main`.`id` = 1692947 OR `props-main`.`id` = 1692778 OR `props-main`.`id` = 1692951 OR `props-main`.`id` = 1693285 OR `props-main`.`id` = 1670931 OR `props-main`.`id` = 1694686 OR `props-main`.`id` = 1695464 OR `props-main`.`id` = 1677473 OR `props-main`.`id` = 1693341 OR `props-main`.`id` = 1692614 OR `props-main`.`id` = 1679631 OR `props-main`.`id` = 1694952 OR `props-main`.`id` = 1694953 OR `props-main`.`id` = 1692832 OR `props-main`.`id` = 1692767 OR `props-main`.`id` = 1696052 OR `props-main`.`id` = 1690685 OR `props-main`.`id` = 1697666 OR `props-main`.`id` = 1689736 OR `props-main`.`id` = 1693210 OR `props-main`.`id` = 1694889 OR `props-main`.`id` = 1694467 OR `props-main`.`id` = 1689988 OR `props-main`.`id` = 1697650 OR `props-main`.`id` = 1697551 OR `props-main`.`id` = 1692244 OR `props-main`.`id` = 1697568 OR `props-main`.`id` = 1693315 OR `props-main`.`id` = 1691976 OR `props-main`.`id` = 1697438 OR `props-main`.`id` = 1689850 OR `props-main`.`id` = 1676645 OR `props-main`.`id` = 1697610 OR `props-main`.`id` = 1697637 OR `props-main`.`id` = 1695780 OR `props-main`.`id` = 1692852 OR `props-main`.`id` = 1690306 OR `props-main`.`id` = 1637747 OR `props-main`.`id` = 1697722 OR `props-main`.`id` = 1697713 OR `props-main`.`id` = 1693050 OR `props-main`.`id` = 1689294 OR `props-main`.`id` = 1687968 OR `props-main`.`id` = 1691726 OR `props-main`.`id` = 1667959 OR `props-main`.`id` = 1687391 OR `props-main`.`id` = 1697099 OR `props-main`.`id` = 1698124 OR `props-main`.`id` = 1692494 OR `props-main`.`id` = 1697365 OR `props-main`.`id` = 1678680 OR `props-main`.`id` = 1697978 OR `props-main`.`id` = 1682050 OR `props-main`.`id` = 1691044 OR `props-main`.`id` = 1683457 OR `props-main`.`id` = 1694464 OR `props-main`.`id` = 1697485 OR `props-main`.`id` = 1698015 OR `props-main`.`id` = 1693132 OR `props-main`.`id` = 1649903 OR `props-main`.`id` = 1685439 OR `props-main`.`id` = 1697608 OR `props-main`.`id` = 1690894 OR `props-main`.`id` = 1698127 OR `props-main`.`id` = 1694322 OR `props-main`.`id` = 1684669 OR `props-main`.`id` = 1680299 OR `props-main`.`id` = 1680263 OR `props-main`.`id` = 1695921 OR `props-main`.`id` = 280750 OR `props-main`.`id` = 1697927 OR `props-main`.`id` = 1693820 OR `props-main`.`id` = 1690291 OR `props-main`.`id` = 1687330 OR `props-main`.`id` = 1698116 OR `props-main`.`id` = 1693609 OR `props-main`.`id` = 1696020 OR `props-main`.`id` = 1685488 OR `props-main`.`id` = 1697472 OR `props-main`.`id` = 1679249 OR `props-main`.`id` = 1693701 OR `props-main`.`id` = 1692055 OR `props-main`.`id` = 1697640 OR `props-main`.`id` = 1694854 OR `props-main`.`id` = 1694650 OR `props-main`.`id` = 1690629 OR `props-main`.`id` = 1681350 OR `props-main`.`id` = 1697664 OR `props-main`.`id` = 1690779 OR `props-main`.`id` = 1690323 OR `props-main`.`id` = 1695720 OR `props-main`.`id` = 1671067 OR `props-main`.`id` = 1678108 OR `props-main`.`id` = 1688379)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225135499' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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();
3
Similar Properties
$549,000
3
2
1,425
0.18
2226 typhoon Ct
Turlock, CA 95380
$545,000
4
2
1,636
0.25
2700 Oxford Ave
Turlock, CA 95382
$535,000
3
2
1,326
0.14
1921 Carleton Dr
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.
