Courtesy of Osvaldo Aceves, Osvaldo Aceves, Broker - [email protected]
Beautifully maintained 4-bedroom, 2.5-bath home located in one of the most desirable neighborhoods in Madera, CA. This elegant property features stunning curb appeal with mature landscaping, lush green lawn, custom concrete walkways, and impressive Mediterranean-style architecture with high vaulted entryways. The inviting front entrance is complemented by decorative glass double doors, large windows for natural light, and a peaceful, well-kept exterior perfect for entertaining or relaxing. Situated in a quiet and established area, this home offers comfort, privacy, and timeless charm while being conveniently close to schools, shopping, and everyday amenities.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2005
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$255
Price Per Acre
$2,634,231
Days On London
32
Cumulative Days On London
32
County
Madera
Leased Equipment
Solar Panels
Special Features
Isolated Bedroom, Water Softener
REO / Bank Owned
No
Cross Street Address
N Westberry Blvd
Directions
South of intersection of Cleveland Ave. And Westberry Blvd
Special Disclosure
Flood Zone
Unit Description
Ground Floor
Style
Spanish, Mediterranean
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Gas Hook Up
Roofing
Composition
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower, Jetted Tub
Basement
None
Flooring
Laminate, Tile
# of Fireplaces
1
Fireplace Type
Gas Insert
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Patio Features
Covered, Wood Deck
Yard
Sprinklers Front, Fruit/Nut Trees
Gas & Electric
Public Utilities
Sewer / Water
Public Water
Energy Efficiency
Dual Pane Windows, Solar Water Heater
Solar
Yes
Solar Type
Lease
Parking Features
Potential RV Parking
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
3
Site Amenities
Other
APN
006 562 037 000
School District
Madera Unified
School Type 1
High School
School Name 1
Madera
School Type 2
Junior High School
School Name 2
Thomas Jefferson
School Type 3
Grade School
School Name 3
Lincoln
1st Loan Type
Non-Assumable
2nd Loan Type
Non-Assumable
Census Tract
78.000
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 650655 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 719145 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2440 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2940 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` = 1736727 OR `props-main`.`id` = 1733042 OR `props-main`.`id` = 1717452 OR `props-main`.`id` = 1714104 OR `props-main`.`id` = 1717986 OR `props-main`.`id` = 1717997 OR `props-main`.`id` = 1725732 OR `props-main`.`id` = 1718601 OR `props-main`.`id` = 1723244 OR `props-main`.`id` = 1737669 OR `props-main`.`id` = 1703297 OR `props-main`.`id` = 1725882 OR `props-main`.`id` = 1731688 OR `props-main`.`id` = 1742989 OR `props-main`.`id` = 1737047 OR `props-main`.`id` = 1700054 OR `props-main`.`id` = 1738276 OR `props-main`.`id` = 1720686 OR `props-main`.`id` = 1738364 OR `props-main`.`id` = 1735360 OR `props-main`.`id` = 1722123 OR `props-main`.`id` = 1722162 OR `props-main`.`id` = 1721113 OR `props-main`.`id` = 1728153 OR `props-main`.`id` = 1728135 OR `props-main`.`id` = 1728483 OR `props-main`.`id` = 1728146 OR `props-main`.`id` = 1739616 OR `props-main`.`id` = 1731024 OR `props-main`.`id` = 1731036 OR `props-main`.`id` = 1741758 OR `props-main`.`id` = 1741783 OR `props-main`.`id` = 1727958 OR `props-main`.`id` = 1731729 OR `props-main`.`id` = 1727070 OR `props-main`.`id` = 1727616 OR `props-main`.`id` = 87533 OR `props-main`.`id` = 1703632 OR `props-main`.`id` = 1723238 OR `props-main`.`id` = 1687157 OR `props-main`.`id` = 1718541 OR `props-main`.`id` = 1726639 OR `props-main`.`id` = 1732113 OR `props-main`.`id` = 1732105 OR `props-main`.`id` = 1732120 OR `props-main`.`id` = 1733081 OR `props-main`.`id` = 1743095 OR `props-main`.`id` = 1716799 OR `props-main`.`id` = 1720767 OR `props-main`.`id` = 1713046 OR `props-main`.`id` = 1739240 OR `props-main`.`id` = 1735900 OR `props-main`.`id` = 1735915 OR `props-main`.`id` = 1735946 OR `props-main`.`id` = 1741581 OR `props-main`.`id` = 1735217 OR `props-main`.`id` = 1735233 OR `props-main`.`id` = 1742151 OR `props-main`.`id` = 1716416 OR `props-main`.`id` = 1716080 OR `props-main`.`id` = 1711430 OR `props-main`.`id` = 1734909 OR `props-main`.`id` = 1739008 OR `props-main`.`id` = 1725594 OR `props-main`.`id` = 1741255 OR `props-main`.`id` = 1715786 OR `props-main`.`id` = 1715784 OR `props-main`.`id` = 1715780 OR `props-main`.`id` = 1715789 OR `props-main`.`id` = 1712531 OR `props-main`.`id` = 1731346 OR `props-main`.`id` = 1731347 OR `props-main`.`id` = 1679009 OR `props-main`.`id` = 1679008 OR `props-main`.`id` = 1679011 OR `props-main`.`id` = 1731349 OR `props-main`.`id` = 1741256 OR `props-main`.`id` = 1731348 OR `props-main`.`id` = 1679010)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649394' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-27' 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
$675,000
4
3
2,740
0.25
2610 Marie Dr
Madera, CA 93637
$675,000
5
4
2,797
0.19
1381 Riverbank Dr
Madera, CA 93637
Last modified 3 hours 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.
