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/tulare/242511/41059-Grouse-Dr/Three-Rivers/https://www.londonproperties.com/images/props/tulare/full/242511.jpgLondon Properties Three Rivers Real Estate | 41059 Grouse Dr
This 3-bedroom, 3-bath home in Three Rivers offers the best of foothills living. Located at the end of Grouse Dr, you'll enjoy ultimate privacy and elevated views of Blossom Peak. Highlights include an expansive upper-level primary suite with a private deck, a generous kitchen with a large breakfast bar, and a thoughtful layout perfect for hosting. Recent upgrades and quality finishes make this home move-in ready. Located just minutes from town and the gateway to Sequoia National Park, this is your chance to own a slice of mountain paradise. Don't miss out-schedule your private tour today!
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1991
Year Built Source
Public Records
Days On London
45
Cumulative Days On London
45
County
Tulare
Property Condition
Fixer
New Construction
No
Stories
2
Directions to Property
From Sierra Dr, East on Cherokee Dr, Follow it to Grouse, Right turn on Grouse and home sits at the end.
Roof
Composition
Heating
Other
Cooling
Other
# of Main Level Bathrooms
1
Bathrooms Total (Integer)
3
Full Baths
2.5
Full Baths
2
Half Baths
1
Fireplace Y/N
Yes
Fireplace Features
Wood Burning Stove
Flooring
Carpet
Private Pool
No
Spa
No
Utilities
Electricity Connected
Water Source
Other
Sewer
Other
Garage
Yes
# of Garage Spaces
2.0
APN
068 241 004 000
Lot Dimensions
Irregular
Horse Property
No
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 484880 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 535920 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) >= 1638 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2138 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` = 1729071 OR `props-main`.`id` = 1718329 OR `props-main`.`id` = 1748418 OR `props-main`.`id` = 1749371 OR `props-main`.`id` = 1756387 OR `props-main`.`id` = 1725937 OR `props-main`.`id` = 1743486 OR `props-main`.`id` = 1744377 OR `props-main`.`id` = 1716592 OR `props-main`.`id` = 1699119 OR `props-main`.`id` = 1742067 OR `props-main`.`id` = 1754960 OR `props-main`.`id` = 1718917 OR `props-main`.`id` = 1713310 OR `props-main`.`id` = 1719916 OR `props-main`.`id` = 1748491 OR `props-main`.`id` = 1720152 OR `props-main`.`id` = 1720683 OR `props-main`.`id` = 1725667 OR `props-main`.`id` = 1755446 OR `props-main`.`id` = 1720007 OR `props-main`.`id` = 1746491 OR `props-main`.`id` = 1755455 OR `props-main`.`id` = 1731278)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare242511' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-08' 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 Hector Martinez, ERA Valley Pro Realty
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.
