meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218563' 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, 3620 19th Street #5, San Francisco, CA, 94110
ffd_mls_id, 421541970
ffd_salesforce_id, a0E1I00000USHLOUA5
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 39
address2__c, 3620 19th Street #5, San Francisco, CA, 94110
pba__address_pb__c, 3620 19th Street #5, San Francisco, CA, 94110
agent_only_remarks__c, Please call Mila Gelman at 415.867.6979 to schedule showings. Send PEAD to [email protected] and subject to COVID showing restrictions. Email Bernie Katzmann at [email protected] with disclosure requests. Please email agents with disclosure requests. One of the sellers is a licensed real estate agent. Possibility of 2nd parking space, subject to availability. Exceptionally private, house-like two-level condo surrounded by stunning gardens, providing tranquility and privacy rarely found in a condominium and with seating benches, palm trees, jacaranda, orange, and other flowering trees, camellias and striking mature plantings Private entrance to condo can be accessed without walking through hallways.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Marble;Tile;Low-Flow Toilet(s);Low-Flow Shower(s);Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2008
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Bernard Katzmann
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-27T10:47:37.000+0000
days_on_market__c, 813
dom__c, 12
ffd_description_pb, Sensational 2BR + den, 2.5BA designer 2-level townhouse perfectly located near Dolores Park/Valencia Corridor. Situated in the middle of amazing park-like landscaped gardens, w/private entrance. Detached 3 sides, exc light. Gorgeous hardwood floors, designer lighting, high ceilings. Fantastic open plan living/dining rm, gas fireplace, hrdwd flrs, facing gardens, and sliding doors to private patio. Superb kitchen: satin granite counters, M8 designer cabinetry, stainless applcs incl Bertazzoni 5-burner range, stunning custom hood, refrig, Bosch DW. Garden-facing office/den, stylish powder room on this lvl. Upper lvl: 2 suites, incl garden view primary suite w/fab Carrara marble BA, dbl sinks, oversized marble shower. 2nd BR w/en-suite tiled BA, marble floor. Bosch W/D, large closets. One car garage parking. Unique garden setting Unbeatable loc at Dolores Park, 1 block to Tartine, BiRite, fab restaurants, cafes, shopping. Conv to MUNI, BART, shuttles, freeway access. Walkscore 99, Bike
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Log
pba__floortype_pb__c, Carpet;Marble;Wood
hoa_fee_includes__c, Common Areas,Insurance,Insurance on Structure,Internet,Maintenance Grounds,Roof,Sewer,Trash,Water
pba__hoafees__c, 625
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Chelsea Park OA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:50:53.000+0000
pba__latitude_pb__c, 37.760545
pba__latitude_property__c, 37.760545
laundry_features__c, Laundry Closet;In Kitchen;Washer/Dryer Stacked Included
listed_date__c, 2021-04-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michael
pba__listing_agent_lastname__c, Shaw
listing_agent_mls_id__c, 800323
ffd_listingagentname, Michael H Shaw
listing_agent_number__c, 800323
listing_co_agent_mls_id__c, 263622
listing_co_agent_number__c, 263622
listing_co_office_mls_id__c, VANG03
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 1228
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 1575000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/CrUZ2VTlLm
pba__longitude_pb__c, -122.4244187
mls_id__c, 421541970
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Double Sinks;Marble;Low-Flow Shower(s);Window;Stone
master_property__c, a0O1I000001Vhl3UAC
monthly_parking_fees__c, 140.04
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-04-27
original_price__c, 1575000
overall_days_on_market__c, 177
parking_access__c, Side by Side
parking_features__c, Assigned,Enclosed,Garage Door Opener,Side-by-Side,Size Limited
parking_type__c, On Site - Assigned (Condo Only);On Site - Lease Available (Condo Only)
patio_and_porch_features__c, Enclosed Patio;Uncovered Patio
pba__pendingdate__c, 2021-05-09
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
id, a0E1I00000USHLOUA5
roof__c, Bitumen
room_type__c, Office;Den;Kitchen;Master Bedrooms 2+;Living Room;Master Bathroom;Dining Room
sale_date__c, 2021-05-27
sale_price__c, 1570000
security_features__c, Smoke Detector;Fire Alarm;Fire Suppression System;Carbon Mon Detector
selling_agent_mls_id__c, 811740
selling_agent_number__c, 1053371
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Polaris Realty
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 19th
subdist__c, Mission Dolores
ffd_name, 3620 19th Street #5, San Francisco, CA, 94110
view__c, Garden/Greenbelt
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Window Coverings;Bay Window(s);Window Screens
pba__yearbuilt_pb__c, 2008
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530226686-1.jpg
ListingId, a0E1I00000USHLOUA5
