Please provide the following information and Tiffany Wilson will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.3brosmom-realestate.com/agent/16607/tiffany-wilson/property/link/metrolist/225124112/1675-Almador-Ter/Atwater/https://www.3brosmom-realestate.com/images/props/metrolist/full/225124112.jpgLondon Properties Atwater Real Estate | 1675 Almador Ter
First-Time Buyer OR Downsizer's Dream! Looking for a cozy place in Merced's desirable Atwater community? This 3-Bedroom Beauty is waiting for YOU! Close to Shopping + Great Schools Quick Highway Access to Yosemite National Park Perfect for First-Time Buyers OR Downsizers This gem WON'T last long! Call/Text TODAY for your private tour (209) 338-7442 Listing proudly presented by: Samantha Cuddy Compass DRE #02057586
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Ranchette/Country
Year Built
1968
Year Built Source
Assessor Agent-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bed 0-5YR
Stories
1
Home Warranty
No
Directions to Property
From Shaffer, right on E Clinton Avenue, left on Almador Terrace
Cross Street
East Holly Avenue
County
Merced
Special Listing Conditions
Offer As Is
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Architectural Style
Ranch
Construction Materials
Stucco, Wood
Foundation
Raised
Roof
Composition
Heating
Central
Laundry Features
Cabinets, Ground Floor, Hookups Only, In Garage
Other Structures
Shed(s), Storage
Full Bathrooms
2
Bath Features
Shower Stall(s), Tub w/Shower Over, Window
# of Fireplaces
1
Fireplace Features
Den
Flooring
Carpet, Linoleum, Tile, Wood
Appliances
Disposal, Electric Water Heater, Free Standing Gas Oven
Kitchen Features
Breakfast Area
Dining Room Features
Space in Kitchen
Living Room Features
Great Room
Family Room Features
Cathedral/Vaulted
Patio And Porch Features
Back Porch
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public
Electric
220 Volts
Irrigation
Public District
Water Source
Public
Sewer
Public Sewer
Parking Features
Private, Attached, Enclosed, Garage Door Opener
Garage Spaces
2.00
Lot Features
Curb(s)/Gutter(s), Shape Regular, Storm Drain, Street Lights
APN
004 025 016 000
Horse Property
No
Zoning Description
RES
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Merced
Elementary School District
Atwater Elementary
Middle or Junior School District
Merced City
Senior High School District
Merced Union High
72871
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 345800 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 382200 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1114 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1614 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` = 1674115 OR `props-main`.`id` = 1674068 OR `props-main`.`id` = 1078072 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 1688291 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1687278 OR `props-main`.`id` = 1687269 OR `props-main`.`id` = 1677931 OR `props-main`.`id` = 1684475 OR `props-main`.`id` = 1684473 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1688404 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687248 OR `props-main`.`id` = 1681454 OR `props-main`.`id` = 1687267 OR `props-main`.`id` = 1680386 OR `props-main`.`id` = 1680392 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1622894 OR `props-main`.`id` = 1678715 OR `props-main`.`id` = 1686457 OR `props-main`.`id` = 1686562 OR `props-main`.`id` = 1679715 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1678728 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 1675208 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 1688612 OR `props-main`.`id` = 1688631 OR `props-main`.`id` = 912425 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` = 758993 OR `props-main`.`id` = 1687293 OR `props-main`.`id` = 1687304 OR `props-main`.`id` = 1685510 OR `props-main`.`id` = 1689533 OR `props-main`.`id` = 1683888 OR `props-main`.`id` = 1686909 OR `props-main`.`id` = 1685091 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1681613 OR `props-main`.`id` = 1686565 OR `props-main`.`id` = 1681501 OR `props-main`.`id` = 1639779 OR `props-main`.`id` = 1675140 OR `props-main`.`id` = 1627752 OR `props-main`.`id` = 1651865 OR `props-main`.`id` = 1679233 OR `props-main`.`id` = 1688038 OR `props-main`.`id` = 1674298 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1676559 OR `props-main`.`id` = 1682532 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1684138 OR `props-main`.`id` = 1683145 OR `props-main`.`id` = 1682973 OR `props-main`.`id` = 1685928 OR `props-main`.`id` = 1673216 OR `props-main`.`id` = 1673221 OR `props-main`.`id` = 1686760 OR `props-main`.`id` = 1683616 OR `props-main`.`id` = 1686268 OR `props-main`.`id` = 1686740 OR `props-main`.`id` = 1680693 OR `props-main`.`id` = 1680717 OR `props-main`.`id` = 1680723 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 911713 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` = 1644663 OR `props-main`.`id` = 1642699 OR `props-main`.`id` = 1622885 OR `props-main`.`id` = 1663976 OR `props-main`.`id` = 1684031 OR `props-main`.`id` = 1682782 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1683840 OR `props-main`.`id` = 1668924 OR `props-main`.`id` = 1686574 OR `props-main`.`id` = 1683927 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1677622 OR `props-main`.`id` = 1686912 OR `props-main`.`id` = 1677617 OR `props-main`.`id` = 1677620 OR `props-main`.`id` = 1683304 OR `props-main`.`id` = 1651866 OR `props-main`.`id` = 1651867 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1687151 OR `props-main`.`id` = 1686888 OR `props-main`.`id` = 1686925 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1688966 OR `props-main`.`id` = 1688440 OR `props-main`.`id` = 1667834 OR `props-main`.`id` = 1677069 OR `props-main`.`id` = 1688767 OR `props-main`.`id` = 1688816 OR `props-main`.`id` = 1653182 OR `props-main`.`id` = 1686506 OR `props-main`.`id` = 1689672 OR `props-main`.`id` = 1675292 OR `props-main`.`id` = 1675274 OR `props-main`.`id` = 1675278 OR `props-main`.`id` = 1672924 OR `props-main`.`id` = 1678627 OR `props-main`.`id` = 1678617 OR `props-main`.`id` = 1688132 OR `props-main`.`id` = 1684436 OR `props-main`.`id` = 1684479 OR `props-main`.`id` = 1683926 OR `props-main`.`id` = 1683950 OR `props-main`.`id` = 342762)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225124112' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-12' 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();
1
Similar Properties
$375,000
3
2
1,425
0.25
134 E Fir Ave
Atwater, CA 95301
Courtesy of Samantha Cuddy, Compass 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.
