Please provide the following information and Salvador Garcia will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/agent/994/salvador-garcia/property/link/crmls/41115740/2409-Explorador-Dr/Merced/https://www.londonproperties.com/images/props/crmls/full/41115740.jpgLondon Properties Merced Real Estate | 2409 Explorador Dr
Listing Agent: Lakshmi Mantirraju, Intero Real Estate Services
Beautiful well kept Single Family Residence in the newly built Lennar community. Extra wide family room with bright big windows attached to the outdoor California room. Kitchen features quartz counters & a walk in pantry. Separate dining room. Primary suite is spacious with double sinks and walk in closet. All bedroom good size with closets. Separate convenient upstairs laundry room. The house sits ideally in close proximity to ''the Gateway of Yosemite'' and new amenities being developed in the area being next to UC Merced and future shopping center/hub in Merced. It's also close to Dignity Health Mercy medical center and other medical facilities with new restaurants, retails being developed already. This is the future of Merced!
Property Sub Type
Single Family Residence
Year Built
2021
Levels
Two
Price Per Square Foot
$204
Days On Market
12
Cumulative Days On Market
12
County Or Parish
Merced
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Major Cross Street: E Yosemite Ave & Via Moraga Cross Street: Moraga.
Room Type
Family Room
Cooling
Central Air
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Room Kitchen Features
Stone Counters, Butler's Pantry
Eating Area
Breakfast Counter / Bar
Appliances Y/N
Yes
Flooring
Tile, Vinyl
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Patio And Porch Features
Front Porch
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Back Yard
Lot Size Area
5349.0000
Lot Size Units
Square Feet
Parcel Number
008480004000
Subdivision Name
Other
Subdivision Name Other
Other
Association Amenities
Other
Association Y/N
Yes
Association Fee
105.00
Association Fee Frequency
Monthly
72876
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 508250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 561750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '6' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2371 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2871 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` = 1665550 OR `props-main`.`id` = 291212 OR `props-main`.`id` = 1687144 OR `props-main`.`id` = 1690759 OR `props-main`.`id` = 1690757 OR `props-main`.`id` = 788148 OR `props-main`.`id` = 1674412 OR `props-main`.`id` = 1691250 OR `props-main`.`id` = 77474 OR `props-main`.`id` = 1681389 OR `props-main`.`id` = 1681378 OR `props-main`.`id` = 1691953 OR `props-main`.`id` = 1691950 OR `props-main`.`id` = 1659395 OR `props-main`.`id` = 1680302 OR `props-main`.`id` = 1691449 OR `props-main`.`id` = 1690971 OR `props-main`.`id` = 1690988 OR `props-main`.`id` = 224715 OR `props-main`.`id` = 224717 OR `props-main`.`id` = 1687504 OR `props-main`.`id` = 1671187 OR `props-main`.`id` = 1688736 OR `props-main`.`id` = 1687983 OR `props-main`.`id` = 1684373 OR `props-main`.`id` = 1684370 OR `props-main`.`id` = 1689814 OR `props-main`.`id` = 1652853 OR `props-main`.`id` = 1691912 OR `props-main`.`id` = 93375 OR `props-main`.`id` = 1686717 OR `props-main`.`id` = 1683266 OR `props-main`.`id` = 1688172 OR `props-main`.`id` = 1688109 OR `props-main`.`id` = 1690025 OR `props-main`.`id` = 1690031 OR `props-main`.`id` = 1690039 OR `props-main`.`id` = 1681127 OR `props-main`.`id` = 1637274 OR `props-main`.`id` = 1688618 OR `props-main`.`id` = 1689807 OR `props-main`.`id` = 1680032 OR `props-main`.`id` = 223289 OR `props-main`.`id` = 223288 OR `props-main`.`id` = 1692307 OR `props-main`.`id` = 1659390 OR `props-main`.`id` = 1659386 OR `props-main`.`id` = 1659394 OR `props-main`.`id` = 1691397 OR `props-main`.`id` = 1682982 OR `props-main`.`id` = 1688699 OR `props-main`.`id` = 1688686 OR `props-main`.`id` = 1677592 OR `props-main`.`id` = 1691854 OR `props-main`.`id` = 1691670 OR `props-main`.`id` = 202390 OR `props-main`.`id` = 1654695 OR `props-main`.`id` = 1690618 OR `props-main`.`id` = 1666642 OR `props-main`.`id` = 1692984 OR `props-main`.`id` = 206435 OR `props-main`.`id` = 1691313 OR `props-main`.`id` = 1692668 OR `props-main`.`id` = 1622703 OR `props-main`.`id` = 1692788 OR `props-main`.`id` = 1691289 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 1692230 OR `props-main`.`id` = 1692223 OR `props-main`.`id` = 1667993 OR `props-main`.`id` = 1633539 OR `props-main`.`id` = 360956 OR `props-main`.`id` = 1685969 OR `props-main`.`id` = 1685977 OR `props-main`.`id` = 1622834 OR `props-main`.`id` = 1656522 OR `props-main`.`id` = 1678294 OR `props-main`.`id` = 1678342 OR `props-main`.`id` = 1678366 OR `props-main`.`id` = 1684707 OR `props-main`.`id` = 1683876 OR `props-main`.`id` = 1644740 OR `props-main`.`id` = 1688847 OR `props-main`.`id` = 1693116)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41115740' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-04' 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.