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/233960/2067-Mount-Stewart-Ave/Tulare/https://www.londonproperties.com/images/props/kings/full/233960.jpgLondon Properties Tulare Real Estate | 2067 Mount Stewart Ave
Welcome home to this stunning 4-bedroom, 3-bathroom home built in 2020, offering 2,160 sq. ft. of modern, open living space designed for comfort and style. Conveniently located near shopping with quick access to Highway 99, this home offers both ease and accessibility. The spacious kitchen is perfect for entertaining, featuring a large island, walk-in pantry, gorgeous cabinetry, and custom finishes throughout. The thoughtfully designed split floor plan provides added privacy, with a ideal and inviting primary suite set apart from the additional bedrooms. Enjoy seamless indoor-outdoor living with a large covered patio and generous backyard, ideal for gatherings, relaxing evenings, and creating lasting memories. Move-in ready and truly turn-keythis is one you don't want to miss!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2020
Location
City
Stories
1
Price Per Square Foot
$231
Price Per Acre
$3,333,267
Cumulative Days On London
62
County
Tulare
Directions
Exit FWY 99 on E Bardsley Ave. East on E Bardsley Ave. South on Durango St. East on Mt Stewart Ave. Home is on the South side of street.
Full Bathrooms
2
Pool Private Y/N
No
Spa Y/N
No
Porch / Patio
Covered Patio
Solar Y/N
No
Garage Type
Garage Attached
Garage Capacity
2
Horse Property Y/N
No
APN Number
182 300 028 000
Zoning
R-1
Association
Kings County Multiple Listing Service
Currently Rented
No
Lease Type
Net
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 474990.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 524989.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1910 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2410 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` = 1728361 OR `props-main`.`id` = 1697281 OR `props-main`.`id` = 1734810 OR `props-main`.`id` = 1697836 OR `props-main`.`id` = 1723716 OR `props-main`.`id` = 1734720 OR `props-main`.`id` = 1728497 OR `props-main`.`id` = 1728916 OR `props-main`.`id` = 1728893 OR `props-main`.`id` = 1728917 OR `props-main`.`id` = 1728887 OR `props-main`.`id` = 1685045 OR `props-main`.`id` = 1713901 OR `props-main`.`id` = 1728276 OR `props-main`.`id` = 1724846 OR `props-main`.`id` = 1720680 OR `props-main`.`id` = 1732851 OR `props-main`.`id` = 1706056 OR `props-main`.`id` = 1732871 OR `props-main`.`id` = 1727566 OR `props-main`.`id` = 1729010 OR `props-main`.`id` = 1729292 OR `props-main`.`id` = 1731907 OR `props-main`.`id` = 1731070 OR `props-main`.`id` = 1729100 OR `props-main`.`id` = 1723251 OR `props-main`.`id` = 1725695 OR `props-main`.`id` = 1728748 OR `props-main`.`id` = 1709174 OR `props-main`.`id` = 1719989 OR `props-main`.`id` = 1731295 OR `props-main`.`id` = 1727691 OR `props-main`.`id` = 1713948 OR `props-main`.`id` = 1726532 OR `props-main`.`id` = 1732010 OR `props-main`.`id` = 1723938 OR `props-main`.`id` = 1723924 OR `props-main`.`id` = 1723947 OR `props-main`.`id` = 1702075 OR `props-main`.`id` = 1702079 OR `props-main`.`id` = 1720095 OR `props-main`.`id` = 1728113 OR `props-main`.`id` = 1731866 OR `props-main`.`id` = 1716772 OR `props-main`.`id` = 1729188 OR `props-main`.`id` = 1722155 OR `props-main`.`id` = 1728749 OR `props-main`.`id` = 1716994 OR `props-main`.`id` = 1725486 OR `props-main`.`id` = 1732253 OR `props-main`.`id` = 1732360 OR `props-main`.`id` = 1725920 OR `props-main`.`id` = 1728588 OR `props-main`.`id` = 1728810 OR `props-main`.`id` = 1709147 OR `props-main`.`id` = 1720588 OR `props-main`.`id` = 1725304 OR `props-main`.`id` = 1732593)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings233960' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-09' 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();
2
Similar Properties
$515,900
4
3
2,228
0.18
2898 Ship Rock Ct
Tulare, CA 93274
$515,000
4
3
2,154
0.10
2802 Sand Hills Ave
Tulare, CA 93274
Courtesy of J. Nicole Kennedy, Jo-Ann Nicole Yvette Kennedy
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.
