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/643647/38830-Road-274/Bass-Lake/https://www.londonproperties.com/images/props/fresno/full/643647.jpgLondon Properties Bass Lake Real Estate | 38830 Road 274
Courtesy of Rene Christenson, Century 21 Ditton Realty - [email protected]
''ALMOST'' waterfront with 2 boat slips, 2 jet ski docks, a ''members only'' private boat launch, a separate boat garage for storage all year round, another 2 car garage attached to the home, a covered carport, extra parking, and in a private, gated community with magnificent lake views! This custom built 3 bedroom, 3 bathroom home at Bass Lake offers an idyllic lakeside retreat with breathtaking lake views. The home is thoughtfully designed with three levels of expansive decks, ensuring you can enjoy the scenic vistas from nearly every angle. Whether you're watching the sunrise over the water or soaking in the evening hues, these decks provide the perfect setting for relaxation and entertainment. This house features spacious, light-filled interiors, with large windows that bring the outside in, enhancing the home's natural beauty. The open living areas are complemented by high-end finishes, offering a modern yet cozy feel. The large game room is a standout feature and can also serve as a bunk room for extra sleeping space, ideal for families or guests. For car and toy enthusiasts, there is an abundant amount of extra parking for vehicles and trailers. The home is situated in a gated community, providing added privacy and security. The home also comes equipped with an on-demand generator, capable of powering the entire house during a power outage, offering extra peace of mind for any potential disruptions. With a new roof installed in 2025, the property is well-maintained and ready for you to move in and enjoy. This lakeside gem is an exceptional place to create lasting memories with family and friends, offering the perfect blend of modern amenities, outdoor adventure, and serene living by the water!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1989
Region
Foothill
# of Stories
Multi/Split
Price Per Square Foot
$536
Price Per Acre
$3,545,455
Days On London
116
Cumulative Days On London
116
County
Madera
Special Features
Security Gate
REO / Bank Owned
No
Cross Street Address
Road 222
Directions
Highway 41 to Road 222 to Road 274
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Composition, Other
Foundation
Concrete
Detached Structures
Other/See Remarks
Kitchen
Electric Appliances, Disposal, Dishwasher, Eating Area, Breakfast Bar, Refrigerator
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower, Jetted Tub
Extra Rooms
Family Room, Game Room
Basement
Finished
Flooring
Carpet, Tile
# of Fireplaces
1
Exterior
Wood
Pool
No
Pool
No
Spa
No
Patio Features
Wood Deck
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Carport
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
4
Carport Spaces
2
Site Amenities
Lake View, Water Front
APN
059 210 023 000
Association / Park Amenities
Gated Community, Other/None
School District
Bass Lake Joint Unio
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Oak Creek
School Type 3
Grade School
School Name 3
Oakhurst
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1852500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2047500 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) >= 3388 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3888 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` = 1728442 OR `props-main`.`id` = 1729249 OR `props-main`.`id` = 1731746 OR `props-main`.`id` = 1723145 OR `props-main`.`id` = 1731377 OR `props-main`.`id` = 1690435 OR `props-main`.`id` = 1690452 OR `props-main`.`id` = 1716752 OR `props-main`.`id` = 1720936 OR `props-main`.`id` = 1707163 OR `props-main`.`id` = 1707168 OR `props-main`.`id` = 1733583 OR `props-main`.`id` = 1732371 OR `props-main`.`id` = 1732359 OR `props-main`.`id` = 1718595 OR `props-main`.`id` = 1731333 OR `props-main`.`id` = 1651640 OR `props-main`.`id` = 1651360 OR `props-main`.`id` = 1731692 OR `props-main`.`id` = 1726257 OR `props-main`.`id` = 1726264 OR `props-main`.`id` = 1731571 OR `props-main`.`id` = 1720328 OR `props-main`.`id` = 1728101 OR `props-main`.`id` = 1728144 OR `props-main`.`id` = 1731511 OR `props-main`.`id` = 1731736 OR `props-main`.`id` = 1715544 OR `props-main`.`id` = 1715525 OR `props-main`.`id` = 1731490 OR `props-main`.`id` = 1712927 OR `props-main`.`id` = 1712937 OR `props-main`.`id` = 1731359 OR `props-main`.`id` = 1683463 OR `props-main`.`id` = 1683460 OR `props-main`.`id` = 1727929 OR `props-main`.`id` = 1701603 OR `props-main`.`id` = 1673053 OR `props-main`.`id` = 1672968 OR `props-main`.`id` = 1665870 OR `props-main`.`id` = 1731460 OR `props-main`.`id` = 1606109 OR `props-main`.`id` = 1705918 OR `props-main`.`id` = 1705910 OR `props-main`.`id` = 1731352 OR `props-main`.`id` = 1731376 OR `props-main`.`id` = 1721081 OR `props-main`.`id` = 1721073 OR `props-main`.`id` = 1690434 OR `props-main`.`id` = 1690419 OR `props-main`.`id` = 1732954 OR `props-main`.`id` = 1698122 OR `props-main`.`id` = 1698121 OR `props-main`.`id` = 1719664 OR `props-main`.`id` = 1720906 OR `props-main`.`id` = 1731562 OR `props-main`.`id` = 1731582 OR `props-main`.`id` = 1718229 OR `props-main`.`id` = 1718213 OR `props-main`.`id` = 1720938 OR `props-main`.`id` = 1731320 OR `props-main`.`id` = 1622921)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643647' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-06' 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
Last modified 3 months 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.
