Please provide the following information and Lee Ann Kreps will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.leeannk.com/agent/16509/leeann-kreps/property/link/fresno/640333/724-Arrowhead-Dr/Madera/https://www.leeannk.com/images/props/fresno/full/640333.jpgLondon Properties Madera Real Estate | 724 Arrowhead Dr
Lee Ann Kreps559.664.7100leeannk@londonproperties.comEmail Agent
Property Description
**Discover Your Dream Home in Tesoro Viejo!**Welcome to this beautiful 1602 sq. ft. home featuring 3 spacious bedrooms and 2.5 bathrooms, ideal for families or those seeking extra space.### **Home Highlights:**- **Stylish Interiors**: Enjoy easy-to-maintain tile flooring throughout the downstairs and a modern kitchen with sleek granite countertops and gas oven and stovetop and gracious iron rod staircase.- **Eco-Friendly Living**: Benefit from solar energy, with just a $300 true-up bill.- **Upgraded Backyard**: Relax in your upgraded backyard featuring a concrete patio, a charming retaining wall, mature trees, and potential RV parking.- **Convenient Garage**: A 2-car garage provides ample storage and easy access.### **Community Features:**- **Resort-Style Amenities**: Access a stunning clubhouse, refreshing pool and pickle ball courts.- **Great Schools**: A K-8 elementary school is within walking distance.- **Endless Trails**: Explore over 15 miles of walking and biking trails.- **Vibrant Town Center**: Enjoy shopping, dining, and community engagement.### **Fun Community Events:**Join in on farmer's markets, live concerts, movie nights, and festive holiday parties that bring neighbors together!**Schedule a tour today** to see this charming home in Tesoro Viejo and discover a lifestyle you'll love. Your dream home awaits!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2022
Region
Urban
# of Stories
Two
Price Per Square Foot
$275
Price Per Acre
$5,498,750
Days On Market
4
Cumulative Days On Market
4
County
Madera
Reports Available
Prelim Title Report
Leased Equipment
Security System, Solar Panels
REO / Bank Owned
No
Cross Street Address
Red Rock Dr
Directions
Take HWY 41, turn east on Tesoro Viejo Blvd, turn NE on Treasure Hills Dr at the roundabout, turn NW on Red Rock Dr, turn SW on Arrowhead Dr. 3rd home on left.
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, Gas Hook Up, Electric Hook Up
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Pantry
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower
Flooring
Carpet, Tile
Exterior
Stucco
Pool
No
Pool
No
Patio Features
Uncovered, Concrete
Yard
Sprinklers Auto, Drip System
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer, Community Well
Energy Efficiency
Dual Pane Windows, 13+ SEER A/C, Tankless Water Heater
Solar
Yes
Solar Type
Lease
Parking Features
Potential RV Parking, Auto Opener
Garage Type
Attached
Garage Spaces
2
APN
081 230 008 000
Association / Park Amenities
Pool, Spa, Club House, Exercise Room, Green Area, Playground
HOA Dues
88.00
Frequency
Monthly
School District
Chawanakee
School Type 1
High School
School Name 1
Minarets
School Type 2
Junior High School
School Name 2
Hillside
School Type 3
Grade School
School Name 3
Hillside
Seller Will Consider
Government, Conventional, Cash
72875
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 417905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 461895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1352 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1852 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` = 1691781 OR `props-main`.`id` = 1636330 OR `props-main`.`id` = 1683083 OR `props-main`.`id` = 1691114 OR `props-main`.`id` = 1691255 OR `props-main`.`id` = 1691700 OR `props-main`.`id` = 1678785 OR `props-main`.`id` = 1683821 OR `props-main`.`id` = 1686409 OR `props-main`.`id` = 1656927 OR `props-main`.`id` = 1696002 OR `props-main`.`id` = 1679969 OR `props-main`.`id` = 1684859 OR `props-main`.`id` = 1682059 OR `props-main`.`id` = 1683325 OR `props-main`.`id` = 1689718 OR `props-main`.`id` = 1684863 OR `props-main`.`id` = 1695400 OR `props-main`.`id` = 1671621 OR `props-main`.`id` = 1663724 OR `props-main`.`id` = 1660730 OR `props-main`.`id` = 1685313 OR `props-main`.`id` = 1674966 OR `props-main`.`id` = 1678853 OR `props-main`.`id` = 1683597 OR `props-main`.`id` = 1679056 OR `props-main`.`id` = 1691022 OR `props-main`.`id` = 1657513 OR `props-main`.`id` = 1695893 OR `props-main`.`id` = 1693967 OR `props-main`.`id` = 1691871 OR `props-main`.`id` = 1692547 OR `props-main`.`id` = 1696092 OR `props-main`.`id` = 1695769 OR `props-main`.`id` = 1687049 OR `props-main`.`id` = 1695774 OR `props-main`.`id` = 1696084)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640333' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-30' 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();
1
Similar Properties
$435,000
3
2.5
1,651
0.05
609 Josephine Ave
Madera, CA 93636
Courtesy of Brent Cate, Modern Broker - thecateteam@gmail.com Last modified 1 week ago Fresno MLS last checked for updates 23 minutes 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.
