meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212110' 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 #303, San Francisco, CA, 94110
ffd_mls_id, 497539
ffd_salesforce_id, a0E1I00000Slh81UAB
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 17
address2__c, 3500 19th Street #303, San Francisco, CA, 94110
pba__address_pb__c, 3500 19th Street #303, San Francisco, CA, 94110
agent_only_remarks__c, 1,570 sqft per graphic artist. 1,453 per tax record. Live virtual tours available via Facebook/Facetime by appointment. Property website with floor plan, video, & Matterport here: www.ValenciaPenthouse.com Email [email protected] for more information. Home is staged with showings by appointment under state and local guidelines for qualified prospects. Contact listing agent for showing protocol. All visitors to execute the PEAD addendum. Compass Shown Property COVID-19 Plan: https://drive.google.com/file/d/1KOevjT-8R-lvBdn79akm1p0DMhBIHvrY/view
appliances__c, Dishwasher;Microwave;Disposal;Refrigerator;Hood Over Range;Cooktop Stove;Freezer;Built-In Oven
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile;Dual Flush Toilet;Radiant Heat
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2013
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Ron Salter
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-05-15T21:46:49.000+0000
days_on_market__c, 1160
dom__c, 4
ffd_description_pb, Live at the heart of Mission Dolores and the burgeoning Valencia Corridor in the ultra-contemporary 3500 19th Street, with unbeatable proximity to everything the neighborhood has to offer: foodie favorite restaurants, a lively nightlife scene, Dolores Park, BART, shuttles and outstanding weather. This top floor, modern 2 bedroom, 2.5 bathroom home features an expansive open-concept entertaining area with extra-height ceilings and skylights, two walk-out decks with panoramic views, and 2 floors of living spaces. Two master suites with multiple floor-to-ceiling window lines; chef's kitchen with Italian designed BOFFI interiors and marble accents; and luxurious bathrooms with radiant heat and premium basins and cabinetry. 3500 19th Street is Mission Dolores' premier modern construction boutique building, designed by architectural firm Sternberg/Benjamin, featuring two sleek steel and wood structures linked by a ground floor podium and separated by a professionally landscaped courtyard.
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Piped
pba__floor__c, 0
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 634.56
hoa_fee_includes__c, Management,Maintenance Exterior,Trash,Maintenance Grounds,Water
pba__hoafees__c, 634
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant;Electric;Gas
ffd_lastmodifieddate, 2022-01-25T15:21:33.000+0000
pba__latitude_pb__c, 37.760307
pba__latitude_property__c, 37.760307
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-05-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Todd
pba__listing_agent_lastname__c, Montgomery
listing_agent_mls_id__c, 807753
ffd_listingagentname, Todd Montgomery
listing_agent_number__c, 1025356
listing_co_agent_mls_id__c, 812317
listing_co_agent_number__c, 1056202
listing_co_office_mls_id__c, COMP47
listing_co_office_name__c, Compass
listing_co_office_number__c, 28243
listing_office_mls_id__c, COMP47
listing_office_name__c, Compass
listing_office_number__c, 28243
pba__listingprice_pb__c, 1950000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.ValenciaPenthouse.com
pba__longitude_pb__c, -122.421762
pba__lotsize_pb__c, 0
mls_id__c, 497539
main_level__c, Master Bedroom
master_property__c, a0O1I000001ViAzUAK
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-05-15
original_price__c, 1950000
overall_days_on_market__c, 138
parking_access__c, Side by Side
parking_features__c, Attached,Interior Access,Side-by-Side,Garage
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2020-05-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1369.43
pba__propertytype__c, Condominium
id, a0E1I00000Slh81UAB
sale_date__c, 2020-06-15
sale_price__c, 2150000
selling_agent_mls_id__c, MLSL490746
selling_agent_number__c, 981170209
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Intero Real Estate Services
pba__status__c, Closed
pba__totalarea_pb__c, 1570
size__c, 1570
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 19th
subdist__c, Mission Dolores
ffd_name, 3500 19th Street #303, San Francisco, CA, 94110
transportation__c, 1 Block
unit_number__c, 303
view__c, City Lights;Downtown;San Francisco;Twin Peaks
website_property_type__c, Condominium
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/362623-1.jpg
ListingId, a0E1I00000Slh81UAB