Elegant five bedroom home offers two owner's suites: one downstairs and one upstairs. Large great room with majestic vaulted ceiling is perfect for entertaining family and friends. A separate formal dining room provides an intimate setting for those special occasions. Open concept kitchen featuring granite countertops and tile floors leads to the comfortable and cozy living room. Four bedrooms are located upstairs, as is the conveniently situated laundry room. Large upstairs primary suite leads into an equally spacious en suite with separate shower and bath, as well as two walk-in closets. Plenty of backyard space, replete with shade trees to cool down those warm summer months. Make your appointment to visit this gem today.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2007
Year Built Source
Public Records
Days On London
75
Cumulative Days On London
75
County
Tulare
New Construction
No
Stories
2
Current Use
Single Family
Directions to Property
From Mooney Blvd, east on Seminole Ave, south on Spyglass St, east on Pinehurst Ave, south on Inverness, west on Riviera Ct. Home is located on south side of street.
Built-in Features, Ceiling Fan(s), Coffered Ceiling(s), High Ceilings, His and Hers Closets, Kitchen Island, Pantry, Vaulted Ceiling(s)
# of Main Level Bathrooms
1
Bathrooms Total (Integer)
3
Full Baths
3.0
Full Baths
3
Fireplace Y/N
Yes
Fireplace Features
Living Room
Flooring
Carpet, Ceramic Tile
Common Walls
No Common Walls
Spa
No
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached
Garage
Yes
Attached Garage
Yes
# of Garage Spaces
2.0
APN
172 110 007 000
Lot Features
Back Yard, Cul-De-Sac, Fencing, Front Yard, Sprinklers In Front, Sprinklers In Rear
Lot Dimensions
70 x 135
Additional Parcels Y/N
No
View
Neighborhood
Road Surface Type
Asphalt
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 553280 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 611520 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3477 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3977 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` = 1671752 OR `props-main`.`id` = 1693558 OR `props-main`.`id` = 1693586 OR `props-main`.`id` = 1693584 OR `props-main`.`id` = 1708337 OR `props-main`.`id` = 1685045 OR `props-main`.`id` = 1698548 OR `props-main`.`id` = 1696910 OR `props-main`.`id` = 1706056 OR `props-main`.`id` = 1706114 OR `props-main`.`id` = 1704404 OR `props-main`.`id` = 1703758 OR `props-main`.`id` = 1701978 OR `props-main`.`id` = 1696554 OR `props-main`.`id` = 1684212 OR `props-main`.`id` = 1710798 OR `props-main`.`id` = 1702949 OR `props-main`.`id` = 1709919 OR `props-main`.`id` = 1705569 OR `props-main`.`id` = 1709751 OR `props-main`.`id` = 1709174 OR `props-main`.`id` = 1691823 OR `props-main`.`id` = 1696346 OR `props-main`.`id` = 1706839 OR `props-main`.`id` = 1705988 OR `props-main`.`id` = 1685563 OR `props-main`.`id` = 1685702 OR `props-main`.`id` = 1702075 OR `props-main`.`id` = 1702079 OR `props-main`.`id` = 1702076 OR `props-main`.`id` = 1666539 OR `props-main`.`id` = 1698078 OR `props-main`.`id` = 1698849 OR `props-main`.`id` = 1693438 OR `props-main`.`id` = 1693439 OR `props-main`.`id` = 1693440 OR `props-main`.`id` = 1703242 OR `props-main`.`id` = 1686669 OR `props-main`.`id` = 1702371 OR `props-main`.`id` = 1648159 OR `props-main`.`id` = 1694348 OR `props-main`.`id` = 1697313 OR `props-main`.`id` = 1697879 OR `props-main`.`id` = 1710266 OR `props-main`.`id` = 1701698 OR `props-main`.`id` = 1709738 OR `props-main`.`id` = 1704772 OR `props-main`.`id` = 1693940 OR `props-main`.`id` = 1709147 OR `props-main`.`id` = 1651113 OR `props-main`.`id` = 1701353 OR `props-main`.`id` = 1700834 OR `props-main`.`id` = 1705941 OR `props-main`.`id` = 1701245 OR `props-main`.`id` = 1705626 OR `props-main`.`id` = 1705627 OR `props-main`.`id` = 1660481 OR `props-main`.`id` = 1657630 OR `props-main`.`id` = 1660958 OR `props-main`.`id` = 1685715 OR `props-main`.`id` = 1710079 OR `props-main`.`id` = 1701810 OR `props-main`.`id` = 1701505 OR `props-main`.`id` = 1701807 OR `props-main`.`id` = 1701811 OR `props-main`.`id` = 1701812 OR `props-main`.`id` = 1711190 OR `props-main`.`id` = 1695290 OR `props-main`.`id` = 1695293 OR `props-main`.`id` = 1695294 OR `props-main`.`id` = 1707927 OR `props-main`.`id` = 1710086)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare238777' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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 Brian Gilbert, The Equity Group
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.
