**Turnkey Living Meets Modern Comfort in Madera!**Welcome to this beautifully refreshed - super clean, 3-bedroom, 2-bath home offering 1,863 sq. ft. of bright, airy living space designed for effortless everyday living and easy entertaining.**Highlights & Upgrades:*** **Spacious & Bright:** Soaring high ceilings, new flooring, and fresh paint create an open, modern atmosphere throughout.* **Refreshed Kitchen:** Features refinished cabinetry, newer cooktop, oven, microwave, and dishwasher. Ready for your favorite recipes!* **Refrigerator, washer, and dryer included!* **Cozy & Efficient:** Unwind by the warm gas fireplace in the evenings. Enjoy complete peace of mind with a newer water heater, soft water system, upgraded ceiling fans, blinds, and security doors.* **Low-Maintenance Yard:** Spend less time on yard work and more time relaxing in your private outdoor space.**Unbeatably Convenient Location:**Situated in a well-established neighborhood just minutes from Madera Hospital, Parkwood Elementary, and Madera High School, with seamless access to Highway 99 for a quick commute.*Move-in ready with zero hassles. Schedule your showing today and make it yours!*
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2005
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$241
Price Per Acre
$3,749,167
Days On London
21
Cumulative Days On London
286
County
Madera
Reports Available
Seller Disclosure
Special Features
Isolated Bedroom, Isolated Bathroom, Security Gate, Built In Cabinets, Water Softener, Water Filter
REO / Bank Owned
No
Cross Street Address
Ave 13 and Raymond Thomas St
Directions
From Fresno, take Highway 99N to Avenue 12, turn left and go over the freeway. Turn right on Rd 28 1/4. Go to Avenue 13, turn left to Raymond Thomas Street. Turn left to Stanford Ave. Left to property on left.
Unit Description
Ground Floor
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, Electric Hook Up
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Electric Appliances, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 427405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 472395 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) >= 1613 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2113 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` = 1770164 OR `props-main`.`id` = 1742095 OR `props-main`.`id` = 1771193 OR `props-main`.`id` = 1765945 OR `props-main`.`id` = 1764706 OR `props-main`.`id` = 1709531 OR `props-main`.`id` = 1747160 OR `props-main`.`id` = 1725928 OR `props-main`.`id` = 1758248 OR `props-main`.`id` = 1767659 OR `props-main`.`id` = 1774156 OR `props-main`.`id` = 1755978 OR `props-main`.`id` = 1540736 OR `props-main`.`id` = 1762113 OR `props-main`.`id` = 1759045 OR `props-main`.`id` = 1758861 OR `props-main`.`id` = 1737431 OR `props-main`.`id` = 1755271 OR `props-main`.`id` = 1763017 OR `props-main`.`id` = 1725320 OR `props-main`.`id` = 1723074 OR `props-main`.`id` = 1729973 OR `props-main`.`id` = 1762934 OR `props-main`.`id` = 1725083 OR `props-main`.`id` = 1744435 OR `props-main`.`id` = 1727132 OR `props-main`.`id` = 1773785 OR `props-main`.`id` = 1773799 OR `props-main`.`id` = 1719349 OR `props-main`.`id` = 1745750 OR `props-main`.`id` = 1766494 OR `props-main`.`id` = 1722300 OR `props-main`.`id` = 1771709 OR `props-main`.`id` = 1773378 OR `props-main`.`id` = 1764806 OR `props-main`.`id` = 1730735 OR `props-main`.`id` = 1737765 OR `props-main`.`id` = 1765968 OR `props-main`.`id` = 1761753 OR `props-main`.`id` = 1761759 OR `props-main`.`id` = 1763051 OR `props-main`.`id` = 1724172 OR `props-main`.`id` = 1742348)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno653988' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-10' 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();
8
Similar Properties
$470,000
4
2.5
1,986
0.14
104 Corona Dr
Madera, CA 93638
$450,000
5
2
2,093
0.13
669 Ficklin Dr
Madera, CA 93637
$449,999
4
3
1,862
0.12
1583 Seneca Dr
Madera, CA 93637
$434,900
4
2
1,616
0.11
897 Gunnison Dr
Madera, CA 93638
Last modified 9 hours ago Fresno MLS last checked for updates 1 hour 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.
