Array
(
[ID] => 12159
[post_author] => 4
[post_date] => 2018-10-30 00:24:04
[post_date_gmt] => 2018-10-30 00:24:04
[post_content] => On the foggy side but not too far. With tongue in cheek, call it Outer Cole Valley if you really can’t stomach life west of Arguello. Classic Edwardians, modern transit, Golden Gate Park adjacent.
ffd_listing_title, 1557 Funston Avenue, San Francisco, CA, 94122
ffd_mls_id, 424011887
ffd_salesforce_id, a0EUd000001IGQjMAO
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 1557 Funston Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1557 Funston Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Shown by open house schedule or by appointments only. For disclosures please email (not text) listing agent Jason Chan at [email protected]. Disclosure link will be emailed to you once it's ready. For questions, please text Jason at 415.215.1661 or Julie at 415.672.7988. Please use San Francisco purchase agreement. Please include Contingency Removal form & signing off the cover page of the disclosure packet. Pre-sale escrow opened w/ WFG National Title Insurance Company with Kathie Ng. Seller reserves the right to accept, counter, or reject any offer.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary
bath_features__c, Double Sinks
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 2023
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Julie Y Chan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-02-28T20:46:49.000+0000
days_on_market__c, 22
dom__c, 22
ffd_description_pb, BRAND NEW HOME meticulously crafted & built in 2023! Step inside this magnificent 4 bed, 4.5 bath home, and you'll be greeted by an inviting open floorplan on the main floor. The common living space seamlessly extends from the front to the back, culminating in large sliding doors that lead to a spacious rear deck. Ascend to the top floor you'll discover 3 primary suites, each offering expansive views. Ground floor offers media room, bedroom with double closets stretching the full length of the room, full bath, and HUGE garage for 4+ cars - A true rare feature in SF! You'll also enjoy access to the landscaped low maintenance yard from both the mid-level deck & the ground floor. This remarkable home is replete with desirable features, incl. owned solar panels, soaring doors throughout, triple panel sliding doors, custom railing, fire sprinkler system for added safety, Ipe wood decking, & abundance of natural light throughout, making it the perfect blend of luxury & functionality. It's ideally situated just short blocks from the N-Judah MUNI lines, shops & restaurants on Irving Street, UCSF, Mount Sutro hiking trails, & renowned attractions such as the Academy of Science, Botanical Garden, Japanese Tea Garden, de Young Museum, and the tranquil Stow Lake in Golden Gate Park!
1557 Funston Avenue, San Francisco, CA, 94122 - Property Description
BRAND NEW HOME meticulously crafted & built in 2023! Step inside this magnificent 4 bed, 4.5 bath home, and you'll be greeted by an inviting open floorplan on the main floor. The common living space seamlessly extends from the front to the back, culminating in large sliding doors that lead to a spacious rear deck. Ascend to the top floor you'll discover 3 primary suites, each offering expansive views. Ground floor offers media room, bedroom with double closets stretching the full length of the room, full bath, and HUGE garage for 4+ cars - A true rare feature in SF! You'll also enjoy access to the landscaped low maintenance yard from both the mid-level deck & the ground floor. This remarkable home is replete with desirable features, incl. owned solar panels, soaring doors throughout, triple panel sliding doors, custom railing, fire sprinkler system for added safety, Ipe wood decking, & abundance of natural light throughout, making it the perfect blend of luxury & functionality. It's ideally situated just short blocks from the N-Judah MUNI lines, shops & restaurants on Irving Street, UCSF, Mount Sutro hiking trails, & renowned attractions such as the Academy of Science, Botanical Garden, Japanese Tea Garden, de Young Museum, and the tranquil Stow Lake in Golden Gate Park!
