Please provide the following information and Valiant Reyes will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.valiantrealtor.com/agent/22682/valiant-reyes/property/link/crmls/41107577/1697-Via-Milano/Gustine/https://www.valiantrealtor.com/images/props/crmls/full/41107577.jpgLondon Properties Gustine Real Estate | 1697 Via Milano
Ideal home with Bedroom Downstairs!! and access to full bathroom!! 4 bed 3 bath over 2,500sq ft of living space. Large backyard ready for summer bbq, Hurry this is a great chance to get your dream home. Beautifful Kitchen, Cathedral Ceilings, Livingroom, and a family room. 3 car garage. Extra large Primary Bedroom.
Property Sub Type
Single Family Residence
Year Built
2004
Levels
Two
Price Per Square Foot
$215
Days On Market
59
Cumulative Days On Market
59
County Or Parish
Merced
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Follow GPS Cross Street: Via Marsala.
Architectural Style
Contemporary
Room Type
Family Room, Kitchen
Heating
Forced Air
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Dryer Included, Washer Included
Roof
Tile
Construction Materials
Stucco
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Appliances Y/N
Yes
Flooring
Laminate, Carpet
Fireplace Y/N
Yes
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Patio And Porch Features
Patio
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage, Garage Door Opener
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Level with Street, Back Yard, Front Yard
Lot Size Area
6000.0000
Lot Size Units
Square Feet
Parcel Number
021010017000
Subdivision Name
Other
Subdivision Name Other
Other
Association Y/N
No
72876
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 522500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 577500 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) >= 2305 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2805 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` = 1657726 OR `props-main`.`id` = 1682555 OR `props-main`.`id` = 1682467 OR `props-main`.`id` = 1685859 OR `props-main`.`id` = 1682371 OR `props-main`.`id` = 1681436 OR `props-main`.`id` = 1681424 OR `props-main`.`id` = 1683643 OR `props-main`.`id` = 1688405 OR `props-main`.`id` = 1676332 OR `props-main`.`id` = 1669932 OR `props-main`.`id` = 1682623 OR `props-main`.`id` = 1674336 OR `props-main`.`id` = 1682835 OR `props-main`.`id` = 1671771 OR `props-main`.`id` = 1687012 OR `props-main`.`id` = 1664599 OR `props-main`.`id` = 1669856 OR `props-main`.`id` = 1684539 OR `props-main`.`id` = 1687850 OR `props-main`.`id` = 1655992 OR `props-main`.`id` = 1682085 OR `props-main`.`id` = 1679401 OR `props-main`.`id` = 1685483)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41107577' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-07' 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
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.