Beautifully maintained home on desirable corner lot. Home features 4 bedrooms with a flexible room downstairs, perfect for a home office or playroom! Enjoy multiple living spaces, including formal living and family rooms with an entertainment niche, and an open-concept kitchen with granite countertops, gas stove, center island, and spacious pantry. Outside, your private tropical retreat features a PebbleTec pool and spa with two tranquil waterfalls, surrounded by lush landscaping ideal for relaxing or entertaining guests. The home also includes a spacious 3-car garage for extra storage and easy, worry-free living. Located in a quiet, well-established neighborhood with convenient access to top rated schools, parks, and shopping.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached, Semi-Custom
Year Built
2004
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Unknown
Stories
2
Home Warranty
No
Directions to Property
Tornga to Atlantic
Cross Street
Tornga
County
San Joaquin
Special Listing Conditions
None
Main Level
Bedroom(s), Full Bath(s)
Construction Materials
Stucco, Frame
Foundation
Slab
Roof
Tile
Heating
Central
Cooling
Central
Laundry Features
Cabinets, Sink, Inside Room
Full Bathrooms
3
Bath Features
Shower Stall(s), Double Sinks, Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Family Room
Flooring
Carpet, Linoleum, Tile, Vinyl
Appliances
Gas Cook Top, Dishwasher, Disposal, Microwave
Room Type
Primary Bathroom, Baths Other, Primary Bedroom
Kitchen Features
Granite Counter, Island w/Sink, Kitchen/Family Combo, Tile Counter
Dining Room Features
Breakfast Nook, Dining/Family Combo
Living Room Features
Great Room
Primary Bedroom Features
Walk-In Closet
Primary Bathroom Features
Shower Stall(s), Double Sinks, Tub w/Shower Over, Walk-In Closet 2+
Pool
Yes
Pool Features
Built-In, On Lot, Pool/Spa Combo
Spa
No
ADU/2nd Unit
No
Utilities
Public, Sewer In & Connected
Electric
220 Volts in Laundry
Irrigation
Public District
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached, Garage Door Opener, Garage Facing Front
Garage Spaces
3.00
Lot Features
Corner, Street Lights, Landscape Back
APN
261 610 21
Topography
Level
Fencing
Back Yard
Horse Property
No
Road Responsibility
Public Maintained Road
Zoning Description
R1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
San Joaquin
Elementary School District
Ripon Unified
Middle or Junior School District
Ripon Unified
Senior High School District
Ripon Unified
Census Tract
50.03
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 783750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 866250 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) >= 2463 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2963 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` = 1692374 OR `props-main`.`id` = 1697569 OR `props-main`.`id` = 1697514 OR `props-main`.`id` = 1708050 OR `props-main`.`id` = 1711064 OR `props-main`.`id` = 1697395 OR `props-main`.`id` = 1710911 OR `props-main`.`id` = 1710267 OR `props-main`.`id` = 1690108 OR `props-main`.`id` = 1697544 OR `props-main`.`id` = 1710933 OR `props-main`.`id` = 1707868 OR `props-main`.`id` = 1702100 OR `props-main`.`id` = 1710752 OR `props-main`.`id` = 1710755 OR `props-main`.`id` = 1710756 OR `props-main`.`id` = 1689606 OR `props-main`.`id` = 1710848 OR `props-main`.`id` = 1708044 OR `props-main`.`id` = 1702586 OR `props-main`.`id` = 1699971 OR `props-main`.`id` = 1705923 OR `props-main`.`id` = 1711232 OR `props-main`.`id` = 1709883 OR `props-main`.`id` = 1694687 OR `props-main`.`id` = 1710685)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226012605' 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();
0
Courtesy of Laurence Giuntoli, 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.
