meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319165' 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, 51 Guerrero Street, San Francisco, CA, 94103
ffd_mls_id, 422683562
ffd_salesforce_id, a0E8W00000YXQdlUAH
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 4
address2__c, 51 Guerrero Street, San Francisco, CA, 94103
pba__address_pb__c, 51 Guerrero Street, San Francisco, CA, 94103
agent_only_remarks__c, Staging has been removed. Please use the standard 7-page SFAR Purchase Agreement and TIC Purchase Addendum (in the disclosure package). A blank copy of the SFAR Purchase Agreement can be made available if required. Seller kindly requests escrow remain with Liz Paglinawan with First American Title. www.51Guerrero.com Disclosure package available at: https://app.disclosures.io/link/51-Guerrero-Street-o7i2hnnj
appliances__c, Dishwasher;Microwave;Disposal;Tankless Water Heater;Free Standing Gas Range
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1911
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-10-03
ffd_createddate, 2022-08-01T20:48:14.000+0000
days_on_market__c, 352
dom__c, 81
ffd_description_pb, Spectacularly located in Mission Dolores at the edge of Hayes Valley, Duboce Triangle and the Castro, this full floor flat is chock full of Edwardian charm with modern updates. The gorgeous updated kitchen, with its top-of-the-line stainless steel appliances, bar height counter and pantry, is perfect for entertaining as it opens up to the bright and airy living and dining area with captivating views to the east. Off the kitchen is the perfect flex room for your work from home set-up. Two spacious bedrooms feature sizable closet space, stunning bay windows and historical charm, while the lovely primary suite includes a large, updated en-suite bathroom including double-vanity. Completing the unit is a second full bathroom, in-unit washer dryer, Google Nest, more closet space, exclusive-use of parking and storage in the garage. With a walk-score of 96, this Walker's Paradise is close to public transport, Whole Foods, and some of the best of San Francisco's shopping, restaurants and more.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Decorative Only
pba__floortype_pb__c, Wood
pba__hoafees__c, 287
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T17:26:15.000+0000
pba__latitude_pb__c, 37.7700792
pba__latitude_property__c, 37.7700792
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2022-03-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Brandi Lynne
pba__listing_agent_lastname__c, Mayo
listing_agent_mls_id__c, 811218
ffd_listingagentname, Brandi Lynne Mayo
listing_agent_number__c, 1050472
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 1195000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?brand=0&m=AiJjoksPGyi
pba__longitude_pb__c, -122.4247048
mls_id__c, 422683562
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over;Double Sinks
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-08-01
original_price__c, 1495000
overall_days_on_market__c, -81296
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2022-10-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 826.99
pba__propertytype__c, Tenancy In Common
ListingId, a0E8W00000YXQdlUAH
room_type__c, Office;Great Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2022-10-31
sale_price__c, 1195000
selling_agent_mls_id__c, 808450
selling_agent_number__c, 1035152
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, 1445
size__c, 1445
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Guerrero
subdist__c, Mission Dolores
ffd_name, 51 Guerrero Street, San Francisco, CA, 94103
view__c, City;City Lights;San Francisco
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1911
pba__postalcode_pb__c, 94103
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530506064-1.jpg
