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/628911/47180-Lookout-Mountain-Dr/Coarsegold/https://www.londonproperties.com/images/props/fresno/full/628911.jpgLondon Properties Coarsegold Real Estate | 47180 Lookout Mountain Dr
Just 26 miles from the south gate of the breathtaking beauty of Yosemite National Park, this 4-bedroom, 3-bath home offers 2,168 sq ft of comfortable living space on almost 3 acres. The interior is turnkey, exceptionally clean and and move-in ready! The kitchen is fully equipped with appliances and a full set of utensils. Located in a Firewise community, this home offers added peace of mind with proactive wildfire mitigation measures in place. Check with your insurance agent for discounted premium. Enjoy the spacious room of each bedroom along with ample bathrooms. A freestanding wood-burning stove in the family room adds warmth and rustic charm to the main living area. The living room is a bonus that can be left as is or use the blank canvas to create a theatre room, game room or whatever your creative self can imagine! The home's exterior features a durable, fire resistant combination of stucco and concrete plank siding, blending style with low-maintenance living. The landscaped yard is maintained by an efficient drip irrigation system, ensuring low water usage and easy upkeep. And trees galore! Walk amongst your mature oak, pine, manzanita and many more.Whether you're looking for a full-time residence, vacation getaway, or investment opportunity, the spacious layout and versatile acreage offer endless possibilities.
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Refrigerator, Other
Dining Room Features
Family Room/Area
Primary Bedroom Level
Main
Extra Rooms
Great Room
Flooring
Carpet, Laminate, Tile
# of Fireplaces
1
Fireplace Type
Free Standing
Exterior
Stucco, Other
Pool
No
Pool
No
Spa
No
Patio Features
Concrete
Yard
Mature Landscape, Drip System
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Community Well
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Potential RV Parking, Auto Opener
Garage Type
Attached
Garage Spaces
2
Site Amenities
Other
APN
054 542 016 000
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Coarsegold
School Type 3
Grade School
School Name 3
Coarsegold
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 474810 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 524790 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1918 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2418 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` = 1650990 OR `props-main`.`id` = 1651166 OR `props-main`.`id` = 1695694 OR `props-main`.`id` = 1677762 OR `props-main`.`id` = 1677739 OR `props-main`.`id` = 1663784 OR `props-main`.`id` = 1685343 OR `props-main`.`id` = 1695270 OR `props-main`.`id` = 1655469 OR `props-main`.`id` = 1687726 OR `props-main`.`id` = 1666254 OR `props-main`.`id` = 1688970 OR `props-main`.`id` = 1688944 OR `props-main`.`id` = 1687532 OR `props-main`.`id` = 1686635 OR `props-main`.`id` = 1686645 OR `props-main`.`id` = 1692485 OR `props-main`.`id` = 1654019 OR `props-main`.`id` = 1674052 OR `props-main`.`id` = 1674042 OR `props-main`.`id` = 1676676 OR `props-main`.`id` = 1685629 OR `props-main`.`id` = 1671954 OR `props-main`.`id` = 1671963 OR `props-main`.`id` = 1634812 OR `props-main`.`id` = 1692124 OR `props-main`.`id` = 1647455 OR `props-main`.`id` = 1696959 OR `props-main`.`id` = 1696654 OR `props-main`.`id` = 1648958 OR `props-main`.`id` = 1687051 OR `props-main`.`id` = 1695902 OR `props-main`.`id` = 1639056 OR `props-main`.`id` = 1665822)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno628911' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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 Gerald Brown, Century 21 Select Real Estate - [email protected] Last modified 1 month ago Fresno MLS last checked for updates 6 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.
