Where Comfort, Community, and Convenience Meet - Spacious 4 bed, 3 bath home with over 1800 sq ft. in a highly desirable gated community, close to shopping and highway 99. Paid-for solar keeps energy bills low, while tree-lined sidewalks, charming parks, and street-lit paths make the neighborhood shine.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2021
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$243
Price Per Acre
$3,267,974
Days On Market
21
Cumulative Days On Market
21
County
Merced
REO / Bank Owned
No
Cross Street Address
Bell
Directions
From hwy 99 North, take the Applegate Road exit. Turn right on Sycamore, right on Applegate, right on Bell Dr., right on Truckee Dr. Contact agent for gate access.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Primary Bedroom Level
Main
Flooring
Carpet, Tile
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
Yes
Solar Type
Owned
Garage Type
Attached
Garage Spaces
2
APN
001 244 005 000
Zoning
residential
Association / Park Amenities
Green Area, Playground, Gated Community
HOA Dues
95.00
Frequency
monthly
School District
Atwater
School Type 1
High School
School Name 1
Buhach Colony
School Type 2
Junior High School
School Name 2
Mitchell SR
School Type 3
Grade School
School Name 3
Thomas Olaetan
72871
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 427500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 472500 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) >= 1604 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2104 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` = 1622894 OR `props-main`.`id` = 1678715 OR `props-main`.`id` = 1686457 OR `props-main`.`id` = 1686562 OR `props-main`.`id` = 1678728 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 1680711 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 1682226 OR `props-main`.`id` = 1687293 OR `props-main`.`id` = 1687304 OR `props-main`.`id` = 1689533 OR `props-main`.`id` = 1683888 OR `props-main`.`id` = 1686909 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1681613 OR `props-main`.`id` = 1686565 OR `props-main`.`id` = 1681501 OR `props-main`.`id` = 1627752 OR `props-main`.`id` = 1651865 OR `props-main`.`id` = 1688038 OR `props-main`.`id` = 1674298 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1683145 OR `props-main`.`id` = 1682973 OR `props-main`.`id` = 1685928 OR `props-main`.`id` = 1686760 OR `props-main`.`id` = 1686268 OR `props-main`.`id` = 1686740 OR `props-main`.`id` = 1691221 OR `props-main`.`id` = 1680693 OR `props-main`.`id` = 1680717 OR `props-main`.`id` = 1680723 OR `props-main`.`id` = 1688629 OR `props-main`.`id` = 1688587 OR `props-main`.`id` = 1688598 OR `props-main`.`id` = 1689674 OR `props-main`.`id` = 1689667 OR `props-main`.`id` = 1685842 OR `props-main`.`id` = 1688930 OR `props-main`.`id` = 1690040 OR `props-main`.`id` = 1644663 OR `props-main`.`id` = 1642699 OR `props-main`.`id` = 1622885 OR `props-main`.`id` = 1663976 OR `props-main`.`id` = 1682782 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1690886 OR `props-main`.`id` = 1668924 OR `props-main`.`id` = 1686574 OR `props-main`.`id` = 1683927 OR `props-main`.`id` = 1677622 OR `props-main`.`id` = 1686912 OR `props-main`.`id` = 1677617 OR `props-main`.`id` = 1677620 OR `props-main`.`id` = 1651866 OR `props-main`.`id` = 1651867 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1690818 OR `props-main`.`id` = 1690813 OR `props-main`.`id` = 1690831 OR `props-main`.`id` = 1686888 OR `props-main`.`id` = 1686925 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1688966 OR `props-main`.`id` = 1688440 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1690054 OR `props-main`.`id` = 1688767 OR `props-main`.`id` = 1686506 OR `props-main`.`id` = 1689672 OR `props-main`.`id` = 1688905 OR `props-main`.`id` = 1688907 OR `props-main`.`id` = 1656550 OR `props-main`.`id` = 1656714 OR `props-main`.`id` = 1656726 OR `props-main`.`id` = 1672924 OR `props-main`.`id` = 258606 OR `props-main`.`id` = 1687328 OR `props-main`.`id` = 1687326 OR `props-main`.`id` = 155874)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637983' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-26' 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 Stacy Tennesen, Century 21 Select Real Estate - Stacy.tennesen@c21selectgroup.com Last modified 2 days ago
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.
