meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218020' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15110
[post_author] => 4
[post_date] => 2018-10-31 19:36:27
[post_date_gmt] => 2018-10-31 19:36:27
[post_content] => Not quite the Mission, not quite the Castro, Mission Dolores is a bustling, centrally located neighborhood with some iconic San Francisco attractions. The crown jewels of the neighborhood are Dolores Park and Mission Dolores, the oldest Spanish Mission church in San Francisco. Sun worshippers flock to Dolores Park on warm and cool days alike, and the church welcomes worshippers for regular services.
[post_title] => Mission Dolores
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mission-dolores
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:57:22
[post_modified_gmt] => 2024-03-19 19:57:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15110
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 50 Oakwood Street, San Francisco, CA, 94110
ffd_mls_id, 421533649
ffd_salesforce_id, a0E1I00000TxbibUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 8
of_units__c, 0
address2__c, 50 Oakwood Street, San Francisco, CA, 94110
pba__address_pb__c, 50 Oakwood Street, San Francisco, CA, 94110
agent_only_remarks__c, For covid compliant showings please email [email protected] - prospective buyers must submit PEAD form prior to showing.Garage cannot fit 2 large cars | Brochure link - https://www.flipsnack.com/TeamHatvany/50-oakwood-st-brochure.html
appliances__c, Dishwasher;Tankless Water Heater;Built-In Refrigerator;Gas Cook Top
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Stone
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-02T01:39:58.000+0000
days_on_market__c, 839
dom__c, 71
ffd_description_pb, Tucked away on a quiet block in the heart of Mission Dolores, 50 Oakwood is a serene urban oasis. Designed by starchitect Stanley Saitowitz, this 4-level home is an exceptional blend of classic and modern style. 5 bedrooms & 4.5 bathrooms, with custom Italian finishes and floor-to-ceiling walls of glass. The living room features a 16' travertine fireplace and the incredible kitchen is outfitted with Boffi cabinetry and a 15' island, with dining area open to an expansive deck. Upstairs is a stunning primary suite with terrace, travertine bath, and dual Porro wardrobes, plus two spacious bedrooms with shared bath, and a light-filled office/4th bedroom. On the top level is a sprawling pentroom framed by downtown and hillside views, with terraces on either side. On the ground floor is the 2-car garage and a legal 2nd unit, with its own entrance, bed/bath, kitchen, laundry, and sunken patio leading up to the beautiful backyard. This stunning architectural masterpiece is truly one-of-a-kind.
district__c, SF District 5
driveway_sidewalks__c, Paved Sidewalk
electric__c, Battery Backup
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood;Stone
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant;Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2022-01-25T15:48:40.000+0000
pba__latitude_pb__c, 37.760732
pba__latitude_property__c, 37.760732
laundry_features__c, Laundry Closet;Upper Floor;Ground Floor;Washer Included;Dryer Included
listed_date__c, 2021-03-31
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Nina
pba__listing_agent_lastname__c, Hatvany
listing_agent_mls_id__c, 372883
ffd_listingagentname, Nina Hatvany
listing_agent_number__c, 372883
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 7850000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/529669358
pba__longitude_pb__c, -122.425226
lower_level__c, Bedroom(s),Full Bath(s),Garage,Living Room,Street Entrance
mls_id__c, 421533649
main_level__c, Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Tub;Double Sinks;Stone
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-04-01
original_price__c, 8350000
overall_days_on_market__c, 121
parking_access__c, Tandem
parking_features__c, Attached,Enclosed,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Roof Deck;Uncovered Deck
pba__pendingdate__c, 2021-06-11
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1564.84
pba__propertytype__c, Single Family Residence
id, a0E1I00000TxbibUAB
sale_date__c, 2021-06-30
sale_price__c, 7300000
security_features__c, Smoke Detector;Secured Access;Carbon Mon Detector;Video System
selling_agent_mls_id__c, 807897
selling_agent_number__c, 1028279
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 4665
size__c, 4665
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Oakwood
subdist__c, Mission Dolores
ffd_name, 50 Oakwood Street, San Francisco, CA, 94110
view__c, City;City Lights;Downtown;San Francisco;Twin Peaks;Hills
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530210689-1.jpg
ListingId, a0E1I00000TxbibUAB