Listing Agent: Pamela Dela Cruz, PDC Real Estate & Rentals
REO. 965 Beaver Pond Loop, Madera, CA 93636 in Tesoro Viejo has 4 bedrooms, 3.5 bathrooms, 3 car garage with 2 car parking, and solar. Located in a corner lot with 2953 sq ft, 10890 lot size, and built in 2024. This property is eligible under the Freddie Mac First Look Initiative through 09/15/2026.
Property Sub Type
Single Family Residence
Year Built
2024
Special Listing Conditions
Real Estate Owned
Levels
One
Price Per Square Foot
$217
Days On London
0
Cumulative Days On London
0
County Or Parish
Madera
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: Blackfish Rd.
Architectural Style
Contemporary
Heating
Forced Air, Solar
Cooling
Central Air
Construction Materials
Stucco
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Bathrooms Half
1
Room Kitchen Features
Stone Counters, Kitchen Island, Butler's Pantry
Eating Area
In Kitchen
Appliances Y/N
Yes
Flooring
Tile, Carpet
Fireplace Y/N
Yes
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage, Parking Space
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Features
Corner Lot, Front Yard, Garden, Back Yard, Yard
Lot Size Area
10890.0000
Lot Size Units
Square Feet
Parcel Number
081391016000
Subdivision Name
Not Listed
Subdivision Name Other
Not Listed
Association Amenities
Other
Association Y/N
Yes
Association Fee
219.00
Association Fee Frequency
Monthly
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 607905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 671895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2703 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3203 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` = 1736482 OR `props-main`.`id` = 1732247 OR `props-main`.`id` = 1744711 OR `props-main`.`id` = 1717685 OR `props-main`.`id` = 1702486 OR `props-main`.`id` = 1718634 OR `props-main`.`id` = 1718647 OR `props-main`.`id` = 1708360 OR `props-main`.`id` = 1750021 OR `props-main`.`id` = 1750010 OR `props-main`.`id` = 1729258 OR `props-main`.`id` = 1709724 OR `props-main`.`id` = 1738120 OR `props-main`.`id` = 1763005 OR `props-main`.`id` = 1744674 OR `props-main`.`id` = 1746486 OR `props-main`.`id` = 1704064 OR `props-main`.`id` = 1721662 OR `props-main`.`id` = 1705808 OR `props-main`.`id` = 1754293 OR `props-main`.`id` = 1754307 OR `props-main`.`id` = 1758018 OR `props-main`.`id` = 1754791 OR `props-main`.`id` = 1747675 OR `props-main`.`id` = 1760687 OR `props-main`.`id` = 1761073 OR `props-main`.`id` = 1720751 OR `props-main`.`id` = 1711476 OR `props-main`.`id` = 1722288 OR `props-main`.`id` = 1756086 OR `props-main`.`id` = 1753967 OR `props-main`.`id` = 1746080 OR `props-main`.`id` = 1727541 OR `props-main`.`id` = 1737523 OR `props-main`.`id` = 1734042 OR `props-main`.`id` = 1741269 OR `props-main`.`id` = 1722221 OR `props-main`.`id` = 1726279 OR `props-main`.`id` = 1723560 OR `props-main`.`id` = 1755711 OR `props-main`.`id` = 1717629 OR `props-main`.`id` = 1717645 OR `props-main`.`id` = 1749113 OR `props-main`.`id` = 1746844 OR `props-main`.`id` = 1722102 OR `props-main`.`id` = 1731610 OR `props-main`.`id` = 1752920 OR `props-main`.`id` = 1725445 OR `props-main`.`id` = 1696092 OR `props-main`.`id` = 1750050 OR `props-main`.`id` = 1755604 OR `props-main`.`id` = 1737137 OR `props-main`.`id` = 1737138 OR `props-main`.`id` = 1749063 OR `props-main`.`id` = 1696084)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41145226' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-16' 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.
