meta_query='key:subdist__c;value:Ashbury Heights;Buena Vista Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216473' posts_per_page=4 post_type=property
bool(false)
string(0) ""
ffd_listing_title, 1154 Clayton Street, San Francisco, CA, 94117
ffd_mls_id, 511771
ffd_salesforce_id, a0E1I00000TvTe9UAF
num_of_fireplaces__c, 2
num_of_rooms__c, 7
of_units__c, 0
address2__c, 1154 Clayton Street, San Francisco, CA, 94117
pba__address_pb__c, 1154 Clayton Street, San Francisco, CA, 94117
agent_only_remarks__c, Offer date - mon 1/25 by 2PM. No pre-emptives. Book app't here: https://calendly.com/hugh-groocock/1154-clayton. DP avail now at D.io (click above in mls). More details @ www.1154Clayton.com. All offers to be on SFAR form w/signed cover of DP. Provide proof of financing w/offers. Pls no personal buyer-letters w/offers. Pls review all virtuals in MLS. All showings to follow covid-safe protocol - bring yr own sanitizer & mask & do not touch stuff / clean up what you touch. Send PEAD.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Double Oven
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1914
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-01-13T11:45:42.000+0000
days_on_market__c, 917
dom__c, 12
ffd_description_pb, Immaculate, artfully-redesigned 3BR+office view home just blocks to Cole Valley retail. Enviable indoor-outdoor flow w/direct access to patio & landscaped yard. Polished renovation (featured in design mags) & extensive system upgrades for the discerning buyer, including extra steel & concrete down. Thoughtful stewardship includes well-preserved craftsman touches. Tailored public rooms. 3 sumptuous BR's + zoom office alcove on upper level. Chef's kitchen w/center island, b'fast bar seating & pantry. All the toys a chef could want: 2 ovens, beverage-cooler, pot-filler. Internal-access garage for 2 cars w/3rd car in driveway. Ample storage in garage. Easily-accessible attic provides tons of storage. Laundry center on bedroom level. Bold steampunk style powder room. Exquisitely appointed ensuite bathroom & guest bath. Luxe details include dual glazed windows, electric / designer shades & drapes, automated lights & dual-zone heating. Views to ocean, GGB & Marin! Impressive curb appeal.
district__c, SF District 5
electric__c, 220 Volts in Kitchen
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning;Dining Room
1154 Clayton Street, San Francisco, CA, 94117 - Property Description
Immaculate, artfully-redesigned 3BR+office view home just blocks to Cole Valley retail. Enviable indoor-outdoor flow w/direct access to patio & landscaped yard. Polished renovation (featured in design mags) & extensive system upgrades for the discerning buyer, including extra steel & concrete down. Thoughtful stewardship includes well-preserved craftsman touches. Tailored public rooms. 3 sumptuous BR's + zoom office alcove on upper level. Chef's kitchen w/center island, b'fast bar seating & pantry. All the toys a chef could want: 2 ovens, beverage-cooler, pot-filler. Internal-access garage for 2 cars w/3rd car in driveway. Ample storage in garage. Easily-accessible attic provides tons of storage. Laundry center on bedroom level. Bold steampunk style powder room. Exquisitely appointed ensuite bathroom & guest bath. Luxe details include dual glazed windows, electric / designer shades & drapes, automated lights & dual-zone heating. Views to ocean, GGB & Marin! Impressive curb appeal.
