Please provide the following information and Edgar Gomez will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/agent/16820/edgar-gomez/property/link/fresno/633026/4626-N-Arrow-Ridge-Way/Clovis/https://www.londonproperties.com/images/props/fresno/full/633026.jpgLondon Properties Clovis Real Estate | 4626 N Arrow Ridge Way
Gorgeous home located in the gated community of Quail Lakes with views of the Sierras, a private park next door and an orchard. This home is perfect, three car garage, and a front formal living room that is open to the second floor library. A formal dining area adjacent to a cook's dream of a kitchen. Plenty of space on the quartz counter tops for those gourmet creations and an abundance of cabinetry. In the center is a chef's island with lots of storage and also a dry bar, A large eating area with views of the back plus and eating bar makes this a terrific kitchen. The large family room is a great place to gather that is next to the kitchen. A utility room, bedroom and bath on the lower lever. The stairway leads you to the upper level with library and the rest of the rooms. The primary bedroom is spacious and has a private balcony where you can enjoy your morning drink and look over the orchard to the views of the mountains. The primary bath has two walk in closets, separate his and hers vanities, a jetted tub, and shower.There are also three nice sized bedrooms and a bathroom on the second level. The backyard is a great place to relax and entertain. There is a nice shed for storage, covered patio, garden area and mature landscaping. Plenty of room on the side of the home for storage of a boat or other recreational items. You also have access to the community center, pool and the Lake. Let's make an appointment today to see!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2003
Region
Urban
# of Stories
Two
Price Per Square Foot
$223
Price Per Acre
$3,742,661
Days On Market
140
Cumulative Days On Market
208
County
Fresno
Special Features
Security Gate, Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Waterside/Vista Sierra
Directions
Shaw Ave, South on N. Quail Lake Drive, check in with security, east on Waterside Drive, East on Vista Sierra, North on Emerald Peak Drive, East on Crown Ridge to Arrow Ridge.
Pool, Club House, Green Area, Security Guard, Playground
HOA Dues
300.00
Frequency
Monthly
School District
Sanger
School Type 1
High School
School Name 1
Sanger
School Type 2
Junior High School
School Name 2
Fairmont
School Type 3
Grade School
School Name 3
Quail Lake Charter
Seller Will Consider
Government, Conventional, Cash
1st Loan Type
Non-Assumable
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 726750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 803250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3179 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3679 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` = 1666083 OR `props-main`.`id` = 1666237 OR `props-main`.`id` = 1694880 OR `props-main`.`id` = 1683540 OR `props-main`.`id` = 1683530 OR `props-main`.`id` = 1685405 OR `props-main`.`id` = 1691808 OR `props-main`.`id` = 274621 OR `props-main`.`id` = 1690250 OR `props-main`.`id` = 1673667 OR `props-main`.`id` = 1689235 OR `props-main`.`id` = 849021 OR `props-main`.`id` = 1693985 OR `props-main`.`id` = 1670841 OR `props-main`.`id` = 1687510 OR `props-main`.`id` = 1671041 OR `props-main`.`id` = 1665864 OR `props-main`.`id` = 1636728 OR `props-main`.`id` = 1636687 OR `props-main`.`id` = 1666079 OR `props-main`.`id` = 1676760 OR `props-main`.`id` = 656330 OR `props-main`.`id` = 1671669 OR `props-main`.`id` = 232981 OR `props-main`.`id` = 1693969 OR `props-main`.`id` = 1693765 OR `props-main`.`id` = 1689269 OR `props-main`.`id` = 1685960 OR `props-main`.`id` = 1677619 OR `props-main`.`id` = 1664638 OR `props-main`.`id` = 1677279 OR `props-main`.`id` = 1679509 OR `props-main`.`id` = 1677595 OR `props-main`.`id` = 1686722)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno633026' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-18' 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 Diann Savage, Century 21 Select Real Estate - [email protected] Last modified 3 months ago Fresno MLS last checked for updates 24 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.
