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/fresno/634493/1500-Marguerite-St/Atwater/https://www.3brosmom-realestate.com/images/props/fresno/full/634493.jpgLondon Properties Atwater Real Estate | 1500 Marguerite St
Rare Opportunity in Atwater - Two Updated Homes on One Spacious Lot! This versatile property features a large, fully fenced lot with a beautifully updated main residence and a separate ADUideal for multi-generational living or rental income. The main home offers 3 bedrooms and 2 bathrooms, while the ADU includes 1 bedroom and 1 bathroom. Both homes feature stunning hardwood flooring throughout, granite countertops, and stainless steel appliances in the kitchens. Bathrooms are updated with dual sinks and shower-over-tub combinations for added comfort. Ceiling fans in each bedroom provide year-round comfort. Shower stall in ADU. With ample outdoor space and privacy, this property is perfect for those looking to live in one home and rent out the other! Don't miss out on this unique income-generating opportunity in Atwater!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1949
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$371
Price Per Acre
$2,205,115
Days On Market
57
Cumulative Days On Market
57
County
Merced
REO / Bank Owned
No
Cross Street Address
Mitchell Ave
Directions
N Winton Way to Mitchell Ave to Marguerite St.
Heating & Cooling
Ductless or Split
Laundry
Inside, In Closet
Roofing
Composition
Foundation
Wood Subfloor
Primary Bedroom Level
Lower
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
APN
001 073 004
School District
Merced
School Type 1
High School
School Name 1
Merced
School Type 2
Junior High School
School Name 2
Merced
School Type 3
Grade School
School Name 3
Merced
72871
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 401375 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 443625 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) >= 889 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1389 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` = 1676250 OR `props-main`.`id` = 1676266 OR `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` = 1675208 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 1674113 OR `props-main`.`id` = 1674316 OR `props-main`.`id` = 1680711 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 1682226 OR `props-main`.`id` = 1684190 OR `props-main`.`id` = 1684681 OR `props-main`.`id` = 1683888 OR `props-main`.`id` = 1683921 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` = 1674298 OR `props-main`.`id` = 1676559 OR `props-main`.`id` = 1682532 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1650510 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` = 1615839 OR `props-main`.`id` = 1614225 OR `props-main`.`id` = 1679963 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` = 1663964 OR `props-main`.`id` = 1663966 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1685842 OR `props-main`.`id` = 1644663 OR `props-main`.`id` = 1642699 OR `props-main`.`id` = 1622885 OR `props-main`.`id` = 1663976 OR `props-main`.`id` = 1681567 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` = 1677622 OR `props-main`.`id` = 1677617 OR `props-main`.`id` = 1677620 OR `props-main`.`id` = 1683304 OR `props-main`.`id` = 1683412 OR `props-main`.`id` = 1659680 OR `props-main`.`id` = 1681851 OR `props-main`.`id` = 1675291 OR `props-main`.`id` = 1651866 OR `props-main`.`id` = 1651867 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1684655 OR `props-main`.`id` = 1684702 OR `props-main`.`id` = 1674114 OR `props-main`.`id` = 1673439 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1683795 OR `props-main`.`id` = 1683670 OR `props-main`.`id` = 1683792 OR `props-main`.`id` = 1667834 OR `props-main`.`id` = 1677069 OR `props-main`.`id` = 1682311 OR `props-main`.`id` = 1658262 OR `props-main`.`id` = 1650607 OR `props-main`.`id` = 1653182 OR `props-main`.`id` = 1686506 OR `props-main`.`id` = 1686330 OR `props-main`.`id` = 1686339 OR `props-main`.`id` = 1675292 OR `props-main`.`id` = 1675274 OR `props-main`.`id` = 1675278 OR `props-main`.`id` = 1656550 OR `props-main`.`id` = 1656714 OR `props-main`.`id` = 1656726 OR `props-main`.`id` = 1674413 OR `props-main`.`id` = 1672924 OR `props-main`.`id` = 1686292 OR `props-main`.`id` = 258606 OR `props-main`.`id` = 1678627 OR `props-main`.`id` = 1678617 OR `props-main`.`id` = 1686679 OR `props-main`.`id` = 1686683 OR `props-main`.`id` = 1684436 OR `props-main`.`id` = 1684479 OR `props-main`.`id` = 155874 OR `props-main`.`id` = 1683926 OR `props-main`.`id` = 1683950 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1665650 OR `props-main`.`id` = 1685236 OR `props-main`.`id` = 1625934 OR `props-main`.`id` = 1678843 OR `props-main`.`id` = 1656585)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno634493' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-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();
2
Similar Properties
$434,000
4
2
1,375
0.14
717 Nicklaus Ct
Atwater, CA 95301
$426,500
3
2
1,292
0.14
1943 Pollitt Ct
Atwater, CA 95301
Courtesy of Alifonso Mendoza, Keller Williams Property Team - mercedcountyrealtor@gmail.com Last modified 1 month ago Fresno MLS last checked for updates 20 minutes 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.
