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/644730/29348-Powder-Horn-Way/Coarsegold/https://www.londonproperties.com/images/props/fresno/full/644730.jpgLondon Properties Coarsegold Real Estate | 29348 Powder Horn Way
This lovely family property features a charming wraparound porch, peaceful pond, and space for chickens, offering true country living. The 3280 sq ft home sits on 2.53 acres, includes five bedrooms, 2 1/2 bathrooms, a game room, and a beautiful stone fireplace. Designed for entertaining, you'll enjoy inviting spaces both inside and out. You'll love the efficiency of the owned solar system & the the fact that this wonderful home is situated on a nice quiet cul-de-sac make this a truly special place to land at the end of the day! There's plenty of room for your family to grow and make lasting memories. Yosemite Lakes Park offers wonderful community amenities including a riding stable, nine-hole golf course, clubhouse, lake, baseball diamond, and park. Call your Realtor today to schedule your showing of this one of a kind property.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2004
Region
Foothill
# of Stories
Two
Price Per Square Foot
$189
Price Per Acre
$245,059
Days On London
21
Cumulative Days On London
21
County
Madera
Reports Available
NHD
Special Features
Built In Cabinets, Water Softener
REO / Bank Owned
No
Cross Street Address
Lilley Mtn Dr
Directions
Hwy 41 To Yosemite Springs Parkway, left on Corral Dr, left on John Muir Dr, left on Lilley tn Dr, left o Powder Horn Way
Heating & Cooling
Central Heat & Cool, Whole House Fan
Laundry
Inside, Gas Hook Up, Electric Hook Up
Roofing
Composition
Foundation
Wood Subfloor
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Breakfast Bar, Pantry
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Jetted Tub
Extra Rooms
Game Room
Flooring
Carpet, Tile
# of Fireplaces
1
Exterior
Other
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
Yes
Spa Type
Community Spa
Patio Features
Covered, Wood Deck
Yard
Fenced, Mature Landscape, Garden Area
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Community Well
Energy Efficiency
Dual Pane Windows, Tankless Water Heater, Other
Solar
Yes
Solar Type
Owned
Parking Features
Auto Opener, Circular Driveway
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
Site Amenities
Cul De Sac
APN
093 330 010 000
Association / Park Amenities
Pool, Spa, Club House, Tennis, Lake/Pond, Playground
HOA Dues
179.00
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Rivergold
School Type 3
Grade School
School Name 3
Rivergold
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 589000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 651000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3030 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3530 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` = 1687560 OR `props-main`.`id` = 1687561 OR `props-main`.`id` = 1687562 OR `props-main`.`id` = 1687563 OR `props-main`.`id` = 1715070 OR `props-main`.`id` = 1687559 OR `props-main`.`id` = 1597958 OR `props-main`.`id` = 1665840 OR `props-main`.`id` = 1715071 OR `props-main`.`id` = 1715072 OR `props-main`.`id` = 1715073 OR `props-main`.`id` = 1715074 OR `props-main`.`id` = 1597960 OR `props-main`.`id` = 1665841 OR `props-main`.`id` = 1597961 OR `props-main`.`id` = 1665842 OR `props-main`.`id` = 1597951 OR `props-main`.`id` = 1665843 OR `props-main`.`id` = 1716095 OR `props-main`.`id` = 1717434 OR `props-main`.`id` = 1717601 OR `props-main`.`id` = 1717602 OR `props-main`.`id` = 1717603 OR `props-main`.`id` = 1717604 OR `props-main`.`id` = 1717605 OR `props-main`.`id` = 1716966 OR `props-main`.`id` = 1716595 OR `props-main`.`id` = 1715505 OR `props-main`.`id` = 1715085 OR `props-main`.`id` = 1687706 OR `props-main`.`id` = 1685636 OR `props-main`.`id` = 1704295 OR `props-main`.`id` = 1703800 OR `props-main`.`id` = 1703501 OR `props-main`.`id` = 1695954 OR `props-main`.`id` = 1666180 OR `props-main`.`id` = 1708116 OR `props-main`.`id` = 1704149 OR `props-main`.`id` = 1704013 OR `props-main`.`id` = 1625902 OR `props-main`.`id` = 1702295 OR `props-main`.`id` = 1704827 OR `props-main`.`id` = 1713814 OR `props-main`.`id` = 1704840 OR `props-main`.`id` = 1687696 OR `props-main`.`id` = 1684463 OR `props-main`.`id` = 1705132 OR `props-main`.`id` = 1688813 OR `props-main`.`id` = 1687394 OR `props-main`.`id` = 1708204 OR `props-main`.`id` = 1705139 OR `props-main`.`id` = 1708223 OR `props-main`.`id` = 1666319 OR `props-main`.`id` = 1701326 OR `props-main`.`id` = 1687628 OR `props-main`.`id` = 1717402 OR `props-main`.`id` = 1703646 OR `props-main`.`id` = 1703657 OR `props-main`.`id` = 1703656 OR `props-main`.`id` = 1702537 OR `props-main`.`id` = 1712355 OR `props-main`.`id` = 1712541 OR `props-main`.`id` = 1709899 OR `props-main`.`id` = 1709957 OR `props-main`.`id` = 1674929 OR `props-main`.`id` = 1717964 OR `props-main`.`id` = 1718019 OR `props-main`.`id` = 1665722 OR `props-main`.`id` = 1698081 OR `props-main`.`id` = 1698085 OR `props-main`.`id` = 1714048 OR `props-main`.`id` = 1701999 OR `props-main`.`id` = 1714054 OR `props-main`.`id` = 1704135 OR `props-main`.`id` = 1665857)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno644730' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-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();
0
Courtesy of Martha Hauch, Rise Real Estate - [email protected] Last modified 2 weeks ago Fresno MLS last checked for updates 8 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.
