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/fresno/653971/627-S-Elverta-St/Visalia/https://www.londonproperties.com/images/props/fresno/full/653971.jpgLondon Properties Visalia Real Estate | 627 S Elverta St
Welcome to this spacious two-story home offering an open-concept floor plan with abundant natural light and versatile living spaces. A beautiful custom front door greets you upon entry. The kitchen features granite countertops, a center island, ample cabinetry, and generous prep space, flowing seamlessly into the dining and living areas. Downstairs windows are adorned with stylish Plantation Shutters. Upstairs, you'll find spacious bedrooms plus a versatile loft with built-in shelvingperfect for a home office, media room, or additional living area. Neutral finishes throughout provide a move-in-ready canvas. Enjoy a low-maintenance backyard featuring a covered patio, multiple seating areas, and attractive landscapingideal for relaxing or entertaining. Artificial grass in front and back yards is an added bonus and also reduces your monthly landscaping costs. Additional highlights include indoor laundry, generous storage, and an attached custom, insulated two-car garage with windows that create more light. A wonderful combination of space, functionality, and comfortable indoor-outdoor living.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2018
Region
Urban
# of Stories
Two
Price Per Square Foot
$195
Price Per Acre
$3,719,723
Days On London
59
Cumulative Days On London
59
County
Tulare
Leased Equipment
Solar Panels
Special Features
Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Cypress Ave
Directions
From Highway 198, exit Lovers Lane, head south, then quick turn to the east on Noble Ave. South on McAuliff Street, east on E Cypress Ave, north on Elverta Street. House is located on west side of street.
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Utility Room
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Pantry
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower
Flooring
Carpet, Laminate
Exterior
Stucco
Pool
No
Pool
No
Yard
Synthetic Lawn, Drip System
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
Yes
Solar Type
Lease
Parking Features
Auto Opener
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
101 340 000
Zoning
R1-5
School District
Visalia Schools
School Type 1
High School
School Name 1
Golden West
School Type 2
Junior High School
School Name 2
Valley Oak
School Type 3
Grade School
School Name 3
Mineral King
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 408500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 451500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.25' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1958 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2458 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` = 1760348 OR `props-main`.`id` = 1782153 OR `props-main`.`id` = 1779962 OR `props-main`.`id` = 1781352 OR `props-main`.`id` = 1779954 OR `props-main`.`id` = 1779955 OR `props-main`.`id` = 1765781 OR `props-main`.`id` = 1754473 OR `props-main`.`id` = 1776670 OR `props-main`.`id` = 1781631 OR `props-main`.`id` = 1764319 OR `props-main`.`id` = 1772613 OR `props-main`.`id` = 1781921 OR `props-main`.`id` = 1760887 OR `props-main`.`id` = 1788110 OR `props-main`.`id` = 1790387 OR `props-main`.`id` = 1791288 OR `props-main`.`id` = 1770281 OR `props-main`.`id` = 1770802 OR `props-main`.`id` = 1770277 OR `props-main`.`id` = 1709215 OR `props-main`.`id` = 1774023 OR `props-main`.`id` = 1759552 OR `props-main`.`id` = 1781273 OR `props-main`.`id` = 1715923 OR `props-main`.`id` = 1781914 OR `props-main`.`id` = 1783371 OR `props-main`.`id` = 1702973 OR `props-main`.`id` = 1757107 OR `props-main`.`id` = 1757108 OR `props-main`.`id` = 1758598 OR `props-main`.`id` = 1710216 OR `props-main`.`id` = 1764665 OR `props-main`.`id` = 1778891 OR `props-main`.`id` = 1761801 OR `props-main`.`id` = 1783062 OR `props-main`.`id` = 1764500 OR `props-main`.`id` = 1734489 OR `props-main`.`id` = 1751677 OR `props-main`.`id` = 1772142 OR `props-main`.`id` = 1781549 OR `props-main`.`id` = 1793341 OR `props-main`.`id` = 1793339 OR `props-main`.`id` = 1758597 OR `props-main`.`id` = 1755853 OR `props-main`.`id` = 1739384 OR `props-main`.`id` = 1780738 OR `props-main`.`id` = 1780062 OR `props-main`.`id` = 1780087 OR `props-main`.`id` = 1780123 OR `props-main`.`id` = 1781356 OR `props-main`.`id` = 1729923 OR `props-main`.`id` = 1729967 OR `props-main`.`id` = 1729921 OR `props-main`.`id` = 1729912 OR `props-main`.`id` = 1789405 OR `props-main`.`id` = 1789429 OR `props-main`.`id` = 1791845 OR `props-main`.`id` = 1746081 OR `props-main`.`id` = 1746083 OR `props-main`.`id` = 1746151 OR `props-main`.`id` = 1782330 OR `props-main`.`id` = 1766061 OR `props-main`.`id` = 1764591 OR `props-main`.`id` = 1776133 OR `props-main`.`id` = 1773097 OR `props-main`.`id` = 1792604 OR `props-main`.`id` = 1784024 OR `props-main`.`id` = 1793293 OR `props-main`.`id` = 1733869 OR `props-main`.`id` = 1792600 OR `props-main`.`id` = 1792145 OR `props-main`.`id` = 1792645 OR `props-main`.`id` = 1792646 OR `props-main`.`id` = 1783198 OR `props-main`.`id` = 1736560 OR `props-main`.`id` = 1783197 OR `props-main`.`id` = 1776671 OR `props-main`.`id` = 1781347 OR `props-main`.`id` = 1780656 OR `props-main`.`id` = 1782875 OR `props-main`.`id` = 1792557 OR `props-main`.`id` = 1759882 OR `props-main`.`id` = 1754767 OR `props-main`.`id` = 1751617 OR `props-main`.`id` = 1754802 OR `props-main`.`id` = 1762493 OR `props-main`.`id` = 1763167 OR `props-main`.`id` = 1763465 OR `props-main`.`id` = 1792610 OR `props-main`.`id` = 1697959 OR `props-main`.`id` = 1729182 OR `props-main`.`id` = 1729120 OR `props-main`.`id` = 1729401 OR `props-main`.`id` = 1737248 OR `props-main`.`id` = 1697140 OR `props-main`.`id` = 1764490 OR `props-main`.`id` = 1792633 OR `props-main`.`id` = 1770240 OR `props-main`.`id` = 1770304 OR `props-main`.`id` = 1769981 OR `props-main`.`id` = 1783287 OR `props-main`.`id` = 1719338 OR `props-main`.`id` = 1789184 OR `props-main`.`id` = 1784772 OR `props-main`.`id` = 1782502 OR `props-main`.`id` = 1775817 OR `props-main`.`id` = 1778006 OR `props-main`.`id` = 1754828 OR `props-main`.`id` = 1786041 OR `props-main`.`id` = 1786043 OR `props-main`.`id` = 1786040 OR `props-main`.`id` = 1785413 OR `props-main`.`id` = 1785418 OR `props-main`.`id` = 1785411 OR `props-main`.`id` = 1785412)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno653971' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-19' 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();
6
Similar Properties
$440,250
4
3
2,010
0.08
4004 E Oakridge Ave
Visalia, CA 93292
$430,000
4
3
2,208
0.12
627 S Elverta St
Visalia, CA 93292
$429,360
5
3
2,174
0.09
4033 E Oakridge Ave
Visalia, CA 93292
$423,360
4
3
2,010
0.08
4100 E Oakridge Ave
Visalia, CA 93292
Last modified 2 days ago Fresno MLS last checked for updates 14 minutes ago
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.
