meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='312155' 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] => 2021-12-01 19:14:31
[post_modified_gmt] => 2021-12-02 03:14:31
[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
(
)
)
_wp_page_template PropertyDetails.php
ListingId a0E8W00000Wk2acUAB
pba__address_pb__c 100 Duboce Avenue #K2, San Francisco, CA, 94103
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 2
pba__bedrooms_pb__c 2
days_on_market__c 32
mls_id__c 422663084
pba__totalarea_pb__c 0
pba__latitude_pb__c 37.7699070221364
pba__longitude_pb__c -122.420024855637
pba__state_pb__c CA
pba__status__c Active
pba__street_pb__c Duboce
listed_date__c 2022-05-24
sale_date__c 1800-01-01
pba__propertytype__c Condominium
pba__listingprice_pb__c 1118000
pba__listingtype__c Sale
sale_price__c 0
address2__c 100 Duboce Avenue #K2, San Francisco, CA, 94103
pba__listing_agent_firstname__c Loring
pba__listing_agent_lastname__c Aguillon-Racine
view__c City;City Lights;San Francisco
pba__halfbathrooms_pb__c 0
parkingspaces__c 1
pba__postalcode_pb__c 94103
year_build_text__c 0
size__c 0
subdist__c Mission Dolores
listing_agent_mls_id__c 810701
listing_co_office_number__c 0
listing_office_number__c 28037
listing_office_name__c JS Sullivan Sales and Marketing, Inc.
listing_office_mls_id__c JSSULL
of_units__c 29
district__c SF District 5
selling_agent_number__c 0
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c -81228
dom__c 1
monthly_parking_fees__c 0
listing_co_agent_number__c 0
price_per_square_foot__c 0
parking_type__c Other
original_price__c 1118000
agent_only_remarks__c Brand new 2 bed / bath! One of the only homes in the building with a large private patio. Its open, split-bedroom floor plan boasts a kitchen that encourages culinary treats and entertaining, with state-of-the-art appliances and a large kitchen island. Located at the intersection of Valencia Street & Duboce Avenue and engaging three quintessential San Francisco neighborhoods: the Mission/Valencia Corridor, Duboce Triangle, and Hayes Valley, 198 Valencia connects to the very best of San Francisco's vibrant culture, history, and future. 198 Valencia is comprised of five levels, incorporating 4 floors of residential condominiums including: Studios, One-, Two- and Three-bedroom units. The project is completed by a panoramic roof-top terrace with an outdoor kitchen, for the exclusive use of building residents, providing 360-degree views of the city. ONE YEAR PRE-PAID PARKING AVAILABLE less than one block away. Images from a similar model home. Please call 415-814-1995 or [email protected] information.
pba__yearbuilt_pb__c 0
pba__listing_agent_email__c [email protected]
monthlyrent__c 0
external_listing__c 1
pba__latitude_property__c 37.7699070221364
listing_agent_number__c 1047482
on_market_date__c 2022-05-25
master_property__c a0O8W00000EVlgrUAD
architectural_style__c Contemporary;Modern/High Tech
website_property_type__c Condominium
media Array
ListingUpdateDate 2022-06-27T05:35:04
