Please provide the following information and Juan-Carlos Mora will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.jcmrealtor.com/agent/16681/juancarlos-mora/property/link/crmls/FR26024961/858-S-Philip-Ave/Fowler/https://www.jcmrealtor.com/images/props/crmls/full/FR26024961.jpgLondon Properties Fowler Real Estate | 858 S Philip Ave
Listing Agent: Juan Carlos Mora, London Properties
This stunning K. Hovnanian home in the Aspire at Sunnyside community has the perfectly blends of modern design, comfort, and functionality. The thoughtfully designed residence offers 5 spacious bedrooms, 3.5 bathrooms, and a versatile upstairs loft. The main level features a beautiful open-concept kitchen with quartz countertops and stainless-steel appliances, seamlessly connecting to the family room and dining area ideal for both entertaining and everyday living. Also on the first floor is a private bedroom suite, perfect for guests or multi-generational living. Upstairs, the expansive loft provides additional space for relaxation, work, or play. The luxurious primary suite includes a large walk-in closet and a spa-inspired bathroom. Step outside to enjoy the generously sized backyard, offering plenty of room to relax or create your own outdoor retreat. This is a wonderful opportunity to make this exceptional home your own.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2025
Year Built Source
Builder
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Entry Location
Main
Price Per Square Foot
$212
Days On London
21
Cumulative Days On London
21
County Or Parish
Fresno
New Construction Y/N
Yes
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
From 99 South, exit 124 toward Clovis Ave, turn right onto S Clovis Ave, left onto E South Ave, right onto S Sunnyside Ave, turn right onto W Marc Ave, turn left S Argyle Ave, turn right onto W Ryan Ave, right onto S Philip Ave and property on right
Room Type
Den, Loft
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside
Roof
Tile
Construction Materials
Concrete, Stucco
Window Features
Double Pane Windows
Foundation Details
Concrete Perimeter
Main Level Bedrooms
4
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Bathrooms Half
1
Main Level Bathrooms
2
Room Kitchen Features
Quartz Counters
Eating Area
Area, In Kitchen
Appliances Y/N
Yes
Appliances
Dishwasher, Disposal, Gas Range, Water Heater
Room Bathroom Features
Double Sinks in Primary Bath, Walk-in shower
Interior Features
2 Staircases,Quartz Counters
Flooring
Carpet, Vinyl
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage Faces Front
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Front Yard, Sprinklers In Front
Lot Size Area
6300.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Neighborhood
Sprinklers Y/N
Yes
Fencing
Wood
Common Interest
None
Parcel Number
34526105S
Additional Parcels Y/N
No
Zoning
R1
Community Features
Street Lights
Senior Community Y/N
No
Association Y/N
No
High School District
Fowler Unified
Elementary School
Marshall
Middle Or Junior School
Sutter
High School
Other
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
None
Tax Tract Number
6405
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 503490.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 556489.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2252 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2752 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` = 1701699 OR `props-main`.`id` = 1696622 OR `props-main`.`id` = 1696610 OR `props-main`.`id` = 1701820 OR `props-main`.`id` = 1701849 OR `props-main`.`id` = 1701862 OR `props-main`.`id` = 1705578 OR `props-main`.`id` = 1705593 OR `props-main`.`id` = 1705600 OR `props-main`.`id` = 1705451 OR `props-main`.`id` = 1705613 OR `props-main`.`id` = 1705620 OR `props-main`.`id` = 1696626 OR `props-main`.`id` = 1694210 OR `props-main`.`id` = 1710077 OR `props-main`.`id` = 1691229 OR `props-main`.`id` = 1696125 OR `props-main`.`id` = 1654710 OR `props-main`.`id` = 1684612 OR `props-main`.`id` = 1708482 OR `props-main`.`id` = 1705811 OR `props-main`.`id` = 1681207)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR26024961' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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
$539,990
5
4
2,502
0.14
873 S Philip
Fowler, CA 93625
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.