London Properties Turlock Real Estate

3403 Freitas Ct

Turlock, CA 95382

Copy Link Get Directions

Photo Gallery

$824,900

4 bd

4 ba

2,866 sq ft

0.25 acre

3403 Freitas Ct

Turlock, CA 95382

Get Directions

Listed On: 06/11/2026

Status: Active

Listing Number: 226073039 (Metrolist MLS)

Open House

Sat, Jun 13
12:00pm - 2:00pm
Courtesy of Century 21 Select Real Estate

Schedule a Tour

Contact Info

Presented By:

London Properties, Ltd. 559.436.4071 Email Agent

Property Description

Rarely does a home offer this much flexibility and outdoor enjoyment in one package. Located on a quiet cul-de-sac, this custom home features a highly sought-after private guest suite with its own bedroom, full bath, living and dining area, and wet bar (potential for full kitchen) perfect for multi-generational living, long-term guests, private retreat or second primary bedroom. The main living spaces are filled with natural light and enhanced by soaring ceilings and an open floor plan designed for gathering. The kitchen is the centerpiece of the home, offering granite countertops, a large island with prep sink, and plenty of room for cooking and entertaining. Step outside to your own backyard oasis on an approximately quarter-acre lot featuring a pool, spa, deck, fruit trees, storage shed, and garden space. An oversized three-car garage with tandem parking provides abundant room for vehicles, storage, or hobbies. An incredible combination of space, function, and lifestyle amenities, this is a home designed to grow with your needs.

Property Type

Residential

Property Subtype 1

Single Family Residence

Subtype Description

Custom

Year Built

2001

Year Built Source

Assessor Auto-Fill

Remodeled/Updated

Unknown

Stories

Levels

Two

Home Warranty

Directions to Property

From Hwy 99, East on Monte Vista, North on Colorado, left on Potomac, and left on Freitas.

Cross Street

Potomac

County

Stanislaus

Special Listing Conditions

None

Main Level

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

Architectural Style

Contemporary

Construction Materials

Stucco, Frame

Foundation

Slab

Roof

Tile

Heating

Central, Fireplace(s)

Cooling

Ceiling Fan(s), Central

Laundry Features

Cabinets, Sink, Upper Floor, Inside Room

Property Faces

North

Other Structures

Pergola, Shed(s)

Full Bathrooms

Half Bathrooms

Bath Features

Tile, Tub w/Shower Over

# of Fireplaces

Fireplace Features

Raised Hearth, Family Room, Gas Log

Flooring

Laminate, Tile, Wood

Appliances

Built-In Gas Range, Dishwasher, Disposal, Microwave

Room Type

Bonus Room, Primary Bedrooms 2+, Possible Guest, Family Room, Game Room, Guest Quarters, In Law Apartment, Kitchen, Laundry, Living Room

Kitchen Features

Pantry Cabinet, Granite Counter, Island w/Sink, Kitchen/Family Combo

Dining Room Features

Dining Bar, Dining/Family Combo, Space in Kitchen, Dining/Living Combo, Formal Area

Living Room Features

Cathedral/Vaulted, Other

Family Room Features

Sunken

Primary Bedroom Features

Walk-In Closet

Primary Bathroom Features

Double Sinks, Soaking Tub, Tile, Window

Upper Level

Bedroom(s), Primary Bedroom, Full Bath(s)

Patio And Porch Features

Front Porch, Back Porch

Pool

Yes

Pool Features

Built-In, On Lot, Pool/Spa Combo

Spa

Yes

Spa Features

Spa/Hot Tub Built-In

ADU/2nd Unit

Utilities

Public, Electric, Sewer In & Connected, Solar

Electric

220 Volts in Laundry

Irrigation

Public District

Water Source

Public

Sewer

Public Sewer

Parking Features

Attached, Drive Thru Garage, Garage Door Opener, Garage Facing Front

Garage Spaces

3.00

Lot Features

Auto Sprinkler F&R, Cul-De-Sac, Landscape Back, Landscape Front

APN

072 052 085 000

Land Use

Residential

Topography

Level

Driveway/Sidewalks

Sidewalk/Curb/Gutter

Fencing

Back Yard, Chain Link, Wood

Horse Property

Road Surface Type

Paved

Zoning Description

List AOR

MetroList Services, Inc.

Association

Senior Community

School District (County)

Stanislaus

Elementary School District

Turlock Unified

Middle or Junior School District

Turlock Unified

Senior High School District

Turlock Unified

Census Tract

36.09

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 783655 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 866145 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2616 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3116 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` = 1717269 OR `props-main`.`id` = 1718270 OR `props-main`.`id` = 1734887 OR `props-main`.`id` = 1734886 OR `props-main`.`id` = 1714769 OR `props-main`.`id` = 1714390 OR `props-main`.`id` = 1723535 OR `props-main`.`id` = 1723541 OR `props-main`.`id` = 1727033 OR `props-main`.`id` = 1727086 OR `props-main`.`id` = 1694953 OR `props-main`.`id` = 1714724 OR `props-main`.`id` = 1736165 OR `props-main`.`id` = 1734028 OR `props-main`.`id` = 1715983 OR `props-main`.`id` = 1727795 OR `props-main`.`id` = 1713447 OR `props-main`.`id` = 1727796 OR `props-main`.`id` = 1729826 OR `props-main`.`id` = 1706873 OR `props-main`.`id` = 1726033 OR `props-main`.`id` = 1704004 OR `props-main`.`id` = 1720269 OR `props-main`.`id` = 1723094 OR `props-main`.`id` = 1736186 OR `props-main`.`id` = 1714406 OR `props-main`.`id` = 1733145 OR `props-main`.`id` = 1725286 OR `props-main`.`id` = 1716293 OR `props-main`.`id` = 1723050 OR `props-main`.`id` = 1722083 OR `props-main`.`id` = 1733596 OR `props-main`.`id` = 1729195 OR `props-main`.`id` = 1733594 OR `props-main`.`id` = 1708451 OR `props-main`.`id` = 1714183 OR `props-main`.`id` = 1725607 OR `props-main`.`id` = 1724941 OR `props-main`.`id` = 1729005 OR `props-main`.`id` = 1726119 OR `props-main`.`id` = 1733142 OR `props-main`.`id` = 1727447 OR `props-main`.`id` = 1727098 OR `props-main`.`id` = 1721556 OR `props-main`.`id` = 1727123 OR `props-main`.`id` = 1723935 OR `props-main`.`id` = 1714325 OR `props-main`.`id` = 1728047 OR `props-main`.`id` = 1726034 OR `props-main`.`id` = 1714824 OR `props-main`.`id` = 1726062 OR `props-main`.`id` = 1730327 OR `props-main`.`id` = 1720916 OR `props-main`.`id` = 1723704 OR `props-main`.`id` = 1723720 OR `props-main`.`id` = 1734845 OR `props-main`.`id` = 1736589 OR `props-main`.`id` = 280750 OR `props-main`.`id` = 1730275 OR `props-main`.`id` = 1729364 OR `props-main`.`id` = 1725739 OR `props-main`.`id` = 1725734 OR `props-main`.`id` = 1728715 OR `props-main`.`id` = 1724089 OR `props-main`.`id` = 1724880 OR `props-main`.`id` = 1723211 OR `props-main`.`id` = 1723593 OR `props-main`.`id` = 1729179 OR `props-main`.`id` = 1706148 OR `props-main`.`id` = 1734885 OR `props-main`.`id` = 1726554 OR `props-main`.`id` = 1721889 OR `props-main`.`id` = 1729362 OR `props-main`.`id` = 1736604)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226073039' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-11' 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

$813,500

5
4
2,632
0.31

2970 E Tuolumne Rd

Turlock, CA 95382

Courtesy of Nellie Lazar, Century 21 Select Real Estate
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

3403 Freitas Ct

Turlock, CA 95382

Photo Gallery

$824,900

3403 Freitas Ct

Turlock, CA 95382

Open House

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$813,500

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

3403 Freitas Ct

Turlock, CA 95382

Photo Gallery

$824,900

3403 Freitas Ct

Turlock, CA 95382

Open House

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$813,500

Loading...

Saving...

Deleting...

Searching...