IT'S ALL INCLUDED! Washer, Dryer, Refrigerator, backyard landscape, and 2 inch faux blinds. The 1227 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 1-car garage. Tract 6205 Elev8ions HOA Phase Range's are from $103.31 to $136.65 but Build out is estimated at $131.94 (Temporary Sales Office Located at Elev8ions Riverstone)
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built Exception
New Construction
Region
Urban
# of Stories
Two
Price Per Square Foot
$322
Price Per Acre
$8,681,099
Days On Market
30
Cumulative Days On Market
30
County
Fresno
REO / Bank Owned
No
Cross Street Address
Sunnyside & Shepard
Directions
Actual Homesite - Sunnyside and Shepard Temp Model Homes- 189 Nabors Drive S Madera CA 93636
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) >= 375240.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 414739.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) >= 977 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1477 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` = 1636126 OR `props-main`.`id` = 1685407 OR `props-main`.`id` = 1681156 OR `props-main`.`id` = 1701527 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1701322 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1693773 OR `props-main`.`id` = 1685455 OR `props-main`.`id` = 1701557 OR `props-main`.`id` = 1701151 OR `props-main`.`id` = 1701596 OR `props-main`.`id` = 1701489 OR `props-main`.`id` = 1691387 OR `props-main`.`id` = 1691413 OR `props-main`.`id` = 1701346 OR `props-main`.`id` = 1695805 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1685947 OR `props-main`.`id` = 1696570 OR `props-main`.`id` = 1699173 OR `props-main`.`id` = 1690107 OR `props-main`.`id` = 1696276 OR `props-main`.`id` = 1695631 OR `props-main`.`id` = 1693708 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 1679313 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1697704 OR `props-main`.`id` = 1701508 OR `props-main`.`id` = 1701459 OR `props-main`.`id` = 1701437 OR `props-main`.`id` = 1701537 OR `props-main`.`id` = 1698913 OR `props-main`.`id` = 1701433 OR `props-main`.`id` = 1701434 OR `props-main`.`id` = 1701435 OR `props-main`.`id` = 1701535 OR `props-main`.`id` = 1701460 OR `props-main`.`id` = 1701461 OR `props-main`.`id` = 1701462 OR `props-main`.`id` = 1701536 OR `props-main`.`id` = 1701539 OR `props-main`.`id` = 1701436 OR `props-main`.`id` = 1701538 OR `props-main`.`id` = 1701439 OR `props-main`.`id` = 1701440 OR `props-main`.`id` = 1701438 OR `props-main`.`id` = 1693614 OR `props-main`.`id` = 1685068 OR `props-main`.`id` = 1701534 OR `props-main`.`id` = 1688989 OR `props-main`.`id` = 1697889 OR `props-main`.`id` = 1685980 OR `props-main`.`id` = 1701430 OR `props-main`.`id` = 1701631 OR `props-main`.`id` = 1701432 OR `props-main`.`id` = 1697082 OR `props-main`.`id` = 1701633 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1697320 OR `props-main`.`id` = 1696286 OR `props-main`.`id` = 1685082 OR `props-main`.`id` = 1697347 OR `props-main`.`id` = 1699235 OR `props-main`.`id` = 1700153 OR `props-main`.`id` = 1677702 OR `props-main`.`id` = 1677889 OR `props-main`.`id` = 1689630 OR `props-main`.`id` = 1653256 OR `props-main`.`id` = 1699972 OR `props-main`.`id` = 1696333)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640835' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-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();
5
Similar Properties
$399,000
3
3
1,337
0.18
1418 chennault Ave
Clovis, CA 93611
$394,990
3
2.5
1,227
0.05
1520 Redbrick Ln
Clovis, CA 93619
$394,990
3
2.5
1,227
0.05
1532 Redbrick Ln
Clovis, CA 93619
$394,990
3
2.5
1,227
0.05
1492 Vintage Ln
Clovis, CA 93619
Courtesy of Doreen Davis, Wilson Homes, Inc. - [email protected] Last modified 3 weeks ago Fresno MLS last checked for updates 30 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.
