Please provide the following information and Lorelei Van Sack will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.loreleisellshomes.com/agent/20413/lorelei-vansack/property/link/fresno/641701/2041-N-Wagon-Ln/Clovis/https://www.loreleisellshomes.com/images/props/fresno/full/641701.jpgLondon Properties Clovis Real Estate | 2041 N Wagon Ln
Lorelei Van Sack559.826.8808lvansack@londonproperties.comEmail Agent
Property Description
IT'S ALL INCLUDED! Washer, Dryer, Refrigerator, backyard landscape, and 2 inch faux blinds. The 1412 plan provides a perfect space for modern living. It features three bedrooms, 2 baths, a spacious walk-in closet in the primary suite, an upstairs laundry room, and a 2-car garage. Tract 6205 Elev8ions HOA Phase Range's are from $103.31 to $136.65 but Build out is estimated at $131.94 *Models Located at the corner of Sunnyside and Shepherd 2064 N Brindac Lane Clovis, CA 93619
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built Exception
New Construction
Region
Urban
# of Stories
Two
Price Per Square Foot
$326
Price Per Acre
$5,580,993
Days On London
11
Cumulative Days On London
11
County
Fresno
REO / Bank Owned
No
Cross Street Address
Sunnyside & Shepherd
Directions
*Models Located at the corner of Sunnyside and Shepherd 2064 N Brindac Lane Clovis, CA 93619
Heating & Cooling
Central Heat & Cool
Laundry
Inside, On Upper Level
Roofing
Tile
Foundation
Concrete
Kitchen
Dishwasher, Microwave
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower, Tub
Flooring
Carpet, Tile
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
No
Yard
Fenced, Drip System
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows
Solar
Yes
Solar Type
Other
Garage Type
Attached
Garage Spaces
2
APN
NEW/UNDER CONSTRUCTION/NA
Association / Park Amenities
Pool, Landscape Maint, Gated Community, Other/None
HOA Dues
131.94
Frequency
Monthly
School District
Clovis Unified
School Type 1
High School
School Name 1
Clovis North
School Type 2
Grade School
School Name 2
Riverview
School Type 3
Junior High School
School Name 3
Granite Ridge
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 437940.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 484039.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1162 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1662 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` = 1694317 OR `props-main`.`id` = 1705367 OR `props-main`.`id` = 1706636 OR `props-main`.`id` = 1681156 OR `props-main`.`id` = 1701527 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1706700 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1702618 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1704454 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1704908 OR `props-main`.`id` = 1701596 OR `props-main`.`id` = 1703006 OR `props-main`.`id` = 1691387 OR `props-main`.`id` = 1691413 OR `props-main`.`id` = 1706637 OR `props-main`.`id` = 1705084 OR `props-main`.`id` = 1701870 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1685947 OR `props-main`.`id` = 1702737 OR `props-main`.`id` = 1699173 OR `props-main`.`id` = 1690107 OR `props-main`.`id` = 1703454 OR `props-main`.`id` = 1704410 OR `props-main`.`id` = 1704483 OR `props-main`.`id` = 1706083 OR `props-main`.`id` = 1693708 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 1679313 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1703280 OR `props-main`.`id` = 1706078 OR `props-main`.`id` = 1703352 OR `props-main`.`id` = 1704909 OR `props-main`.`id` = 1704814 OR `props-main`.`id` = 1705575 OR `props-main`.`id` = 1704904 OR `props-main`.`id` = 1704883 OR `props-main`.`id` = 1701537 OR `props-main`.`id` = 1701434 OR `props-main`.`id` = 1701539 OR `props-main`.`id` = 1701436 OR `props-main`.`id` = 1701538 OR `props-main`.`id` = 1685068 OR `props-main`.`id` = 1703808 OR `props-main`.`id` = 1701430 OR `props-main`.`id` = 1701631 OR `props-main`.`id` = 1702212 OR `props-main`.`id` = 1703614 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1697320 OR `props-main`.`id` = 1706921 OR `props-main`.`id` = 1705158 OR `props-main`.`id` = 1705157 OR `props-main`.`id` = 1705163 OR `props-main`.`id` = 1705164 OR `props-main`.`id` = 1705159 OR `props-main`.`id` = 1705160 OR `props-main`.`id` = 1701895 OR `props-main`.`id` = 1701896 OR `props-main`.`id` = 1701884 OR `props-main`.`id` = 1701891 OR `props-main`.`id` = 1701892 OR `props-main`.`id` = 1705219 OR `props-main`.`id` = 1701893 OR `props-main`.`id` = 1705383 OR `props-main`.`id` = 1701882 OR `props-main`.`id` = 1701873 OR `props-main`.`id` = 1701901 OR `props-main`.`id` = 1701898 OR `props-main`.`id` = 1702838 OR `props-main`.`id` = 1701878 OR `props-main`.`id` = 1701894 OR `props-main`.`id` = 1701881 OR `props-main`.`id` = 1701880 OR `props-main`.`id` = 1685082 OR `props-main`.`id` = 1704030 OR `props-main`.`id` = 1704441 OR `props-main`.`id` = 1677702 OR `props-main`.`id` = 1704440 OR `props-main`.`id` = 1677889 OR `props-main`.`id` = 1704442)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641701' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-09' 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();
3
Similar Properties
$465,000
3
2.5
1,651
0.04
2037 N Rogers Ln
Clovis, CA 93619
$460,990
3
2.5
1,412
0.09
2047 N Wagon Ln
Clovis, CA 93619
$460,990
3
2.5
1,412
0.09
2083 N Wagon Ln
Clovis, CA 93619
Courtesy of Doreen Davis, Wilson Homes, Inc. - dekmalian@wilsondevelopment.com Last modified 1 month 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.
