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/649750/62642-Old-College-Ln-16/Huntington-Lake/https://www.londonproperties.com/images/camerashy.pngLondon Properties Huntington Lake Real Estate | 62642 Old College Ln #16
Looking for that perfect Huntington 2/2 condo located conveniently close to the action? This beautifully maintained furnished home is centrally located near the pool, tennis and pickleball courts, jacuzzi, sauna, volleyball and bocce ball! With numerous upgrades - including updated flooring - this condo is move-in ready and perfect for making year round fun family memories. Enjoy not one, but two spacious, low maintenance Trex decks : one off the living area and another off the primary bedroom - ideal for soaking up the fresh mountain air. Very short walk to the lake too! Come see this special location for yourself and your loved ones and discover how much fun is waiting right outside your door.
Property Type
Residential
Property Subtype 1
Condominium
Property Subtype 2
Single Family Residence
Year Built
1979
Region
Mountain
# of Stories
Multi/Split
Price Per Square Foot
$251
Price Per Acre
$22,549,020
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
Huntington Vista Rd
Directions
Enter Huntington Condo road approx 200 yards to the west of China landing Marina and Store. Make first left toward clubhouse. Condo is on the right. #16
Heating & Cooling
Floor or Wall Unit
Laundry
Inside, Electric Hook Up
Roofing
Metal
Foundation
Both
Kitchen
F/S Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Refrigerator
Pool, Spa, Sauna, Club House, Green Area, Tennis, Landscape Maint
HOA Dues
830.00
School District
Sierra Unified
School Type 1
High School
School Name 1
Sierra
School Type 2
Junior High School
School Name 2
Sierra
School Type 3
Grade School
School Name 3
Big Creek
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 327750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 362250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1122 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1622 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` = 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`) != 'fresno649750' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-01' 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();
5
Similar Properties
$359,000
2
2
1,396
0.01
62758 Sunny Vista #25
Lakeshore, CA 93634
$354,900
2
2
1,396
0.01
62954 Huntington Vista Rd #45
Lakeshore, CA 93634
$345,000
2
1.75
1,372
0.02
62614 Old College Ln #12
Lakeshore, CA 93634
$342,500
2
2
1,372
0.02
62792 Skiview Ln
Huntington Lake, CA 93634
Courtesy of Marcia Beach, RE/MAX Gold - Clovis - [email protected] Last modified 2 hours ago Fresno MLS last checked for updates 10 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.
