Please provide the following information and Ashley Lovrencevic will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.hanfordlemoorehomes.com/agent/15077/ashley-lovrencevic/property/link/crmls/FR25167815/4154-N-Sandrini-Ave/Fresno/https://www.hanfordlemoorehomes.com/images/props/crmls/full/FR25167815.jpgLondon Properties Fresno Real Estate | 4154 N Sandrini Ave
Listing Agent: Ashley Lovrencevic, London Properties
Welcome to this stunning 3-bedroom, 2.5-bathroom home located on a large corner lot with OWNED SOLAR! Inside, you'll find gorgeous upgraded flooring, premium tile throughout, and stylish touches like a custom backsplash, rich dark wood cabinetry, and beautiful granite countertops. The open-concept kitchen is perfect for entertaining and flows seamlessly into the living space. Upstairs, a spacious loft offers endless possibilities- it can easily be converted into a 4th bedroom or serve as an ideal second living area for kids or guests. All bedrooms are generously sized, featuring custom built-in cabinetry in the closets for optimal storage. The owner's suite is a true retreat with two walk-in closets and a luxurious bathroom boasting high-end finishes. Step outside to a professionally landscaped backyard complete with a large cement patio, pergola, and a lush grass area- perfect for gatherings and relaxation. Don't miss your chance to own this beautiful, energy-efficient home with modern upgrades throughout. Schedule your private showing today! Bed count and lot size differ from tax records. Buyer to verify if important.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2022
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Entry Location
front door
Price Per Square Foot
$237
Days On Market
78
Cumulative Days On Market
78
County Or Parish
Fresno
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
From Shaw Ave, turn right onto Biola, left onto N Hayes Ave, right onto W Holland Ave, then left onto N Sandrini Ave. The home will be on the left hand side.
Room Type
All Bedrooms Up, Loft
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside, Upper Level
Main Level Bedrooms
0
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Main Level Bathrooms
1
Appliances Y/N
Yes
Appliances
Dishwasher, Disposal, Gas Oven, Gas Range, Microwave
Flooring
Carpet, Tile
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Spa Y/N
No
Spa Features
None
Patio Y/N
Yes
Patio And Porch Features
Patio Open
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage - Two Door
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Corner Lot
Lot Size Area
4025.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Neighborhood
Fencing
Wood
Common Interest
None
Parcel Number
51225227S
Additional Parcels Y/N
No
Community Features
Sidewalks
Senior Community Y/N
No
Association Y/N
No
High School District
Central Unified
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
None
Tax Lot
49
Tax Tract Number
6271
Tax Census Tract
38.12
72873
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 440800 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 487200 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1704 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2204 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` = 1682087 OR `props-main`.`id` = 1687092 OR `props-main`.`id` = 160601 OR `props-main`.`id` = 1666420 OR `props-main`.`id` = 1681830 OR `props-main`.`id` = 1679389 OR `props-main`.`id` = 1665977 OR `props-main`.`id` = 1689441 OR `props-main`.`id` = 1689445 OR `props-main`.`id` = 1678206 OR `props-main`.`id` = 1681958 OR `props-main`.`id` = 1684376 OR `props-main`.`id` = 1673960 OR `props-main`.`id` = 985326 OR `props-main`.`id` = 249079 OR `props-main`.`id` = 1661900 OR `props-main`.`id` = 1666104 OR `props-main`.`id` = 1678143 OR `props-main`.`id` = 1685432 OR `props-main`.`id` = 1684856 OR `props-main`.`id` = 230296 OR `props-main`.`id` = 858027 OR `props-main`.`id` = 1689262 OR `props-main`.`id` = 1689271 OR `props-main`.`id` = 1689270 OR `props-main`.`id` = 1689238 OR `props-main`.`id` = 1681946 OR `props-main`.`id` = 1646642 OR `props-main`.`id` = 283623 OR `props-main`.`id` = 1689239 OR `props-main`.`id` = 1689259 OR `props-main`.`id` = 1668325 OR `props-main`.`id` = 1686421 OR `props-main`.`id` = 1685216 OR `props-main`.`id` = 1685919 OR `props-main`.`id` = 1687851 OR `props-main`.`id` = 1688659 OR `props-main`.`id` = 1684546 OR `props-main`.`id` = 1678272 OR `props-main`.`id` = 1678791 OR `props-main`.`id` = 1677232 OR `props-main`.`id` = 1677235 OR `props-main`.`id` = 1687094 OR `props-main`.`id` = 1677246 OR `props-main`.`id` = 1678826 OR `props-main`.`id` = 1679148 OR `props-main`.`id` = 1686244 OR `props-main`.`id` = 1680229 OR `props-main`.`id` = 1688794 OR `props-main`.`id` = 1679183 OR `props-main`.`id` = 1684383 OR `props-main`.`id` = 1688419 OR `props-main`.`id` = 1679416 OR `props-main`.`id` = 1679718 OR `props-main`.`id` = 1685603 OR `props-main`.`id` = 1683999 OR `props-main`.`id` = 1685602 OR `props-main`.`id` = 1680765 OR `props-main`.`id` = 1689220 OR `props-main`.`id` = 1685989 OR `props-main`.`id` = 1688199 OR `props-main`.`id` = 1683211 OR `props-main`.`id` = 1688565 OR `props-main`.`id` = 1664325 OR `props-main`.`id` = 1681950 OR `props-main`.`id` = 1676791 OR `props-main`.`id` = 1677783 OR `props-main`.`id` = 1666027 OR `props-main`.`id` = 1688311 OR `props-main`.`id` = 280658 OR `props-main`.`id` = 1684526 OR `props-main`.`id` = 1677730 OR `props-main`.`id` = 1679373 OR `props-main`.`id` = 1688960 OR `props-main`.`id` = 1681699 OR `props-main`.`id` = 1666265 OR `props-main`.`id` = 1623993 OR `props-main`.`id` = 1624007 OR `props-main`.`id` = 1674638 OR `props-main`.`id` = 1624009 OR `props-main`.`id` = 1665944 OR `props-main`.`id` = 1665945 OR `props-main`.`id` = 1657011 OR `props-main`.`id` = 1545586 OR `props-main`.`id` = 1688466 OR `props-main`.`id` = 1666343 OR `props-main`.`id` = 1674570 OR `props-main`.`id` = 1677263 OR `props-main`.`id` = 1669960 OR `props-main`.`id` = 1686085 OR `props-main`.`id` = 1686156 OR `props-main`.`id` = 1686122 OR `props-main`.`id` = 1665855 OR `props-main`.`id` = 1684086 OR `props-main`.`id` = 1671895 OR `props-main`.`id` = 1635364 OR `props-main`.`id` = 1683789 OR `props-main`.`id` = 1683749 OR `props-main`.`id` = 1683761 OR `props-main`.`id` = 1680552 OR `props-main`.`id` = 1679108 OR `props-main`.`id` = 1657743 OR `props-main`.`id` = 166957 OR `props-main`.`id` = 1679271 OR `props-main`.`id` = 1679701 OR `props-main`.`id` = 1673822 OR `props-main`.`id` = 1683647 OR `props-main`.`id` = 1683734 OR `props-main`.`id` = 1687821 OR `props-main`.`id` = 1683781 OR `props-main`.`id` = 1674315 OR `props-main`.`id` = 1678847 OR `props-main`.`id` = 1686000 OR `props-main`.`id` = 1678446)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR25167815' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-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();
1
Similar Properties
$445,000
4
3
1,860
0.14
6168 W Scott Ave
Fresno, CA 93723
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.