Your Dream Home in a 55+ Community awaits you! This 1/2 acre lot has it all. Spacious living and is designed for comfort, beauty, and so many possibilities. Community Perks: Club house shows a calendar full of social activities. Immaculate walking paths and serene outdoor spaces. Conveniently close to shops, dining and medical facilities.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Planned Unit Develop
Year Built
2007
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Pets Allowed
Yes, Cats OK, Dogs OK
Home Warranty
No
Directions to Property
Del Web Blvd off of Union. First left on Bellchase, first left on Holly Berry Cy.
Cross Street
Bellchase
County
San Joaquin
Special Listing Conditions
None
Main Level
Bedroom(s), Dining Room, Family Room, Primary Bedroom, Full Bath(s), Partial Bath(s), Garage, Kitchen, Street Entrance
Garage Door Opener, Garage Facing Front, Interior Access
Garage Spaces
3.00
Lot Features
Auto Sprinkler F&R, Court, Curb(s)/Gutter(s), Shape Regular, Street Lights, Landscape Back, Landscape Front
APN
204 150 06
Horse Property
No
Zoning Description
R-L
List AOR
MetroList Services, Inc.
Association
Yes
Association Mandatory
Yes
Association Fee
200
Association Fee Frequency
Monthly
Association Fee Includes
MaintenanceGrounds, Pool
Association Features
Pool, Clubhouse, Exercise Room, Game Court Exterior, Spa/Hot Tub, Gym, Park
Senior Community
Yes
School District (County)
San Joaquin
Elementary School District
Manteca Unified
Middle or Junior School District
Manteca Unified
Senior High School District
Manteca Unified
Census Tract
51.35
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 806550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 891450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2384 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2884 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` = 1706854 OR `props-main`.`id` = 1717131 OR `props-main`.`id` = 1716343 OR `props-main`.`id` = 1727275 OR `props-main`.`id` = 1715968 OR `props-main`.`id` = 1709827 OR `props-main`.`id` = 1722284 OR `props-main`.`id` = 1727754 OR `props-main`.`id` = 1727599 OR `props-main`.`id` = 1721664 OR `props-main`.`id` = 1711224 OR `props-main`.`id` = 1728432 OR `props-main`.`id` = 1728623 OR `props-main`.`id` = 1722855 OR `props-main`.`id` = 1722851 OR `props-main`.`id` = 1721079 OR `props-main`.`id` = 1725532 OR `props-main`.`id` = 1706808 OR `props-main`.`id` = 1721119 OR `props-main`.`id` = 1722677 OR `props-main`.`id` = 1728125 OR `props-main`.`id` = 1728314 OR `props-main`.`id` = 1722106 OR `props-main`.`id` = 1603454 OR `props-main`.`id` = 1727635 OR `props-main`.`id` = 1726003 OR `props-main`.`id` = 1726229 OR `props-main`.`id` = 1722526 OR `props-main`.`id` = 1726160 OR `props-main`.`id` = 1727638 OR `props-main`.`id` = 1727753 OR `props-main`.`id` = 1720343 OR `props-main`.`id` = 1716687 OR `props-main`.`id` = 1721579 OR `props-main`.`id` = 1727122 OR `props-main`.`id` = 1714488 OR `props-main`.`id` = 1713767 OR `props-main`.`id` = 1706036 OR `props-main`.`id` = 1713166 OR `props-main`.`id` = 1717099 OR `props-main`.`id` = 1719133 OR `props-main`.`id` = 1702640 OR `props-main`.`id` = 1716857 OR `props-main`.`id` = 1716205 OR `props-main`.`id` = 1722028 OR `props-main`.`id` = 1726687 OR `props-main`.`id` = 1718288 OR `props-main`.`id` = 1718287 OR `props-main`.`id` = 1726678 OR `props-main`.`id` = 1715644 OR `props-main`.`id` = 1717768 OR `props-main`.`id` = 1700111 OR `props-main`.`id` = 1727115 OR `props-main`.`id` = 1719796 OR `props-main`.`id` = 1727032 OR `props-main`.`id` = 1724556 OR `props-main`.`id` = 1725438 OR `props-main`.`id` = 1723540 OR `props-main`.`id` = 1721468 OR `props-main`.`id` = 1722241 OR `props-main`.`id` = 1721528 OR `props-main`.`id` = 1714310 OR `props-main`.`id` = 1719580 OR `props-main`.`id` = 1719106 OR `props-main`.`id` = 1724100 OR `props-main`.`id` = 1705953 OR `props-main`.`id` = 1727276 OR `props-main`.`id` = 1713619 OR `props-main`.`id` = 1726838 OR `props-main`.`id` = 1714166 OR `props-main`.`id` = 1718324 OR `props-main`.`id` = 1721821 OR `props-main`.`id` = 1724486 OR `props-main`.`id` = 1726990 OR `props-main`.`id` = 1720745 OR `props-main`.`id` = 1724815 OR `props-main`.`id` = 1726952 OR `props-main`.`id` = 1727245 OR `props-main`.`id` = 1727081 OR `props-main`.`id` = 1728679 OR `props-main`.`id` = 1727527 OR `props-main`.`id` = 1726539 OR `props-main`.`id` = 1727096 OR `props-main`.`id` = 1726973 OR `props-main`.`id` = 1726007 OR `props-main`.`id` = 1710132 OR `props-main`.`id` = 1725608 OR `props-main`.`id` = 1720260 OR `props-main`.`id` = 1721808 OR `props-main`.`id` = 1717510 OR `props-main`.`id` = 1719231 OR `props-main`.`id` = 1685406 OR `props-main`.`id` = 1722330 OR `props-main`.`id` = 1728118 OR `props-main`.`id` = 1701269 OR `props-main`.`id` = 1723419 OR `props-main`.`id` = 1722084 OR `props-main`.`id` = 1719147 OR `props-main`.`id` = 1713497 OR `props-main`.`id` = 1723141 OR `props-main`.`id` = 1726292 OR `props-main`.`id` = 1701940)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226064481' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-23' 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 Emily Lavery-Burns, Cornerstone Real Estate Group 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.
