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/637254/5494-E-International-Ave/Clovis/https://www.londonproperties.com/images/props/fresno/full/637254.jpgLondon Properties Clovis Real Estate | 5494 E International Ave
Welcome to your dream home at 5454 E International Ave, Clovis, CA 93619! This stunning 4-bedroom, 3-bathroom residence offers modern elegance and timeless comfort in the heart of Clovis. Spanning 2,734 sq ft on 2.7 acres of land, this beautifully designed home features an open-concept living area with soaring ceilings, abundant natural light, and premium finishes throughout. The gourmet kitchen with an island is perfect for entertaining. The luxurious primary suite includes a spa-inspired bathroom and generous closet space. Situated in a top-rated school district and close to shopping, dining, and parks, this home combines convenience with sophistication. Don't miss the opportunity to own this Clovis gemschedule your private tour today!br
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 760000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 840000 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) >= 2484 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2984 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` = 1685947 OR `props-main`.`id` = 1696276 OR `props-main`.`id` = 1693708 OR `props-main`.`id` = 1679516 OR `props-main`.`id` = 1684006 OR `props-main`.`id` = 1697088 OR `props-main`.`id` = 1697087 OR `props-main`.`id` = 1685077 OR `props-main`.`id` = 1697086 OR `props-main`.`id` = 1697085 OR `props-main`.`id` = 1693614 OR `props-main`.`id` = 1685068 OR `props-main`.`id` = 1697083 OR `props-main`.`id` = 1693615 OR `props-main`.`id` = 1693612 OR `props-main`.`id` = 1688989 OR `props-main`.`id` = 1697889 OR `props-main`.`id` = 1685980 OR `props-main`.`id` = 1690721 OR `props-main`.`id` = 1697082 OR `props-main`.`id` = 1686437 OR `props-main`.`id` = 1687299 OR `props-main`.`id` = 1697320 OR `props-main`.`id` = 1696286 OR `props-main`.`id` = 1685082 OR `props-main`.`id` = 1697347 OR `props-main`.`id` = 1697691 OR `props-main`.`id` = 1677702 OR `props-main`.`id` = 820696 OR `props-main`.`id` = 1690411 OR `props-main`.`id` = 1693311 OR `props-main`.`id` = 1677889 OR `props-main`.`id` = 1690432 OR `props-main`.`id` = 1674389 OR `props-main`.`id` = 1689630 OR `props-main`.`id` = 1653256 OR `props-main`.`id` = 1689446 OR `props-main`.`id` = 1696333 OR `props-main`.`id` = 1694812)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637254' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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();
0
Courtesy of Celso Romero, Golden View Realty - [email protected] Last modified 3 days 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.
