Please provide the following information and Lee Ann Kreps will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.leeannk.com/agent/16509/leeann-kreps/property/link/fresno/639846/1106-Significant-Way-W/Madera/https://www.leeannk.com/images/props/fresno/full/639846.jpgLondon Properties Madera Real Estate | 1106 Significant Way W
Lee Ann Kreps559.664.7100leeannk@londonproperties.comEmail Agent
Property Description
Here's your chance to get into the gated area of Riverstone! Elev8ions is only 1 of 2 communities in Riverstone that offers its own private gate, private pool and a connected 360 community without losing the amenities Riverstone has to offer! At only 2 years old, this property offers 3 bedrooms, 2 bathrooms and laundry area upstairs along with your living area, kitchen, dining area and powder room downstairs. Every inch of this property has been well thought out to make is as practical as possible! The kitchen downstairs offers quartz counters, plenty of cabinets, stainless steel gas stove, pantry, pre-wire for pendant lights and plenty of windows for natural lighting. Ask about all the amenities the award winning Riverstone community has to offer!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2023
Region
Urban
# of Stories
Two
Price Per Square Foot
$311
Price Per Acre
$9,550,000
Days On Market
6
Cumulative Days On Market
6
County
Madera
Leased Equipment
Solar Panels
Special Features
Security Gate, Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Nabors Dr S
Directions
From ave 12, South on Riverstone Blvd, gated community on right. Left on Nabors, right on Significant Way
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave
Primary Bedroom Level
Upper
Bath Features
Tub/Shower
Flooring
Carpet, Tile
Exterior
Stucco, Wood, Brick
Pool
Yes
Pool
Yes
Pool Type
In Ground
Patio Features
Uncovered
Yard
Drip System
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
Yes
Solar Type
Lease
Parking Features
Uncovered, Auto Opener, Street
Garage Type
Attached
Garage Spaces
1
APN
080 281 048 000
Association / Park Amenities
Pool, Spa, Club House, Exercise Room, Security Guard, Playground, Landscape Maint, Gated Community
HOA Dues
235.00
Frequency
Monthly
School District
Golden Valley
School Type 1
High School
School Name 1
Liberty
School Type 2
Junior High School
School Name 2
Ranchos
School Type 3
Grade School
School Name 3
Stone Creek
72875
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 362900 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 401100 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` = 1689058 OR `props-main`.`id` = 1686759 OR `props-main`.`id` = 1688126 OR `props-main`.`id` = 1682088 OR `props-main`.`id` = 1695324 OR `props-main`.`id` = 1680641 OR `props-main`.`id` = 1680630 OR `props-main`.`id` = 1685740 OR `props-main`.`id` = 1685741 OR `props-main`.`id` = 1676304 OR `props-main`.`id` = 1676311 OR `props-main`.`id` = 1650911 OR `props-main`.`id` = 1659420 OR `props-main`.`id` = 1680897 OR `props-main`.`id` = 1674430 OR `props-main`.`id` = 1691765 OR `props-main`.`id` = 1691079 OR `props-main`.`id` = 1690933 OR `props-main`.`id` = 1680213 OR `props-main`.`id` = 1673842 OR `props-main`.`id` = 1680120 OR `props-main`.`id` = 1694038 OR `props-main`.`id` = 1670995 OR `props-main`.`id` = 1669671 OR `props-main`.`id` = 1671318 OR `props-main`.`id` = 1691591 OR `props-main`.`id` = 1690090 OR `props-main`.`id` = 1669691 OR `props-main`.`id` = 1690744 OR `props-main`.`id` = 1664689 OR `props-main`.`id` = 1671666 OR `props-main`.`id` = 1690952 OR `props-main`.`id` = 1689042 OR `props-main`.`id` = 1690954 OR `props-main`.`id` = 1690938 OR `props-main`.`id` = 1692326 OR `props-main`.`id` = 1678329 OR `props-main`.`id` = 1694093 OR `props-main`.`id` = 1694693 OR `props-main`.`id` = 1679787 OR `props-main`.`id` = 1686394 OR `props-main`.`id` = 1695087 OR `props-main`.`id` = 1687286 OR `props-main`.`id` = 1684496 OR `props-main`.`id` = 1684490 OR `props-main`.`id` = 1671535 OR `props-main`.`id` = 1671823 OR `props-main`.`id` = 1671802 OR `props-main`.`id` = 1683036 OR `props-main`.`id` = 1683548 OR `props-main`.`id` = 1683733 OR `props-main`.`id` = 1693469 OR `props-main`.`id` = 1673582 OR `props-main`.`id` = 1694473 OR `props-main`.`id` = 1692105 OR `props-main`.`id` = 1684659 OR `props-main`.`id` = 1669630 OR `props-main`.`id` = 1694074 OR `props-main`.`id` = 1694691 OR `props-main`.`id` = 1688462 OR `props-main`.`id` = 1690136 OR `props-main`.`id` = 1688445 OR `props-main`.`id` = 1673738 OR `props-main`.`id` = 1685862 OR `props-main`.`id` = 1689731)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno639846' 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();
4
Similar Properties
$399,999
3
2.5
1,398
0.04
915 Winchell Way W
Madera, CA 93636
$382,500
3
2.5
1,398
0.04
174 S Mission Dr
Madera, CA 93636
$382,000
3
2.5
1,240
0.04
224 Arbor Dr S
Madera, CA 93636
$379,000
3
2.5
1,421
0.04
1109 Royalty Way W
Other, CA 93636
Courtesy of Miguel Gonzalez, Park Place Real Estate - miguel@parkplaceagents.com Last modified 6 days ago Fresno MLS last checked for updates 19 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.
