meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327064' 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, 3500 19th Street #204, San Francisco, CA, 94110
ffd_mls_id, 423720161
ffd_salesforce_id, a0E8W00000a8bIQUAY
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 17
address2__c, 3500 19th Street #204, San Francisco, CA, 94110
pba__address_pb__c, 3500 19th Street #204, San Francisco, CA, 94110
agent_only_remarks__c, Easy to show and can accommodate showings with or without the agent present. Please text or call Lauren for private showings at (510) 599-0592. Draftsman measured the unit at 1551 sq ft, this differs from tax record. Please find disclosures here: https://app.disclosures.io/link/3500-19th-Street-204-i9x6x4s3
appliances__c, Dishwasher;Microwave;Wine Refrigerator;Built-In Refrigerator
architectural_style__c, Modern/High Tech
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2013
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-02-20
ffd_createddate, 2023-02-08T22:50:37.000+0000
days_on_market__c, 161
dom__c, 20
ffd_description_pb, A serene sanctuary located steps from the bustling Valencia corridor, this sleek and modern 2-floor condominium checks all the boxes. This beautiful condo spans two floors for a desirable separation of entertaining and personal spaces. The top floor has an expansive open floor plan, including a BOFFI kitchen with honed marble counters, complete with a large working island. Just off the kitchen lies a private balcony retreat surrounded by trees. This floor finishes with an elegant, cleverly hidden, powder room. Downstairs, the gracious primary suite includes ample closet space, and a luxurious bathroom with a double vanity, curbless walk-in shower and radiant in-floor heating. The 2nd bedroom has its own en suite bathroom, providing ultimate flexibility and convenience for its inhabitants. Additionally, this unparalleled location places you at the center of everything- local foodie favorites, stylish boutiques, Dolores Park, BART, tech shuttles, and a peaceful outdoor shared lounge area. Unit comes with 1 large pkg spot + Tesla charger. Definitely don't miss!
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Balcony;Uncovered Courtyard
external_listing__c, 1
hoa_fee_includes__c, Common Areas,Elevator,Insurance,Management,Trash
pba__hoafees__c, 709
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 3500 19th St HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2023-07-13T18:23:20.000+0000
pba__latitude_pb__c, 37.760294
pba__latitude_property__c, 37.760294
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2023-02-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lauren
pba__listing_agent_lastname__c, Steinberg
listing_agent_mls_id__c, 814299
ffd_listingagentname, Lauren Steinberg
listing_agent_number__c, 1065791
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 1595000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.modernmissionluxury.com
pba__longitude_pb__c, -122.42192
mls_id__c, 423720161
main_level__c, Full Bath(s);Bedroom(s);Primary Bedroom
master_bathroom_features__c, Radiant Heat
master_property__c, a0O1I000001ViAzUAK
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-02-08
original_price__c, 1595000
overall_days_on_market__c, -81487
parking_access__c, Independent
parking_features__c, Assigned,EV Charging,Garage Door Opener
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2023-03-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1117.85
pba__propertytype__c, Condominium
ListingId, a0E8W00000a8bIQUAY
sale_date__c, 2023-03-03
sale_price__c, 1660000
security_features__c, Smoke Detector;Fire Alarm;Secured Access;Carbon Mon Detector;Video System
selling_agent_mls_id__c, 805322
selling_agent_number__c, 166015212
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Mosaik Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1485
size__c, 1485
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 19th
subdist__c, Mission Dolores
ffd_name, 3500 19th Street #204, San Francisco, CA, 94110
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 2013
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530577652-1.jpg