Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/crmls/ML82043555/2912-Secretariat-Dr/Atwater/https://www.londonproperties.com/images/props/crmls/full/ML82043555.jpgLondon Properties Atwater Real Estate | 2912 Secretariat Dr
Listing Agent: Lisette Muniz, Realty One Group Infinity
This spacious 1,400 sqft home has 3 bedrooms and 2 full bathrooms and 2 car garage was built in 1980 with large lot size of 7,376 sqft. Home is located near shopping, restaurants, schools, parks and much more. Home has lots of potential with some TLC.
Property Sub Type
Single Family Residence
Year Built
1980
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Price Per Square Foot
$214
Days On London
0
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: E Bellevue Road
Heating
Central
Cooling
Central Air
Roof
Composition
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Appliances Y/N
No
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Wood Burning
Water Source
Public
Sewer
Public Sewer
Parking Total
1.00
Attached Garage Y/N
Yes
Garage Spaces
1.00
Lot Size Area
7376.0000
Lot Size Units
Square Feet
View Y/N
No
Parcel Number
156101016000
Zoning
R-1 4
Association Y/N
No
High School District
Other
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 284952.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 314947.5 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) >= 1150 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1650 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` = 1687154 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1705043 OR `props-main`.`id` = 1704605 OR `props-main`.`id` = 1722015 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1698472 OR `props-main`.`id` = 1717926 OR `props-main`.`id` = 1716596 OR `props-main`.`id` = 1713267 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1719235 OR `props-main`.`id` = 1721037 OR `props-main`.`id` = 1721065 OR `props-main`.`id` = 1720707 OR `props-main`.`id` = 1720899 OR `props-main`.`id` = 1698461 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1719056 OR `props-main`.`id` = 1717369 OR `props-main`.`id` = 1713318 OR `props-main`.`id` = 1713316 OR `props-main`.`id` = 1713327 OR `props-main`.`id` = 1695235 OR `props-main`.`id` = 1702194 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1717379 OR `props-main`.`id` = 1697663 OR `props-main`.`id` = 1705044 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 1705151 OR `props-main`.`id` = 1718717 OR `props-main`.`id` = 1718711 OR `props-main`.`id` = 1718743 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1713374 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1711217 OR `props-main`.`id` = 1702479 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1722253 OR `props-main`.`id` = 1721235 OR `props-main`.`id` = 1722367 OR `props-main`.`id` = 1722355 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1721783 OR `props-main`.`id` = 1721780 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1714397 OR `props-main`.`id` = 1722473 OR `props-main`.`id` = 1717948 OR `props-main`.`id` = 1688816 OR `props-main`.`id` = 1714214 OR `props-main`.`id` = 1719698 OR `props-main`.`id` = 1712385 OR `props-main`.`id` = 1711526 OR `props-main`.`id` = 1717457 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1707011 OR `props-main`.`id` = 1716394 OR `props-main`.`id` = 1694847 OR `props-main`.`id` = 1696793)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82043555' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-17' 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
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.
