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. The kitchen features granite countertops, a center island, ample cabinetry, and generous prep space, flowing seamlessly into the dining and living areas. 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, mature palm trees, 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 two-car garage. 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
$204
Price Per Acre
$3,888,408
Days On London
0
Cumulative Days On London
0
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) >= 427025 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 471975 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` = 1725694 OR `props-main`.`id` = 1743480 OR `props-main`.`id` = 1754473 OR `props-main`.`id` = 1764319 OR `props-main`.`id` = 1733078 OR `props-main`.`id` = 1758596 OR `props-main`.`id` = 1762784 OR `props-main`.`id` = 1760894 OR `props-main`.`id` = 1760893 OR `props-main`.`id` = 1760887 OR `props-main`.`id` = 1760519 OR `props-main`.`id` = 1709215 OR `props-main`.`id` = 1759552 OR `props-main`.`id` = 1761410 OR `props-main`.`id` = 1715923 OR `props-main`.`id` = 1734271 OR `props-main`.`id` = 1713958 OR `props-main`.`id` = 1739449 OR `props-main`.`id` = 1726669 OR `props-main`.`id` = 1728244 OR `props-main`.`id` = 1728437 OR `props-main`.`id` = 1702973 OR `props-main`.`id` = 1757107 OR `props-main`.`id` = 1757108 OR `props-main`.`id` = 1758598 OR `props-main`.`id` = 1709611 OR `props-main`.`id` = 1710216 OR `props-main`.`id` = 1746471 OR `props-main`.`id` = 1746462 OR `props-main`.`id` = 1746469 OR `props-main`.`id` = 1746457 OR `props-main`.`id` = 1756137 OR `props-main`.`id` = 1732859 OR `props-main`.`id` = 1761801 OR `props-main`.`id` = 1751694 OR `props-main`.`id` = 1735836 OR `props-main`.`id` = 1722865 OR `props-main`.`id` = 1764500 OR `props-main`.`id` = 1753742 OR `props-main`.`id` = 1734489 OR `props-main`.`id` = 1753371 OR `props-main`.`id` = 1751677 OR `props-main`.`id` = 1762431 OR `props-main`.`id` = 1748356 OR `props-main`.`id` = 1738870 OR `props-main`.`id` = 1752915 OR `props-main`.`id` = 1764581 OR `props-main`.`id` = 1764577 OR `props-main`.`id` = 1755027 OR `props-main`.`id` = 1754369 OR `props-main`.`id` = 1759591 OR `props-main`.`id` = 1732893 OR `props-main`.`id` = 1757111 OR `props-main`.`id` = 1757077 OR `props-main`.`id` = 1756263 OR `props-main`.`id` = 1758597 OR `props-main`.`id` = 1755853 OR `props-main`.`id` = 1739384 OR `props-main`.`id` = 1755485 OR `props-main`.`id` = 1764250 OR `props-main`.`id` = 1729923 OR `props-main`.`id` = 1729967 OR `props-main`.`id` = 1729921 OR `props-main`.`id` = 1729912 OR `props-main`.`id` = 1746081 OR `props-main`.`id` = 1746083 OR `props-main`.`id` = 1746151 OR `props-main`.`id` = 1724414 OR `props-main`.`id` = 1764591 OR `props-main`.`id` = 1748889 OR `props-main`.`id` = 1755460 OR `props-main`.`id` = 1720320 OR `props-main`.`id` = 1719633 OR `props-main`.`id` = 1760880 OR `props-main`.`id` = 1728195 OR `props-main`.`id` = 1733869 OR `props-main`.`id` = 1755454 OR `props-main`.`id` = 1749804 OR `props-main`.`id` = 1746756 OR `props-main`.`id` = 1736560 OR `props-main`.`id` = 1746755 OR `props-main`.`id` = 1719888 OR `props-main`.`id` = 1755409 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` = 1754520 OR `props-main`.`id` = 1755466 OR `props-main`.`id` = 1697959 OR `props-main`.`id` = 1755436 OR `props-main`.`id` = 1729182 OR `props-main`.`id` = 1741374 OR `props-main`.`id` = 1741418 OR `props-main`.`id` = 1724526 OR `props-main`.`id` = 1741451 OR `props-main`.`id` = 1741481 OR `props-main`.`id` = 1744703 OR `props-main`.`id` = 1744661 OR `props-main`.`id` = 1723428 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` = 1738145 OR `props-main`.`id` = 1726792 OR `props-main`.`id` = 1747464 OR `props-main`.`id` = 1719338 OR `props-main`.`id` = 1745245 OR `props-main`.`id` = 1740668 OR `props-main`.`id` = 1722867 OR `props-main`.`id` = 1754828 OR `props-main`.`id` = 1719039 OR `props-main`.`id` = 1730795 OR `props-main`.`id` = 1719026 OR `props-main`.`id` = 1719022 OR `props-main`.`id` = 1734073 OR `props-main`.`id` = 1712782 OR `props-main`.`id` = 1719010)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno653971' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-20' 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();
4
Similar Properties
$449,990
5
3
2,174
0.09
4009 E Oakridge Ave
Visalia, CA 93292
$445,990
4
3
2,010
0.09
3929 E Oakridge Ave
Visalia, CA 93292
$439,880
4
3
2,010
0.08
4020 Oakridge Ave
Visalia, CA 93292
$430,000
4
3
2,116
0.11
549 S Elverta St
Visalia, CA 93292
Last modified 1 hour ago Fresno MLS last checked for updates 1 minute 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.
