London Properties Long Barn Real Estate

25264 Esther Ave

Long Barn, CA 95335

Copy Link Get Directions

$350,000

2 bd

2 ba

896 sq ft

0.18 acre

25264 Esther Ave

Long Barn, CA 95335

Get Directions

Listed On: 05/23/2026

Status: Active

Listing Number: 41135860 (CRMLS)

Schedule a Tour

Contact Info

Advertising Agent:

London Properties, Ltd. 559.436.4071 Email Agent

Property Description

Listing Agent: Judith Austin, KW Sierra Foothills

Escape to the mountains in this beautifully upgraded vacation rental located in the highly desirable gated community of Sierra Park. Surrounded by towering pines and forest beauty, this turnkey cabin offers the perfect blend of rustic charm and modern comfort - ideal as a personal retreat and is already an income-producing vacation rental. Inside, you'll love the open-beam wood ceilings, warm rustic finishes, open floor plan, and cozy wood-burning fireplace. The home is move-in ready with stainless steel appliances, washer and dryer, remodeled bathrooms, and efficient mini-split heating and air conditioning. The layout includes one bedroom and bath downstairs, plus a spacious loft upstairs with two queen beds and an updated bathroom. Outdoor features include a firepit/sitting area, open patio for entertaining, fenced pet area, and electric vehicle charger. Sierra Park offers outstanding amenities including a private lake, playgrounds, basketball and baseball courts, dog park, and scenic forest trails. Conveniently located near Pinecrest Lake and Dodge Ridge Ski Resort, this mountain retreat delivers year-round adventure and relaxation.

Property Sub Type

Single Family Residence

Year Built

1960

Levels

Two

Price Per Square Foot

$391

Days On London

Cumulative Days On London

County Or Parish

Tuolumne

New Construction Y/N

Cooling Y/N

Yes

Heating Y/N

Yes

Directions

Cross Street: Ruth.

Heating

Electric

Laundry Y/N

Yes

Laundry Features

Washer Included, Dryer Included

Roof

Shingle

Construction Materials

Wood Siding

Bathrooms Full

Bathrooms Full And Three Quarter

Room Kitchen Features

Remodeled Kitchen

Eating Area

Breakfast Nook

Appliances Y/N

Yes

Flooring

Carpet, Laminate

Fireplace Y/N

Yes

Fireplace Features

Free Standing, Family Room

Pool Features

None

Pool Private Y/N

Attached Garage Y/N

Lot Size Area

7744.0000

Lot Size Units

Square Feet

View Y/N

Yes

View

Trees/Woods

Parcel Number

031073012000

Association Amenities

Playground, Clubhouse, Security

Association Y/N

Yes

Association Fee

350.00

Association Fee Frequency

Annually

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 646 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1146 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` = 1728668 OR `props-main`.`id` = 1727628 OR `props-main`.`id` = 1727430)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41135860' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-23' 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();

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.

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

25264 Esther Ave

Long Barn, CA 95335

$350,000

25264 Esther Ave

Long Barn, CA 95335

Schedule a Tour

Contact Info

Advertising Agent:

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

25264 Esther Ave

Long Barn, CA 95335

$350,000

25264 Esther Ave

Long Barn, CA 95335

Schedule a Tour

Contact Info

Advertising Agent:

Loading...

Saving...

Deleting...

Searching...