Lorelei Van Sack559.826.8808lvansack@londonproperties.comEmail Agent
Property Description
New Carpet...Solar Owned! 4 Bedrooms, and 3 full bathroom all have showers. A downstairs bedroom is isolated to the left of the entry way can be used as a Mother-in-Law Suite or college student retreat. It has a full bathroom and extra storage cabinets. The remaining bedrooms and bathrooms are upstairs. Large Master Primary, Master Primary Bathroom Suite with double sink vanity, a separate tub / shower, and walk in closet. The loft can be used as an office, gym, game room, or bedroom. No neighbors behind the home with a view of the mountains. Kitchen has quartz counter tops, a large island that can seat 4, kitchen has custom backsplash, with 42 inch cabinets. The dining area fits a large table allowing for large family and holiday gatherings. Pre-wired for 220 outlet for EV charging. Strolling walkways, parks, the newly developed Loma Vista Shopping Area. Walk or bike to Starbucks!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2020
Region
Urban
# of Stories
Two
Price Per Square Foot
$227
Price Per Acre
$5,973,885
Days On Market
73
Cumulative Days On Market
73
County
Fresno
Reports Available
Prelim Title Report
Special Features
Security System, Built In Cabinets, High Tech Cable, Multi Phone Line
REO / Bank Owned
No
Cross Street Address
Leonard
Directions
X-Streets are Leonard and Bullard
Special Disclosure
Agent/Owner Related
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside, On Upper Level, Electric Hook Up
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Kitchen
F/S Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Breakfast Bar, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 521550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 576450 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) >= 2165 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2665 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` = 1686203 OR `props-main`.`id` = 1683306 OR `props-main`.`id` = 1683282 OR `props-main`.`id` = 1685352 OR `props-main`.`id` = 1689896 OR `props-main`.`id` = 1636687 OR `props-main`.`id` = 1666079 OR `props-main`.`id` = 1666475 OR `props-main`.`id` = 1688235 OR `props-main`.`id` = 1676865 OR `props-main`.`id` = 1676760 OR `props-main`.`id` = 144625 OR `props-main`.`id` = 1685923 OR `props-main`.`id` = 1680740 OR `props-main`.`id` = 1666292 OR `props-main`.`id` = 1688083 OR `props-main`.`id` = 1673064 OR `props-main`.`id` = 1677619 OR `props-main`.`id` = 1679273 OR `props-main`.`id` = 1687797 OR `props-main`.`id` = 1674965 OR `props-main`.`id` = 1660590 OR `props-main`.`id` = 1677279 OR `props-main`.`id` = 1688522 OR `props-main`.`id` = 1685573 OR `props-main`.`id` = 1689862 OR `props-main`.`id` = 1689879 OR `props-main`.`id` = 1632394 OR `props-main`.`id` = 1632372 OR `props-main`.`id` = 1688799 OR `props-main`.`id` = 1678059 OR `props-main`.`id` = 1673063 OR `props-main`.`id` = 1673069 OR `props-main`.`id` = 1683147 OR `props-main`.`id` = 1688567 OR `props-main`.`id` = 1688580 OR `props-main`.`id` = 1688081 OR `props-main`.`id` = 1684817 OR `props-main`.`id` = 1680785 OR `props-main`.`id` = 1683544 OR `props-main`.`id` = 1686935 OR `props-main`.`id` = 1689644 OR `props-main`.`id` = 1678307 OR `props-main`.`id` = 1675331 OR `props-main`.`id` = 1677988 OR `props-main`.`id` = 1677736 OR `props-main`.`id` = 1689217 OR `props-main`.`id` = 1689161 OR `props-main`.`id` = 1686335 OR `props-main`.`id` = 1686200 OR `props-main`.`id` = 1689142 OR `props-main`.`id` = 1679531 OR `props-main`.`id` = 1689264 OR `props-main`.`id` = 1681768 OR `props-main`.`id` = 1681482 OR `props-main`.`id` = 1681441 OR `props-main`.`id` = 1682126 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1676567 OR `props-main`.`id` = 1686063 OR `props-main`.`id` = 1688289 OR `props-main`.`id` = 1689255 OR `props-main`.`id` = 1672917 OR `props-main`.`id` = 1689656 OR `props-main`.`id` = 1663225 OR `props-main`.`id` = 1687976 OR `props-main`.`id` = 1688299 OR `props-main`.`id` = 1689422 OR `props-main`.`id` = 1689257 OR `props-main`.`id` = 1689979 OR `props-main`.`id` = 1689419 OR `props-main`.`id` = 1684221 OR `props-main`.`id` = 1678591 OR `props-main`.`id` = 1678544 OR `props-main`.`id` = 1680228 OR `props-main`.`id` = 1495106 OR `props-main`.`id` = 1495592 OR `props-main`.`id` = 1686182 OR `props-main`.`id` = 1638338 OR `props-main`.`id` = 1683853 OR `props-main`.`id` = 1683905 OR `props-main`.`id` = 1687108 OR `props-main`.`id` = 1687047 OR `props-main`.`id` = 1666199)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno633169' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-15' 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();
1
Similar Properties
$545,000
4
3
2,379
0.10
603 Kaweah
Clovis, CA 93619
Courtesy of Joaquin Valdez, Genesis Realty Genesis Real Estate - jvhomes01@gmail.com Last modified 1 month ago Fresno MLS last checked for updates 19 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.
