A single story home tucked away in a court and located in one of Ripon's most desired neighborhoods, you won't want to miss this one. This beautifully maintained home has 4 bedrooms, 2.5 bathrooms, a spacious living area, an office and an entertainers dream of a yard. It is perfect for entertaining, whether it is swimming in the pool or relaxing under the covered patio, you will feel as if you are at a retreat. Step into a home that feels just right-welcoming, peaceful, and ready to be yours.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
2004
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Other-Rmks 0-5YR
Stories
1
Home Warranty
No
Directions to Property
N. Ripon Rd to W. Colony to Atlantic to Haller Ct
Cross Street
Atlantic
County
San Joaquin
Special Listing Conditions
None
Main Level
Bedroom(s), Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Construction Materials
Stucco, Wood
Foundation
Slab
Roof
Tile
Heating
Central
Cooling
Ceiling Fan(s), Central, Whole House Fan
Laundry Features
Cabinets, Inside Room
Full Bathrooms
2
Half Bathrooms
1
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Family Room
Flooring
Carpet, Vinyl, Wood, Other
Appliances
Built-In Gas Range, Hood Over Range, Dishwasher, Disposal
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 831250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 918750 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) >= 2216 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2716 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` = 1695506 OR `props-main`.`id` = 1692374 OR `props-main`.`id` = 1695764 OR `props-main`.`id` = 1698023 OR `props-main`.`id` = 1697569 OR `props-main`.`id` = 1697514 OR `props-main`.`id` = 1690023 OR `props-main`.`id` = 1697838 OR `props-main`.`id` = 1697395 OR `props-main`.`id` = 1681166 OR `props-main`.`id` = 1690108 OR `props-main`.`id` = 1697544 OR `props-main`.`id` = 1699886 OR `props-main`.`id` = 1699891 OR `props-main`.`id` = 1699892 OR `props-main`.`id` = 1689606 OR `props-main`.`id` = 1694400 OR `props-main`.`id` = 1693948 OR `props-main`.`id` = 1697429 OR `props-main`.`id` = 1699528 OR `props-main`.`id` = 1699971 OR `props-main`.`id` = 1698974 OR `props-main`.`id` = 1693949 OR `props-main`.`id` = 1694687 OR `props-main`.`id` = 1692140 OR `props-main`.`id` = 1699799)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225100357' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-27' 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 Tara Wagner, PMZ Real Estate 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.
