meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='337030' 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] => 2023-06-23 09:06:17
[post_modified_gmt] => 2023-06-23 16:06:17
[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, 207 Guerrero Street, San Francisco, CA, 94103
ffd_mls_id, 423900337
ffd_salesforce_id, a0E8W00000cpeu2UAA
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 4
address2__c, 207 Guerrero Street, San Francisco, CA, 94103
pba__address_pb__c, 207 Guerrero Street, San Francisco, CA, 94103
agent_only_remarks__c, For private showings, call Kate Stephenson at 415-370-6531. Graphic Artist Sq Ft is 1,704 (does not include storage). Buyer to investigate Sq Ft to their satisfaction. Pre-escrow opened with Michael Gaffney Fidelity National Title.
appliances__c, Dishwasher;Microwave;Disposal
architectural_style__c, Modern/High Tech
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2004
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kate Stephenson
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, Experience contemporary elegance on a grand scale at The Copper Building. For sale is one of three exquisitely appointed tri-level residences, each with a private entrance, outdoor entertainment spaces, and panoramic views of San Francisco. All 3 townhouses are situated behind a tall secured gate, and have designated garage parking with a lift for each resident to stack 2 cars. At the top of the house is a mezzanine office space overlooking the dining area below through the glass railings and internal skylight together with a luxurious primary suite with a glass-encased shower. Off the top level is a spacious private roof deck which boasts stunning city views. On the second floor, tall ceilings allow for ample light in the main living room with a chef's kitchen, living/dining area, storage and half bath. The first floor, which consists of a laundry area and 2 lovely bedrooms. Located in the vibrant Mission Dolores close to several fabulous neighborhoods: Mission Dolores, Hayes Valley, Mid-Market and the Valencia Corridor.
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Balcony;Entry Gate
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Bamboo;Carpet;Slate
pba__hoafees__c, 456
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant
interior_features__c, Wet Bar
ffd_lastmodifieddate, 2023-09-23T02:47:04.000+0000
pba__latitude_pb__c, 37.76785
pba__latitude_property__c, 37.76785
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included;Washer Included;Dryer Included
listed_date__c, 2023-08-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Trecia
pba__listing_agent_lastname__c, Knapp
listing_agent_mls_id__c, 803964
ffd_listingagentname, Trecia Knapp
listing_agent_number__c, 166013343
listing_co_agent_mls_id__c, 811268
listing_co_agent_number__c, 1050714
listing_co_office_mls_id__c, STHB4
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 28397
listing_office_mls_id__c, STHB4
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28397
pba__listingprice_pb__c, 2050000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.42416
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 423900337
main_level__c, Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
master_property__c, a0O8W00000KTE4IUAX
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-08-25
open_house_end__c, 2023-09-23T13:00:00.000+0000
open_house_start__c, 2023-09-23T11:00:00.000+0000
original_price__c, 2250000
overall_days_on_market__c, -81685
parking_access__c, Independent
parking_features__c, Attached,Mechanical Lift,Private
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Roof Deck
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, 1108.11
pba__propertytype__c, Condominium
ListingId, a0E8W00000cpeu2UAA
room_type__c, Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Fire Alarm;Carbon Mon Detector
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, 1850
size__c, 1850
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Guerrero
subdist__c, Mission Dolores
ffd_name, 207 Guerrero Street, San Francisco, CA, 94103
view__c, Downtown
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2004
pba__postalcode_pb__c, 94103
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530661913-1.jpg
