Introducing our beauitful 4 bedrrom,2 bath floor plan that we believe you will love. This open floor plan is designed for entertaining guests, featuring a spacious kitchen equipped with an island and elegant granite countertops. The kitchen offers ample room for cooking and comes with plenty of cabinets for storage, making it both functional and stylish. Additionally, the primary suite is designed to be roomy and inviting, providing a perfect retreat at the end of the day. We invite you to explore this new floor plan and look forward to your feedback.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2026
Year Built Source
Builder
Days On London
42
Cumulative Days On London
42
County
Fresno
Property Condition
New Construction
New Construction
Yes
Stories
1
Directions to Property
Monterey Homes is committed to providing equal housing opportunities for all buyers. Directions to Property North on Academy Ave, East on Parlier, South Mendocino Ave, East on Fifth street
Foundation Details
Slab
Roof
Composition
Heating
Central
Cooling
Central Air
Laundry Features
Laundry Room
Bathrooms Total (Integer)
2
Full Baths
2.0
Full Baths
2
Appliances
Electric Range
Fireplace Y/N
No
Flooring
Carpet, Vinyl
Private Pool
No
Spa
No
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 385605 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 426195 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1386 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1886 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` = 1726987 OR `props-main`.`id` = 1727005 OR `props-main`.`id` = 1718675 OR `props-main`.`id` = 1734501 OR `props-main`.`id` = 1732039 OR `props-main`.`id` = 1715705 OR `props-main`.`id` = 1758284 OR `props-main`.`id` = 1689324 OR `props-main`.`id` = 1715703 OR `props-main`.`id` = 1750063 OR `props-main`.`id` = 1750064 OR `props-main`.`id` = 1750065 OR `props-main`.`id` = 1765664 OR `props-main`.`id` = 1765679)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare242854' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-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();
4
Similar Properties
$404,900
4
2
1,544
0.12
13463 Fifth St #Lot13
Parlier, CA 93648
$404,900
4
2
1,544
0.12
13487 Fifth St #Lot15
Parlier, CA 93648
$404,900
4
2
1,544
0.12
13463 Fifth St #Lot13
Parlier, CA 93648
$404,900
4
2
1,544
0.12
13487 Fifth St #Lot15
Parlier, CA 93648
Courtesy of Liz Madrid, Bloom Group, Inc.
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.
