Courtesy of Sheril Carmona, Tinetti Realty Group - [email protected]
Your dream home is calling! Located within the Green Hills gated community this stunning home has it all with plenty of room to entertain! Hop on your golf cart for a short drive to the Pheasant Run Golf Course, which is all located in this BEAUTIFUL community! This home features 3,874sqft, four bedrooms including a main floor room, four bathrooms, office/den area downstairs, formal dining ell, stunning kitchen that opens to the family room, and so much more! Kitchen shines with its granite countertops, kitchen island, breakfast bar, pantry space, stainless steel appliances, and double oven! Wanting more space? This home offers a good-sized casita with its own entrance that would be perfect for those larger families or a designated space for that man cave you've always wanted! Time to relax? Make your way upstairs to an oversized primary suite! With so much space the possibilities are endless. From a beautiful sitting area to the outside balcony overlooking the sun setting over the water! Across the entry is a primary bath made from your dreams! Featuring his and her sinks/vanities, two large walk-in closets, walk in shower, and soaking tub! Enjoy those nice evenings in your backyard overlooking your private lake! What could top this stunning home off even more? OWNED SOLAR! Keeping those energy bills lower is always a plus! Don't miss your chance and schedule a showing today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2005
Region
Rural
# of Stories
Two
Price Per Square Foot
$139
Price Per Acre
$2,257,119
Days On London
73
Cumulative Days On London
73
County
Madera
REO / Bank Owned
No
Cross Street Address
Tiburon Lane
Directions
Entrance from Golf Drive West, then a left into neighborhood after entering the community
Heating & Cooling
Central Heat & Cool
Laundry
Inside, On Upper Level
Roofing
Tile
Foundation
Concrete
Primary Bedroom Level
Upper
Flooring
Tile
# of Fireplaces
1
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
Yes
Solar Type
Owned
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
014 211 031 000
Association / Park Amenities
Pool, Club House, Tennis, Security Guard, Lake/Pond, Gated Community
HOA Dues
252.00
School District
Madera Unified
School Type 1
High School
School Name 1
Madera
School Type 2
Junior High School
School Name 2
Ranchos
School Type 3
Grade School
School Name 3
George Washington
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 512050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 565950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3624 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4124 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` = 1729032 OR `props-main`.`id` = 1714977 OR `props-main`.`id` = 1714941 OR `props-main`.`id` = 1714947 OR `props-main`.`id` = 1732049 OR `props-main`.`id` = 1732059 OR `props-main`.`id` = 1734255 OR `props-main`.`id` = 1686267 OR `props-main`.`id` = 1686245 OR `props-main`.`id` = 1753602 OR `props-main`.`id` = 1752919 OR `props-main`.`id` = 1752942 OR `props-main`.`id` = 1705655 OR `props-main`.`id` = 1705641 OR `props-main`.`id` = 1750503 OR `props-main`.`id` = 1726383 OR `props-main`.`id` = 1727711 OR `props-main`.`id` = 1727716 OR `props-main`.`id` = 1739016 OR `props-main`.`id` = 1726898 OR `props-main`.`id` = 1715459 OR `props-main`.`id` = 1742752 OR `props-main`.`id` = 1733239 OR `props-main`.`id` = 1727460 OR `props-main`.`id` = 1749034 OR `props-main`.`id` = 1735557 OR `props-main`.`id` = 1744848 OR `props-main`.`id` = 1666536 OR `props-main`.`id` = 1750370 OR `props-main`.`id` = 1678287 OR `props-main`.`id` = 1715647 OR `props-main`.`id` = 1715622 OR `props-main`.`id` = 1715633 OR `props-main`.`id` = 1726796 OR `props-main`.`id` = 1726800 OR `props-main`.`id` = 1753505 OR `props-main`.`id` = 1753313 OR `props-main`.`id` = 1753321 OR `props-main`.`id` = 1721095 OR `props-main`.`id` = 1732152 OR `props-main`.`id` = 1724265 OR `props-main`.`id` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1741743 OR `props-main`.`id` = 1749419 OR `props-main`.`id` = 1715744 OR `props-main`.`id` = 1727222 OR `props-main`.`id` = 1727207 OR `props-main`.`id` = 1732730 OR `props-main`.`id` = 1732657 OR `props-main`.`id` = 1732699 OR `props-main`.`id` = 1727062 OR `props-main`.`id` = 1727191 OR `props-main`.`id` = 1727545 OR `props-main`.`id` = 1723311 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1744915 OR `props-main`.`id` = 1730883 OR `props-main`.`id` = 1730993 OR `props-main`.`id` = 1731185 OR `props-main`.`id` = 1726733 OR `props-main`.`id` = 1726793 OR `props-main`.`id` = 1741745 OR `props-main`.`id` = 1741698 OR `props-main`.`id` = 1726734 OR `props-main`.`id` = 1726794 OR `props-main`.`id` = 1727729 OR `props-main`.`id` = 1748550)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648884' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-27' 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 4 hours 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.
