Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/648702/28760-Long-Hollow-Ct-S/Coarsegold/https://www.londonproperties.com/images/props/fresno/full/648702.jpgLondon Properties Coarsegold Real Estate | 28760 Long Hollow Ct S
This magnificent 3 bed, 3 bath home seamlessly integrates bold architectural design with natural landscaping. Massive boulders anchor the property to create an unforgettable first impression. With the main home consisting of 2 bedrooms, 2 baths (2161 Sq ft) an addional detached 1 bedroom, 1 bath (473 Sq ft), this home provides the privacy and tranquility you desire. As you step in you cannot help but notice the high ceilings and slanted floor-to-ceiling windows which flood the entire space with bright, morning-to-evening light. Enjoy your morning coffee or evening beverage looking out to the beautiful views of Blackhawk Lake. With a pellet stove and a wood insert fireplace with a curved stone platform wrapped in rustic gray masonry, you can keep warm all winter. The formal dining room is large enough for family dinners and also has a wood burning fireplace. A charming, light-filled kitchen, with a mudroom just outside, combines modern functionality with warm, rustic character including refinished cabinetry, newer gas stove and a wrap around breakfast bar. Both bedrooms are located upstairs and the large primary bedroom with its half wall provides natural light from the windows below and overlooks the spacious living room. The primary bedroom includes a large walk in closet, private bathroom and private deck looking out to morning sunrises and evening sunsets. The detached and updated 1 bedroom and 1 bath includes it's own private entrance, deck, new flooring, bathroom, European style clawfoot tub, and mini split unit. iI is the perfect place to invite guests, family and/or have an income producing property.Expansive decks wrap around the home, providing multiple distinct areas for outdoor entertaining, dining, or relaxing and unforgettable views. Do NOT miss out on this masterpiece of a home.UpgradesRoof repair & certification2 NEW water heatersNEW stoveNEW plumbing for stove & dishwasherNEW septic pumpALL NEW multi level deckingALL decking stained2 stamped concrete retaining walls addedstamped concrete patiocement slab added for kitchen/room extensioniron fencing on ALL decksarchitectural lighting addedNEW irrigation system addedfull landscapeNEW titanium flooring, 9'' x 5' wide plankNEW floorboards3 NEW high rise windowsNEW retractable outdoor curtain/awningtinted film on ALL windows addedall new Interior paintrefinished kitchen cabinets
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1985
Region
Foothill
Unique Conditions
Court Approval Req
# of Stories
Two
Price Per Square Foot
$224
Price Per Acre
$377,564
Days On London
20
Cumulative Days On London
20
County
Madera
Reports Available
Roof, Septic, NHD, Prelim Title Report
Leased Equipment
Propane
Special Features
Isolated Bedroom, Isolated Bathroom, Built In Cabinets, Skylight
REO / Bank Owned
No
Cross Street Address
Long Hollow Dr
Directions
From Fresno going north on Highway 41. Turn left on Yosemite Springs Parkway, left on Long Hollow, left on Long hollow Ct S, Home will be on the right.
Style
Contemporary
Heating & Cooling
Ductless or Split, Evaporative Cool, Floor or Wall Unit, Window or Wall A/C
Laundry
Inside, Utility Room, Electric Hook Up
Roofing
Composition
Foundation
Concrete
Detached Structures
Other/See Remarks
Kitchen
F/S Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator
Dining Room Features
Formal
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower, Tub
Extra Rooms
Great Room
Flooring
Carpet, Laminate
# of Fireplaces
3
Fireplace Type
Wood Insert, Pellet
Exterior
Vinyl
Pool
No
Pool
No
Spa
No
Patio Features
Covered, Uncovered, Enclosed, Concrete, Wood Deck
Yard
Sprinklers Front, Mature Landscape, Garden Area, Drip System
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Community Well
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Work/Shop Area
Are there garage spaces?
Yes
Garage Type
Detached
Garage Spaces
2
Site Amenities
Cul De Sac, Lake View
APN
093 300 009 000
Association / Park Amenities
Pool, Spa, Club House, Green Area, Tennis, Security Guard, Lake/Pond, Playground
HOA Dues
178.00
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Rivergold
School Type 3
Grade School
School Name 3
Rivergold
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 559550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 618450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2384 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2884 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` = 1726475 OR `props-main`.`id` = 1694180 OR `props-main`.`id` = 1717434 OR `props-main`.`id` = 1717601 OR `props-main`.`id` = 1717602 OR `props-main`.`id` = 1717603 OR `props-main`.`id` = 1717604 OR `props-main`.`id` = 1717605 OR `props-main`.`id` = 1716966 OR `props-main`.`id` = 1716595 OR `props-main`.`id` = 1719903 OR `props-main`.`id` = 1718910 OR `props-main`.`id` = 1718896 OR `props-main`.`id` = 1687706 OR `props-main`.`id` = 1731554 OR `props-main`.`id` = 1685636 OR `props-main`.`id` = 1731367 OR `props-main`.`id` = 1727867 OR `props-main`.`id` = 1727890 OR `props-main`.`id` = 1704295 OR `props-main`.`id` = 1703800 OR `props-main`.`id` = 1731418 OR `props-main`.`id` = 1726763 OR `props-main`.`id` = 1726776 OR `props-main`.`id` = 1731326 OR `props-main`.`id` = 1731414 OR `props-main`.`id` = 1701727 OR `props-main`.`id` = 1703501 OR `props-main`.`id` = 1727196 OR `props-main`.`id` = 1728052 OR `props-main`.`id` = 1731383 OR `props-main`.`id` = 1655334 OR `props-main`.`id` = 1731331 OR `props-main`.`id` = 1731471 OR `props-main`.`id` = 1731531 OR `props-main`.`id` = 1666180 OR `props-main`.`id` = 1708116 OR `props-main`.`id` = 1704149 OR `props-main`.`id` = 1704013 OR `props-main`.`id` = 1625902 OR `props-main`.`id` = 1724833 OR `props-main`.`id` = 1726030 OR `props-main`.`id` = 1714763 OR `props-main`.`id` = 1725288 OR `props-main`.`id` = 1666082 OR `props-main`.`id` = 1729357 OR `props-main`.`id` = 1729449 OR `props-main`.`id` = 1702295 OR `props-main`.`id` = 1714047 OR `props-main`.`id` = 1687593 OR `props-main`.`id` = 1725990 OR `props-main`.`id` = 1721266 OR `props-main`.`id` = 1718871 OR `props-main`.`id` = 1700844 OR `props-main`.`id` = 1732169 OR `props-main`.`id` = 1718863 OR `props-main`.`id` = 1733220 OR `props-main`.`id` = 1733238 OR `props-main`.`id` = 1718510 OR `props-main`.`id` = 1718429 OR `props-main`.`id` = 1718458 OR `props-main`.`id` = 1704827 OR `props-main`.`id` = 1713814 OR `props-main`.`id` = 1704840 OR `props-main`.`id` = 1731442 OR `props-main`.`id` = 1700853 OR `props-main`.`id` = 1731407 OR `props-main`.`id` = 1731450 OR `props-main`.`id` = 1687690 OR `props-main`.`id` = 1722852 OR `props-main`.`id` = 1724745 OR `props-main`.`id` = 1724749 OR `props-main`.`id` = 1705132 OR `props-main`.`id` = 1725196 OR `props-main`.`id` = 1724994 OR `props-main`.`id` = 1731691 OR `props-main`.`id` = 1705139 OR `props-main`.`id` = 1703905 OR `props-main`.`id` = 1726456 OR `props-main`.`id` = 1726449 OR `props-main`.`id` = 1666319 OR `props-main`.`id` = 1701326 OR `props-main`.`id` = 1687628 OR `props-main`.`id` = 1717402 OR `props-main`.`id` = 1703925 OR `props-main`.`id` = 1703646 OR `props-main`.`id` = 1703657 OR `props-main`.`id` = 1703656 OR `props-main`.`id` = 1717940 OR `props-main`.`id` = 1712355 OR `props-main`.`id` = 1727402 OR `props-main`.`id` = 1727475 OR `props-main`.`id` = 1712541 OR `props-main`.`id` = 1727542 OR `props-main`.`id` = 1727556 OR `props-main`.`id` = 1731483 OR `props-main`.`id` = 1709899 OR `props-main`.`id` = 1709957 OR `props-main`.`id` = 1674929 OR `props-main`.`id` = 1717964 OR `props-main`.`id` = 1722396 OR `props-main`.`id` = 1718019 OR `props-main`.`id` = 1731676 OR `props-main`.`id` = 1725475 OR `props-main`.`id` = 1725481 OR `props-main`.`id` = 1714054 OR `props-main`.`id` = 1731506 OR `props-main`.`id` = 1714048 OR `props-main`.`id` = 1716191 OR `props-main`.`id` = 1716166 OR `props-main`.`id` = 91486 OR `props-main`.`id` = 1725795 OR `props-main`.`id` = 1726113 OR `props-main`.`id` = 1722603 OR `props-main`.`id` = 1713573 OR `props-main`.`id` = 1683078 OR `props-main`.`id` = 1722853)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648702' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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();
0
Last modified 1 week ago Fresno MLS last checked for updates 7 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.
