---
listing_id: ME226093597
status: Active
price: 495000
beds: 3
baths_full: 2
baths_half: 0
sqft_living: 1485
sqft_lot: 6826
lot_acres: 
year_built: 
property_type: Residential
property_subtype: Single Family Residence
address: "5718 Tam O Shanter Dr"
city: Stockton
state: CA
zip: 95210
county: "San Joaquin County"
lat: 38.0079586
lng: -121.2942959
days_on_market: 0
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Jose Ruiz"
list_office: "3Sixty Real Estate"
list_agent_phone: "(209) 696-6497"
list_agent_license: 02007158
mls_source: REMTRO
modified: 2026-07-24
transaction_type: buy
---

Home | San Joaquin County | Stockton | 95210 | 5718 Tam O Shanter Dr

5718 Tam O Shanter Dr, Stockton, CA 95210

MLS: ME226093597 | Status: Active | Price: $495,000
Beds/Baths: 3 / 2
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
3 2 1,485 6,826

Remarks

5718 Tam O'Shanter Court Welcome home to this beautifully updated single story offering the perfect blend of modern finishes and everyday comfort. From the moment you arrive, you'll appreciate the fresh curb appeal, inviting entry, and thoughtfully renovated interior. Inside, you'll find bright, open living spaces with luxury plank flooring, updated lighting, and a clean, contemporary feel throughout. Both bathrooms have been beautifully remodeled with designer-inspired tile, modern vanities, and sleek black and brushed gold fixtures that give the home a fresh, upscale look. The kitchen features rich wood cabinetry, black countertops, stainless steel appliances, and a functional layout with plenty of storage. Spacious bedrooms provide flexibility for family, guests, or a home office. Step outside to a generous backyard with mature shade and fruit trees, a large patio for entertaining, and plenty of room to garden, play, or create your dream outdoor retreat. The oversized lot offers endless possibilities while still providing privacy. Located in an established neighborhood close to schools, parks, shopping, and commuter routes, this move-in ready home combines stylish updates with the space and flexibility buyers are looking for. Come see why 5718 Tam O'Shanter f

MLS Listing Information

Field Value
MLS # ME226093597
MLS Source MetroList Services, Inc.
Days on Site 0

Features

Interior Features

Feature Details
Bedrooms Remodeled
Bathrooms Updated Bath(s)
Kitchen Countertop - Granite, Updated
Dining Room Formal Area
Fireplace Brick, Gas Log
Laundry 220 Volt Outlet, In Garage
Cooling Ceiling Fan, Central Forced Air
Heating Central Forced Air

Exterior Features

Feature Details
Roof Composition
Foundation Slab, Concrete Perimeter and Slab
Pool Pool - No

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Garage: 2 Car(s)
Elementary District Stockton Unified
High School District Stockton Unified
Sewer Public Sewer
Water Public
Zoning Res

Contact Information

Jose Ruiz
3Sixty Real Estate
License #: 02007158
Phone: (209) 696-6497

Property Units

# Buildings # Leased Units # Total Units
0

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
District Special Education School public K-12 0.39 mi N/A
Rio Calaveras Elementary School public K-8 0.71 mi 6
George W. Bush Elementary School public K-8 0.97 mi 6
Maxine Hong Kingston Elementary School public K-8 1.01 mi 3
Adams Elementary School public K-8 1.14 mi 2
Pulliam Elementary School public K-8 1.17 mi 3
Peyton Elementary & Middle Schools public K-8 1.19 mi 8
Cesar Chavez High School public 9-12 1.33 mi 3
Clairmont Elementary School public K-6 1.33 mi 5
Parklane Elementary School public K-6 1.38 mi 2
Middle College High School public 9-12 1.57 mi 10
Lincoln Elementary School public K-6 1.61 mi 6
Cleveland Elementary School public K-8 1.79 mi 7
Sutherland Elementary School public K-6 1.90 mi 3
Harrison Elementary School public K-8 1.92 mi 3
Kennedy Elementary School public K-8 1.95 mi 2
Westwood Elementary School public K-6 1.98 mi 5
Ansel Adams School public K-6 2.02 mi 7
Wilson Elementary School public K-8 2.03 mi 4
Ronald E. McNair High School public 9-12 2.11 mi 3

Nearby Homes

Address Price Beds Baths Sq Ft Status
316 Don Carlos Ave $439,999 3 2 1,486 Active
1408 W Benjamin Holt Dr $429,999 3 1 1,138 Active
3026 Mt Hoffman Ct $579,500 4 2/1 2,816 Active
9213 Tam O Shanter Dr $445,000 4 2 1,451 Active

Disclosures

©2026 MetroList Services, Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MetroList Services, Inc.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of July 24, 2026. For the most current information, please contact Jose Ruiz, (209) 696-6497.