_yoast_indexnow_last_ping,1711018715
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!
district__c,SF District 2
driveway_sidewalks__c,Paved Driveway,Paved Sidewalk
entry_level__c,0
external_listing__c,1
fencing__c,Back Yard
fireplace_features__c,Living Room;Gas Piped
pba__floortype_pb__c,Tile;Wood
pba__hoafees__c,0
hoa__c,No
pba__halfbathrooms_pb__c,1
pba__heatingtype_pb__c,Central
ffd_lastmodifieddate,2024-03-21T10:46:52.000+0000
pba__latitude_pb__c,37.7590851
pba__latitude_property__c,37.7590851
laundry_features__c,Upper Floor
listed_date__c,2024-02-28
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Jason
pba__listing_agent_lastname__c,Chan
listing_agent_mls_id__c,802554
ffd_listingagentname,Jason C Chan
listing_agent_number__c,802554
listing_co_agent_mls_id__c,807828
listing_co_agent_number__c,1027382
listing_co_office_mls_id__c,BARBCO
listing_co_office_name__c,BarbCo
listing_co_office_number__c,28297
listing_office_mls_id__c,BARBCO
listing_office_name__c,BarbCo
listing_office_number__c,28297
pba__listingprice_pb__c,3950000
pba__listingtype__c,Sale
pba__longitude_pb__c,-122.4704571
lower_level__c,Bedroom(s),Family Room,Full Bath(s),Garage
mls_id__c,424011887
main_level__c,Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c,Shower Stall(s);Tub;Low-Flow Toilet(s);Double Sinks;Soaking Tub
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,4
on_market_date__c,2024-02-28
open_house_end__c,2024-03-24T16:00:00.000+0000
open_house_start__c,2024-03-24T15:00:00.000+0000
original_price__c,3950000
overall_days_on_market__c,-81872
parking_access__c,Tandem
parking_features__c,Attached,Deck,Interior Access
parking_type__c,On Site (Single Family Only)
pba__pendingdate__c,1800-01-01
possible_bedrooms__c,0
pba__pricechangedat__c,1800-01-01T00:00:00.000+0000
price_per_square_foot__c,1196.97
pba__propertytype__c,Single Family Residence
ListingId,a0EUd000001IGQjMAO
room_type__c,Storage;Office;Kitchen;Living Room;Game Room;Dining Room;Great Room;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Smoke Detector;Carbon Mon Detector;Double Strapped Water Heater
selling_agent_number__c,0
selling_co_agent_number__c,0
selling_co_office_number__c,0
pba__status__c,Active
pba__totalarea_pb__c,3300
size__c,3300
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,Funston
subdist__c,Inner Sunset
ffd_name,1557 Funston Avenue, San Francisco, CA, 94122
view__c,City;Park;Garden/Greenbelt;Downtown;San Francisco;Golden Gate Bridge;Twin Peaks;Mountains;Sutro Tower
website_property_type__c,Single Family Home
pba__yearbuilt_pb__c,2023
pba__postalcode_pb__c,94122
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530737388-1.jpg