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/kings/234546/41059-Grouse-Dr/Three-Rivers/https://www.londonproperties.com/images/props/kings/full/234546.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 outschedule your private tour today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1991
Location
City
Stories
2
Price Per Square Foot
$308
Price Per Acre
$1,414,634
Cumulative Days On London
0
County
Tulare
Directions
From Sierra Dr, East on Cherokee Dr, Follow it to Grouse, Right turn on Grouse and home sits at the end.
Full Bathrooms
3
Fireplace
In Family Room
Pool Private Y/N
No
Spa Y/N
No
Porch / Patio
Open Porch
Solar Y/N
No
Garage Type
Garage Attached
Garage Capacity
2
Horse Property Y/N
No
APN Number
068 241 004 000
Association
Kings County Multiple Listing Service
Special Listing Conditions
HUD Owned
Currently Rented
No
Lease Type
Net
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 551000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 609000 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) >= 1631 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2131 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` = 1721797 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` = 1725488 OR `props-main`.`id` = 1742067 OR `props-main`.`id` = 1720154 OR `props-main`.`id` = 1723363 OR `props-main`.`id` = 1737651 OR `props-main`.`id` = 1697131 OR `props-main`.`id` = 1712811 OR `props-main`.`id` = 1718917 OR `props-main`.`id` = 1713310 OR `props-main`.`id` = 1719916 OR `props-main`.`id` = 1720152 OR `props-main`.`id` = 1720683 OR `props-main`.`id` = 1725667 OR `props-main`.`id` = 1737686 OR `props-main`.`id` = 1720007 OR `props-main`.`id` = 1737697 OR `props-main`.`id` = 1731278 OR `props-main`.`id` = 1718687)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings234546' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-30' 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 Ana Rodriguez, 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.
