meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='337157' 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, 3574 19th Street, San Francisco, CA, 94110
ffd_mls_id, 423900763
ffd_salesforce_id, a0E8W00000cpwuaUAA
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 2
address2__c, 3574 19th Street, San Francisco, CA, 94110
pba__address_pb__c, 3574 19th Street, San Francisco, CA, 94110
agent_only_remarks__c, Easy to show just call Josh Burns at #415-307-2463 or email [email protected]. The square footage numbers range from the 2023 Graphic Artist 1,435 sq. ft., Tax Record 1,242 sq. ft., Condo Map 1,247, the 2016 Floor Plan was 1,240 sq. ft., and Zillow at 1,330 sq. ft. Please see square footage advisory located in the disclosure package for buyers and agents to review. All potential buyers to verify to their own satisfaction in regard to the square footage. Agent has not verified and does not warrant the accuracy of any square footage number associated with the Property. Disclosure packages are available.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Built-In Refrigerator
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1940
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-08-28T21:03:39.000+0000
days_on_market__c, 25
dom__c, 25
ffd_description_pb, This rare luxury top floor 2BR/2BA condo designed by an award-winning architect is located in the coveted Mission Dolores neighborhood. Situated in a well-maintained boutique 2-unit building, this turn-key home filled with natural light has been extensively renovated with timeless finishes and quality craftsmanship. The formal living room and dining room overlook a park across the street and are perfect for comfortable living. The gourmet kitchen is highlighted with walnut cabinetry, quartz countertops, stainless steel appliances including gas range and walk-in pantry. Both bedrooms feature built-in custom closets and a spacious primary suite with spa-like bathroom. A premier private rooftop deck is located directly off the residence with panoramic views and is ideal for outdoor living. Other highlights include in-unit laundry, hardwood floors, dual pane windows and one car garage parking. Close proximity to Dolores Park, shops, restaurants, public transit, and shuttles. Walk score 98!
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Electricity,Insurance,Trash
pba__hoafees__c, 288
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 3572-3574 19th Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-09-23T01:47:22.000+0000
pba__latitude_pb__c, 37.760225
pba__latitude_property__c, 37.760225
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-08-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Josh
pba__listing_agent_lastname__c, Burns
listing_agent_mls_id__c, 805857
ffd_listingagentname, Josh K Burns
listing_agent_number__c, 177518611
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 2150000
pba__listingtype__c, Sale
pba__listing_website__c, https://player.vimeo.com/video/854856067
pba__longitude_pb__c, -122.423076
mls_id__c, 423900763
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_property__c, a0O8W00000KSNCfUAP
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-08-28
open_house_end__c, 2023-09-26T14:00:00.000+0000
open_house_start__c, 2023-09-26T12:00:00.000+0000
original_price__c, 2150000
overall_days_on_market__c, -81688
parking_access__c, Side by Side
parking_features__c, Enclosed,Garage Door Opener
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, 0
pba__propertytype__c, Condominium
ListingId, a0E8W00000cpwuaUAA
roof__c, Bitumen;Metal
sale_date__c, 1800-01-01
sale_price__c, 0
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 19th
subdist__c, Mission Dolores
ffd_name, 3574 19th Street, San Francisco, CA, 94110
view__c, City;Park;City Lights;Hills
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530664573-1.jpg