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/656020/634-E-San-Miguel-St/Hanford/https://www.londonproperties.com/images/camerashy.pngLondon Properties Hanford Real Estate | 634 E San Miguel St
Courtesy of Cecilia Vasquez Mejia, Century 21 Select Real Estate - [email protected]
Welcome to this stunning, one owner custom home offering 3,105 square feet of meticulously designed living space. From the moment you step into the elegant entry foyer, you will notice the high-end finishes, including recess lighting, plantation shutters, and seamless blend of tile and laminate flooring. The expansive layout features 5 bedrooms and 2.5 bathrooms inside, plus an additional bathroom outside for ultimate convenience. Premium finishes extend across the entire property, as absolutely all bathrooms-including the outdoor bath-feature elegant granite countertops. Both the formal and family living rooms showcase modern, wall-mounted fireplaces set against beautiful stone accent walls. If you work from home, the dedicated office space provides the perfect quiet environment. The heart of the home features a chef's kitchen with granite counter tops and a walk-in pantry. The primary bathroom offers a spa-like retreat with separate sinks, a shower, and a jacuzzi tub. The separate laundry room offer a sink and a dedicated storage closet for maximum daily functionality. The backyard is built out for entertaining, centered around a sparkling pool and spa, a covered patio with recess lighting and ceiling fans. The home is completed by an attached 3-car garage, solar panels and a tankless water heater. Call today for a private tour.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2022
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$251
Price Per Acre
$2,429,819
Days On London
1
Cumulative Days On London
1
County
Kings
REO / Bank Owned
No
Cross Street Address
Flint Ave
Directions
From N 11th Ave and Fargo, go north on 11th Ave, turn right on Flint Ave, turn right onto Mission Dr, turn left onto San Miguel St.
Heating & Cooling
Central Heat & Cool
Laundry
Utility Room
Roofing
Composition
Foundation
Concrete
Kitchen
Gas Appliances, Microwave
Dining Room Features
Living Room/Area, Family Room/Area
Primary Bedroom Level
Main
Bath Features
Shower, Jetted Tub
Flooring
Laminate, Tile
# of Fireplaces
2
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
Yes
Spa Type
In Ground
Patio Features
Covered
Yard
Sprinklers Front, Sprinklers Back, Sprinklers Auto
Gas & Electric
Public Utilities
Sewer / Water
Public Water
Solar
Yes
Solar Type
Power Purchase AGMT
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
3
Site Amenities
Corner
APN
007 480 001 000
School District
Hanford Schools
School Type 1
High School
School Name 1
Hanford
School Type 2
Junior High School
School Name 2
Pioneer
School Type 3
Grade School
School Name 3
Pioneer
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 740050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 817950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2855 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3355 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` = 1782478 OR `props-main`.`id` = 1782539 OR `props-main`.`id` = 1738701 OR `props-main`.`id` = 1739049 OR `props-main`.`id` = 1764280 OR `props-main`.`id` = 1766942 OR `props-main`.`id` = 1739177 OR `props-main`.`id` = 1753162 OR `props-main`.`id` = 1741567 OR `props-main`.`id` = 1741557 OR `props-main`.`id` = 1762466 OR `props-main`.`id` = 1762479 OR `props-main`.`id` = 1778437 OR `props-main`.`id` = 1724791 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1751842 OR `props-main`.`id` = 1767298 OR `props-main`.`id` = 1762326 OR `props-main`.`id` = 1761024 OR `props-main`.`id` = 1761822 OR `props-main`.`id` = 1746210 OR `props-main`.`id` = 1779172 OR `props-main`.`id` = 1779193 OR `props-main`.`id` = 1756192 OR `props-main`.`id` = 1779793 OR `props-main`.`id` = 1750915 OR `props-main`.`id` = 1752088 OR `props-main`.`id` = 1778411 OR `props-main`.`id` = 1762503 OR `props-main`.`id` = 1753362 OR `props-main`.`id` = 1781765 OR `props-main`.`id` = 1776481 OR `props-main`.`id` = 1781869 OR `props-main`.`id` = 1781412 OR `props-main`.`id` = 1776945 OR `props-main`.`id` = 1773072 OR `props-main`.`id` = 1773074 OR `props-main`.`id` = 1776706 OR `props-main`.`id` = 1731799 OR `props-main`.`id` = 1764281 OR `props-main`.`id` = 1680247 OR `props-main`.`id` = 1780770 OR `props-main`.`id` = 1768565 OR `props-main`.`id` = 1766677 OR `props-main`.`id` = 1765402 OR `props-main`.`id` = 1765581 OR `props-main`.`id` = 1758343 OR `props-main`.`id` = 1765475 OR `props-main`.`id` = 1772002 OR `props-main`.`id` = 1750282 OR `props-main`.`id` = 1765998 OR `props-main`.`id` = 1757023 OR `props-main`.`id` = 1781454 OR `props-main`.`id` = 1782719 OR `props-main`.`id` = 1783692 OR `props-main`.`id` = 1718175 OR `props-main`.`id` = 1712967)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno656020' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-29' 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 12 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.
