Donna Pride559.642.8373dpride@londonproperties.comEmail Agent
Property Description
Seize this opportunity to acquire a custom-built residence with breathtaking views of the Great Pines community, spanning over an acre of land. The property has undergone a comprehensive renovation by the sellers, featuring new laminate flooring, paint, and fixtures that create a warm and inviting atmosphere. Vaulted ceilings and a newly installed pellet stove in the family room enhance the comfort of the home. Custom wrap-around front and rear decks provide ample space for entertaining and enjoying the outdoors. Access to the lake further contributes to the tranquility and serenity of the surrounding environment. Make your appointment today with a Realtor to private tour of this beauty.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1989
Region
Foothill
# of Stories
Two
Price Per Square Foot
$303
Price Per Acre
$432,119
Days On Market
10
Cumulative Days On Market
10
County
Madera
Reports Available
NHD, Prelim Title Report, Seller Disclosure
REO / Bank Owned
No
Cross Street Address
Rd 428
Directions
From road 428 going South turn left on Pineview and property on the left side.
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Kitchen
F/S Range/Oven, Electric Appliances, Disposal, Dishwasher, Eating Area, Pantry
Primary Bedroom Level
Lower
Bath Features
Tub/Shower
Extra Rooms
Family Room
Basement
None
Flooring
Carpet, Laminate
Exterior
Wood
Pool
No
Pool
No
Spa
Yes
Spa Type
Above Ground
Patio Features
Covered, Wood Deck
Yard
Sprinklers Auto
Gas & Electric
Public Utilities, Generator
Sewer / Water
Public Water, Septic Tank
Solar
No
Parking Features
Potential RV Parking
Garage Type
Detached
Garage Spaces
2
Site Amenities
Lake View
APN
065 290 018 000
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Yosemite
School Type 3
Grade School
School Name 3
Oakhurst
Seller Will Consider
Government, Conventional, Cash
72877
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 484405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 535395 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) >= 1433 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1933 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` = 1674154 OR `props-main`.`id` = 1678813 OR `props-main`.`id` = 1678066 OR `props-main`.`id` = 1665957 OR `props-main`.`id` = 1626196 OR `props-main`.`id` = 1666250 OR `props-main`.`id` = 1626195 OR `props-main`.`id` = 1665948 OR `props-main`.`id` = 1651367 OR `props-main`.`id` = 1683801 OR `props-main`.`id` = 1683783 OR `props-main`.`id` = 1661941 OR `props-main`.`id` = 1661942 OR `props-main`.`id` = 1661954 OR `props-main`.`id` = 1679689 OR `props-main`.`id` = 1679681 OR `props-main`.`id` = 1668234 OR `props-main`.`id` = 1654955 OR `props-main`.`id` = 1627895 OR `props-main`.`id` = 1627897 OR `props-main`.`id` = 1674210 OR `props-main`.`id` = 1675284 OR `props-main`.`id` = 1675295 OR `props-main`.`id` = 1652720 OR `props-main`.`id` = 1684949 OR `props-main`.`id` = 1684969 OR `props-main`.`id` = 1649455 OR `props-main`.`id` = 1649459 OR `props-main`.`id` = 1652449 OR `props-main`.`id` = 1674206 OR `props-main`.`id` = 1652455 OR `props-main`.`id` = 1673392 OR `props-main`.`id` = 1678542 OR `props-main`.`id` = 1663325 OR `props-main`.`id` = 1643063 OR `props-main`.`id` = 1683814 OR `props-main`.`id` = 1656663 OR `props-main`.`id` = 1656662 OR `props-main`.`id` = 1622531 OR `props-main`.`id` = 1674442 OR `props-main`.`id` = 1622454 OR `props-main`.`id` = 1631943 OR `props-main`.`id` = 1681594 OR `props-main`.`id` = 1681611 OR `props-main`.`id` = 1684616 OR `props-main`.`id` = 1677160 OR `props-main`.`id` = 1677211 OR `props-main`.`id` = 1655004 OR `props-main`.`id` = 1679453 OR `props-main`.`id` = 1683252 OR `props-main`.`id` = 1679458 OR `props-main`.`id` = 1683265 OR `props-main`.`id` = 1654966 OR `props-main`.`id` = 1684184 OR `props-main`.`id` = 1684196 OR `props-main`.`id` = 1673104 OR `props-main`.`id` = 1673106 OR `props-main`.`id` = 1677652 OR `props-main`.`id` = 1684109 OR `props-main`.`id` = 1684613 OR `props-main`.`id` = 1657752 OR `props-main`.`id` = 1673013 OR `props-main`.`id` = 1645396 OR `props-main`.`id` = 1638870 OR `props-main`.`id` = 1655023 OR `props-main`.`id` = 1673677 OR `props-main`.`id` = 1671575 OR `props-main`.`id` = 1638512 OR `props-main`.`id` = 1667500 OR `props-main`.`id` = 1619284 OR `props-main`.`id` = 1663715 OR `props-main`.`id` = 1668424 OR `props-main`.`id` = 1668707 OR `props-main`.`id` = 1668699 OR `props-main`.`id` = 1639830 OR `props-main`.`id` = 1619294 OR `props-main`.`id` = 1638533 OR `props-main`.`id` = 1680246 OR `props-main`.`id` = 1657135 OR `props-main`.`id` = 1655920 OR `props-main`.`id` = 1622608 OR `props-main`.`id` = 1613594 OR `props-main`.`id` = 1622498 OR `props-main`.`id` = 1636751 OR `props-main`.`id` = 1651415 OR `props-main`.`id` = 1667484 OR `props-main`.`id` = 1667579 OR `props-main`.`id` = 1683587 OR `props-main`.`id` = 1683558 OR `props-main`.`id` = 1685356 OR `props-main`.`id` = 1674714 OR `props-main`.`id` = 1674821 OR `props-main`.`id` = 1622491 OR `props-main`.`id` = 1677521 OR `props-main`.`id` = 1685286 OR `props-main`.`id` = 1685061 OR `props-main`.`id` = 1677519)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636598' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-15' 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 Frank Dickinson, Realty Concepts, Ltd. - Fresno - frank@realtyconcepts.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.
