Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/644472/642-Stone-Crest-Ave/Madera/https://www.londonproperties.com/images/props/fresno/full/644472.jpgLondon Properties Madera Real Estate | 642 Stone Crest Ave
Modern Tesoro Viejo Retreat Near Trails & Ranch House! Welcome to your private oasis in the heart of Tesoro Viejoproudly known as the National Community of the Year.'' Just three years new, this beautifully maintained residence offers over 1,600 sq. ft. of stylish living space with 3 bedrooms, 2 bathrooms & the incredible benefit of Owned Solarhelping you potentially save Thou$ands on energy costs. One of the home's standout advantages is its location among all single-story homes, providing wonderful natural light, enhanced backyard privacy & beautiful sunset viewswithout taller homes looking down into your yard.Step inside & discover a bright, inviting atmosphere designed for both comfort & modern living. The impressive entry foyer showcases elegant wood-look tile flooring & leads to two spacious guest bedrooms featuring plush carpeting & upgraded privacy shutters. These rooms share a well-appointed bathroom with granite countertops & a shower-over-tub. The foyer opens into an expansive great room that serves as the heart of the home. The contemporary eat-in kitchen is both functional & stylish, highlighted by a large granite island, matching countertops, rich espresso cabinetry & stainless-steel appliancesperfect for everyday living & entertaining. Privately situated, the spacious primary suite offers abundant natural light, a generous walk-in closet & an en-suite bath with dual sinks, granite counters & a large step-in shower. A separate indoor laundry room with like-new LG washer & dryer adds everyday convenience.Step outside & enjoy the lifestyle that makes Tesoro Viejo so special. The home is just a short stroll to the Ranch House & nearby trail system, making it easy to start your mornings with scenic walks or meet neighbors for community events.Residents enjoy miles of walking & hiking trails, beautiful parks, a TK-8 neighborhood school & the vibrant community Hub with medical services, caf & regular family-friendly gatherings. The spectacular Ranch House offers resort-style pools, spa, fitness center, cabanas, bocce ball, outdoor gathering areas & indoor entertainment spaces. Convenient access to Hwy 41 places Fresno, River Park shopping, dining & entertainment just minutes away. A wonderful opportunity to enjoy the Tesoro Viejo lifestyle in one of the Central Valley's most celebrated communitieswhere scenic trails, beautiful parks & vibrant neighborhood gatherings create a true sense of home.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2023
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$282
Price Per Acre
$5,044,444
Days On London
98
Cumulative Days On London
98
County
Madera
Reports Available
NHD, Prelim Title Report, Seller Disclosure
REO / Bank Owned
No
Cross Street Address
Hillside Road
Directions
CA-41 N; Right onto Tesoro Viejo Blvd.; At the traffic circle, take the 2nd exit onto Treasure Hills Dr; Turn Left onto Hillside Rd.; Turn Right onto Stone Crest Ave.
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Gas Hook Up, Electric Hook Up
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Other
Dining Room Features
Family Room/Area
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Basement
None
Flooring
Carpet, Tile
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
Yes
Spa Type
Community Spa
Patio Features
Covered
Yard
Sprinklers Front, Sprinklers Auto, Fenced
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows, Other
Solar
Yes
Solar Type
Owned
Parking Features
Auto Opener, Street
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
081 210 056 000
Association / Park Amenities
Pool, Spa, Club House, Exercise Room, Green Area, Playground, Other/None
HOA Dues
200.00
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
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 431300 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 476700 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) >= 1358 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1858 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` = 1721323 OR `props-main`.`id` = 1733503 OR `props-main`.`id` = 1736482 OR `props-main`.`id` = 1732247 OR `props-main`.`id` = 1733197 OR `props-main`.`id` = 1716815 OR `props-main`.`id` = 1691781 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` = 1735376 OR `props-main`.`id` = 1729258 OR `props-main`.`id` = 1731766 OR `props-main`.`id` = 1709724 OR `props-main`.`id` = 1738120 OR `props-main`.`id` = 1712496 OR `props-main`.`id` = 1704064 OR `props-main`.`id` = 1704029 OR `props-main`.`id` = 1721662 OR `props-main`.`id` = 1705808 OR `props-main`.`id` = 1704028 OR `props-main`.`id` = 1720751 OR `props-main`.`id` = 1719598 OR `props-main`.`id` = 1731689 OR `props-main`.`id` = 1711476 OR `props-main`.`id` = 1714903 OR `props-main`.`id` = 1722288 OR `props-main`.`id` = 1732187 OR `props-main`.`id` = 1722471 OR `props-main`.`id` = 1722207 OR `props-main`.`id` = 1737182 OR `props-main`.`id` = 1727541 OR `props-main`.`id` = 1737523 OR `props-main`.`id` = 1732212 OR `props-main`.`id` = 1727715 OR `props-main`.`id` = 1734042 OR `props-main`.`id` = 1722656 OR `props-main`.`id` = 1725593 OR `props-main`.`id` = 1722221 OR `props-main`.`id` = 1721656 OR `props-main`.`id` = 1738750 OR `props-main`.`id` = 1731643 OR `props-main`.`id` = 1726279 OR `props-main`.`id` = 1723560 OR `props-main`.`id` = 1701823 OR `props-main`.`id` = 1717629 OR `props-main`.`id` = 1717645 OR `props-main`.`id` = 1722102 OR `props-main`.`id` = 1731610 OR `props-main`.`id` = 1711144 OR `props-main`.`id` = 1715813 OR `props-main`.`id` = 1725445 OR `props-main`.`id` = 1696092 OR `props-main`.`id` = 1737137 OR `props-main`.`id` = 1737138 OR `props-main`.`id` = 1696084 OR `props-main`.`id` = 1731391 OR `props-main`.`id` = 1731390)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno644472' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-22' 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();
10
Similar Properties
$469,000
3
2
1,608
0.09
619 Wood Crest Ave
Madera, CA 93636
$465,000
3
3
1,820
0.06
824 Katelyn Ave
Madera, CA 93636
$450,000
3
2.5
1,651
0.04
4154 Constance Rd
Madera, CA 93636
$439,900
3
2.5
1,581
0.06
4301 San Miguel Rd
Madera, CA 93636
Last modified 4 days ago Fresno MLS last checked for updates 9 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.
