Wow! This is truly a very special condo offering at Huntington Lake! Perched at the very top of the hill, this 3-bedroom, 3-bath plus loft end unit showcases panoramic views of Huntington Lake and China Peak Ski Area that will take your breath away. Step inside to discover a home that has been tastefully upgraded and thoughtfully designed for comfort and style. Highlights include hardwood flooring, high quality Kohler fixtures and beautifully updated kitchen and bathrooms. This condo has a crisp, move-in ready feel. With it's open floor plan and spacious loft, it is perfect for hosting family and friends after a day on the lake or slopes. Fully furnished and ready for you to move right in and start making wonderful memories. Whether you're looking for a year-round mountain retreat or ultimate mountain getaway with Sierra National Forest as your backdrop, this condo offers it all - unmatched views, modern upgrades, and unbeatable proximity to outdoor adventure. Five star rental history. HOA fee covers water, sewer, snow removal, cable t.v., on-site manager's salary, road maintenance, building maintenance, insurance for building, etc.
Property Type
Residential
Property Subtype 1
Condominium
Property Subtype 2
Single Family Residence
Year Built
1989
Region
Mountain
# of Stories
Multi/Split
Price Per Square Foot
$386
Price Per Acre
$32,028,302
Days On London
242
Cumulative Days On London
242
County
Fresno
Special Features
Other/See Remarks
REO / Bank Owned
No
Cross Street Address
Huntington Lake Road
Directions
Located at the top of the Huntington Condos. #80 Eagle's Nest.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 645050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 712950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1507 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2007 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` = 1730623 OR `props-main`.`id` = 1734066 OR `props-main`.`id` = 1727924 OR `props-main`.`id` = 1731151 OR `props-main`.`id` = 1685683 OR `props-main`.`id` = 1721138 OR `props-main`.`id` = 1691474 OR `props-main`.`id` = 1731117 OR `props-main`.`id` = 1662205 OR `props-main`.`id` = 1701290 OR `props-main`.`id` = 1726284 OR `props-main`.`id` = 1554221 OR `props-main`.`id` = 1695802 OR `props-main`.`id` = 1722495 OR `props-main`.`id` = 1689415 OR `props-main`.`id` = 1680562 OR `props-main`.`id` = 1664450)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637259' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-09' 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
$698,000
3
3
1,638
0.02
63217 Huntington Vista Rd #81
Lakeshore, CA 93634
Last modified 1 month 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.
