Courtesy of Mishelle Westendorf, California Relocation Network - [email protected]
ASK about the 4.25 Interest Rate from the builder for the 1st year. Exceptional 4BD/3.5BA home offering a totoal 2,828 sq ft including garage, the refined coastal living in the heart of Half Moon Bay. Thoughtfully designed with an open-concept layout, the home features a beautifully appointed kitchen that flows seamlessly into the dining and living areas ideal for both everyday living and entertaining.High-quality finishes and designer flooring throughout add warmth and sophistication. The spacious primary suite includes a walk-in closet, while an additional ground-floor bedroom with an ensuite bathroom provides flexibility for guests, office space, or multigenerational living.Green-rated and energy-efficient, the home is equipped with solar panels and is backup battery compatible offering modern sustainability and long-term savings. Additional highlights include an upstairs laundry area and a two-car garage.Unbeatable location just one block from downtown Half Moon Bay with exceptional walkability. Enjoy easy access to cafes, shops, farmers market, fitness studios, and nearby beaches all just minutes from your front door.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1888600 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2087400 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2209 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2709 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` = 1777961 OR `props-main`.`id` = 1778033)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno655451' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-17' 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
Last modified 2 hours ago Fresno MLS last checked for updates 25 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.
