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/241818/4217-W-Elowin-Ct/Visalia/https://www.londonproperties.com/images/props/tulare/full/241818.jpgLondon Properties Visalia Real Estate | 4217 W Elowin Ct
This home offers abundant space for family living with a bright, open floor plan, ideally situated on a quiet cul-de-sac. Experience the exquisitely reimagined chef's kitchen, thoughtfully redesigned to include a wet bar and a butler's pantry connecting the kitchen and dining room. French doors lead out to a resort-style pool area, designed for year-round entertaining. The open-concept layout features 4 bedrooms and 3 full bathrooms, including one bedroom and full bathroom on the main level. Additional living spaces include an open family room adjacent to the kitchen, a formal living room, and a spacious loft with a built-in desk area. There is also a potential 5th bedroom in place of the upstairs family room, which can easily be converted if desired. Conveniently located within walking distance of the highly sought-after Oak Grove Elementary School and the community park, this home combines comfort, functionality, and exceptional indoor-outdoor living.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2003
Year Built Source
Public Records
Days On London
21
Cumulative Days On London
21
County
Tulare
New Construction
No
Stories
2
Directions to Property
Head to South Locust, West on Mineral King to 198 West, North on Demaree, West on Elowin
Construction Materials
Stucco
Foundation Details
Slab
Roof
Tile
Heating
Central
Cooling
Central Air
# of Main Level Bathrooms
1
Bathrooms Total (Integer)
3
Full Baths
3.0
Full Baths
3
Fireplace Y/N
Yes
Fireplace Features
Family Room, Gas Starter
Private Pool
Yes
Pool Features
In Ground
Spa
No
Patio and Porch Features
Covered
Utilities
Electricity Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
3.0
APN
077 320 083 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) >= 641250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 708750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2814 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3314 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` = 1728452 OR `props-main`.`id` = 1696665 OR `props-main`.`id` = 1696658 OR `props-main`.`id` = 1735832 OR `props-main`.`id` = 1702399 OR `props-main`.`id` = 1702407 OR `props-main`.`id` = 1722801 OR `props-main`.`id` = 1706994 OR `props-main`.`id` = 1706995 OR `props-main`.`id` = 1724028 OR `props-main`.`id` = 1722782 OR `props-main`.`id` = 1731297 OR `props-main`.`id` = 1724438 OR `props-main`.`id` = 1728297 OR `props-main`.`id` = 1728298 OR `props-main`.`id` = 1728300 OR `props-main`.`id` = 1728209 OR `props-main`.`id` = 1722778 OR `props-main`.`id` = 1726485 OR `props-main`.`id` = 1722818 OR `props-main`.`id` = 1722779 OR `props-main`.`id` = 1725159 OR `props-main`.`id` = 1720180 OR `props-main`.`id` = 1720179 OR `props-main`.`id` = 1718441 OR `props-main`.`id` = 1720484 OR `props-main`.`id` = 1720505 OR `props-main`.`id` = 1720472 OR `props-main`.`id` = 1686038 OR `props-main`.`id` = 1731846 OR `props-main`.`id` = 1721652 OR `props-main`.`id` = 1686106 OR `props-main`.`id` = 1686066 OR `props-main`.`id` = 1722784 OR `props-main`.`id` = 1722813 OR `props-main`.`id` = 1704448 OR `props-main`.`id` = 1722976 OR `props-main`.`id` = 1728430 OR `props-main`.`id` = 1728416 OR `props-main`.`id` = 1728422 OR `props-main`.`id` = 1728426 OR `props-main`.`id` = 1722824 OR `props-main`.`id` = 1722826 OR `props-main`.`id` = 1723816 OR `props-main`.`id` = 1712365 OR `props-main`.`id` = 1727668 OR `props-main`.`id` = 1726328 OR `props-main`.`id` = 1694314 OR `props-main`.`id` = 1715538 OR `props-main`.`id` = 1726163 OR `props-main`.`id` = 1726156 OR `props-main`.`id` = 1726138 OR `props-main`.`id` = 1731284 OR `props-main`.`id` = 1730864 OR `props-main`.`id` = 1713501 OR `props-main`.`id` = 1731285 OR `props-main`.`id` = 1719198 OR `props-main`.`id` = 1715964 OR `props-main`.`id` = 1731286 OR `props-main`.`id` = 1730733 OR `props-main`.`id` = 1734725 OR `props-main`.`id` = 1713659 OR `props-main`.`id` = 1718543 OR `props-main`.`id` = 1733211 OR `props-main`.`id` = 1712646 OR `props-main`.`id` = 1718545 OR `props-main`.`id` = 1725944 OR `props-main`.`id` = 1719339 OR `props-main`.`id` = 1727517 OR `props-main`.`id` = 1727499 OR `props-main`.`id` = 1722448 OR `props-main`.`id` = 1725557 OR `props-main`.`id` = 1729187 OR `props-main`.`id` = 1705331 OR `props-main`.`id` = 1717383 OR `props-main`.`id` = 1706794 OR `props-main`.`id` = 1736104 OR `props-main`.`id` = 1722604 OR `props-main`.`id` = 1728949 OR `props-main`.`id` = 1724376 OR `props-main`.`id` = 1729115 OR `props-main`.`id` = 1725472 OR `props-main`.`id` = 1725449 OR `props-main`.`id` = 1725450 OR `props-main`.`id` = 1727128 OR `props-main`.`id` = 1725417 OR `props-main`.`id` = 1726537 OR `props-main`.`id` = 1726133 OR `props-main`.`id` = 1708233 OR `props-main`.`id` = 1721637 OR `props-main`.`id` = 1721377 OR `props-main`.`id` = 1721331 OR `props-main`.`id` = 1728812 OR `props-main`.`id` = 1728230 OR `props-main`.`id` = 1736323 OR `props-main`.`id` = 1728936 OR `props-main`.`id` = 1720958 OR `props-main`.`id` = 1717375 OR `props-main`.`id` = 1717914 OR `props-main`.`id` = 1731026 OR `props-main`.`id` = 1731028 OR `props-main`.`id` = 1731067 OR `props-main`.`id` = 1731029 OR `props-main`.`id` = 1725167 OR `props-main`.`id` = 1719815 OR `props-main`.`id` = 1723513 OR `props-main`.`id` = 1729327 OR `props-main`.`id` = 1729359 OR `props-main`.`id` = 1729646 OR `props-main`.`id` = 1735443 OR `props-main`.`id` = 1686098 OR `props-main`.`id` = 1721729 OR `props-main`.`id` = 1721687 OR `props-main`.`id` = 1727007 OR `props-main`.`id` = 1727011 OR `props-main`.`id` = 1726998 OR `props-main`.`id` = 1718195 OR `props-main`.`id` = 1729148 OR `props-main`.`id` = 1728594 OR `props-main`.`id` = 1732814 OR `props-main`.`id` = 1724436 OR `props-main`.`id` = 1731290 OR `props-main`.`id` = 1724417 OR `props-main`.`id` = 1724434 OR `props-main`.`id` = 1731294 OR `props-main`.`id` = 1724415 OR `props-main`.`id` = 1731293 OR `props-main`.`id` = 1731292 OR `props-main`.`id` = 1716221 OR `props-main`.`id` = 1716371 OR `props-main`.`id` = 1716378 OR `props-main`.`id` = 1715015 OR `props-main`.`id` = 1699067 OR `props-main`.`id` = 1699066 OR `props-main`.`id` = 1732158 OR `props-main`.`id` = 1727186 OR `props-main`.`id` = 1726624 OR `props-main`.`id` = 1726699 OR `props-main`.`id` = 1733084 OR `props-main`.`id` = 1704510 OR `props-main`.`id` = 1713824 OR `props-main`.`id` = 1726772 OR `props-main`.`id` = 1721260 OR `props-main`.`id` = 1719336 OR `props-main`.`id` = 929721 OR `props-main`.`id` = 1731664 OR `props-main`.`id` = 1724855 OR `props-main`.`id` = 1724864 OR `props-main`.`id` = 1725258 OR `props-main`.`id` = 1724831 OR `props-main`.`id` = 1721728 OR `props-main`.`id` = 1732339 OR `props-main`.`id` = 1725487 OR `props-main`.`id` = 1726349 OR `props-main`.`id` = 1727672 OR `props-main`.`id` = 1727670 OR `props-main`.`id` = 1718638 OR `props-main`.`id` = 1721747 OR `props-main`.`id` = 1725358 OR `props-main`.`id` = 1721943 OR `props-main`.`id` = 1726498 OR `props-main`.`id` = 1727987 OR `props-main`.`id` = 1735429 OR `props-main`.`id` = 1704073 OR `props-main`.`id` = 1726298 OR `props-main`.`id` = 1722508 OR `props-main`.`id` = 1726208 OR `props-main`.`id` = 1726203 OR `props-main`.`id` = 1736035 OR `props-main`.`id` = 1720128 OR `props-main`.`id` = 1728617 OR `props-main`.`id` = 1721883 OR `props-main`.`id` = 1719961 OR `props-main`.`id` = 1706757 OR `props-main`.`id` = 1726632 OR `props-main`.`id` = 1724541 OR `props-main`.`id` = 1727981 OR `props-main`.`id` = 1727985 OR `props-main`.`id` = 1727977 OR `props-main`.`id` = 1722152 OR `props-main`.`id` = 1727012 OR `props-main`.`id` = 1726972 OR `props-main`.`id` = 1731302 OR `props-main`.`id` = 1730794 OR `props-main`.`id` = 1731158 OR `props-main`.`id` = 1725431 OR `props-main`.`id` = 1733288 OR `props-main`.`id` = 1733339 OR `props-main`.`id` = 1734059 OR `props-main`.`id` = 1727690 OR `props-main`.`id` = 1727671 OR `props-main`.`id` = 1727673 OR `props-main`.`id` = 1727692 OR `props-main`.`id` = 1725579 OR `props-main`.`id` = 1725580 OR `props-main`.`id` = 1727694 OR `props-main`.`id` = 1725589 OR `props-main`.`id` = 1716660 OR `props-main`.`id` = 1725566 OR `props-main`.`id` = 1732876 OR `props-main`.`id` = 1716671 OR `props-main`.`id` = 1726495 OR `props-main`.`id` = 1730486 OR `props-main`.`id` = 1726499 OR `props-main`.`id` = 1726497 OR `props-main`.`id` = 1730487 OR `props-main`.`id` = 1730489 OR `props-main`.`id` = 1726525 OR `props-main`.`id` = 1726512 OR `props-main`.`id` = 1730731 OR `props-main`.`id` = 1730730 OR `props-main`.`id` = 1730729)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare241818' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-11' 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 Mark Avedian, Avedian Properties Company
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.
