meta_query='key:subdist__c;value:Ashbury Heights;Buena Vista Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='336997' posts_per_page=4 post_type=property
bool(false)
string(0) ""
ffd_listing_title, 828 Ashbury Street, San Francisco, CA, 94117
ffd_mls_id, 423900363
ffd_salesforce_id, a0E8W00000cpetVUAQ
num_of_fireplaces__c, 1
num_of_rooms__c, 10
of_units__c, 0
address2__c, 828 Ashbury Street, San Francisco, CA, 94117
pba__address_pb__c, 828 Ashbury Street, San Francisco, CA, 94117
agent_only_remarks__c, Heart of Cole Valley - Agents this home has all of the elements your clients want - A+ walking location, central SF location, curb appeal and the perfect floor plan. All of the rooms are exactly where you would want them. Too many additional features to list in the Public Remarks - there is a designated laundry room and kids playroom.------------------------------ About The Garden : The rear garden of this residential masterpiece features three fruiting Cherry trees, a Meyer Lemon, and a mature purple leaf Japanese Maple. White Wisteria was collected from the historic grounds of the Crocker EstateGarden in Hillsborough at Stanford. There are also a number of northern California coastal native plants, some of which have been collected in the wild including Pacific Coast Silktassel, Flowering Currant, Huckleberry, Thimbleberry, Beach Strawberry, Redwood Sorrel and Maidenhair ferns. The home is located just steps away from 2 blocks of neighborhood restaurants and services including the original Cole Hardware store, and the flagship N Judah train that connects to Ocean Beach and downtown. Note : Exterior entry light fixture is excluded from the sale.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Hood Over Range;Free Standing Gas Range;Built-In Refrigerator
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Double Sinks
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1910
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-08-26T02:53:26.000+0000
days_on_market__c, 28
dom__c, 28
ffd_description_pb, Seller Credit = 4.75% -Financing- Heart of Cole Valley 828 Ashbury is an elegant 4 story residence with 3 sensational living levels, lovely 1910 detail, and a perfect family friendly floor plan. The home sits on an elevated site above the street showcasing its brilliant natural light and privacy. A gorgeous wood staircase, with cascading natural light, seamlessly connects the home, simultaneously creating intimacy and solitude. The layout offers 5 generous bedrooms, 3 and a half full baths, gorgeous grand scale living room, wood paneled dining room w/ fireplace, and a beautiful eat-in kitchen with carrara marble counters/island, custom wood cabinetry, high end stainless appliances, and walk out garden. The primary BR is lavishly proportioned and luxurious: bright expansive sleeping area, bountiful closet spaces, and a gorgeous marbled bath w separate stall shower, tub, and dual vanity with Waterworks fixtures. Down the hall are 2 generous bedrooms which share an updated bath, one with direct bath access. The top level features two additional bedrooms which may be be terrific flex space options for a home office, media room, or au pair. Below the main living level is a massive 3 car garage, with room for an additional car in the driveway. Significant seismic/system update
Seller Credit = 4.75% -Financing- Heart of Cole Valley 828 Ashbury is an elegant 4 story residence with 3 sensational living levels, lovely 1910 detail, and a perfect family friendly floor plan. The home sits on an elevated site above the street showcasing its brilliant natural light and privacy. A gorgeous wood staircase, with cascading natural light, seamlessly connects the home, simultaneously creating intimacy and solitude. The layout offers 5 generous bedrooms, 3 and a half full baths, gorgeous grand scale living room, wood paneled dining room w/ fireplace, and a beautiful eat-in kitchen with carrara marble counters/island, custom wood cabinetry, high end stainless appliances, and walk out garden. The primary BR is lavishly proportioned and luxurious: bright expansive sleeping area, bountiful closet spaces, and a gorgeous marbled bath w separate stall shower, tub, and dual vanity with Waterworks fixtures. Down the hall are 2 generous bedrooms which share an updated bath, one with direct bath access. The top level features two additional bedrooms which may be be terrific flex space options for a home office, media room, or au pair. Below the main living level is a massive 3 car garage, with room for an additional car in the driveway. Significant seismic/system update
