meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='326539' posts_per_page=4 post_type=property
int(1)
Array
(
[ID] => 15603
[post_author] => 4
[post_date] => 2018-11-02 02:29:53
[post_date_gmt] => 2018-11-02 02:29:53
[post_content] => Liberty Hill. The sweet, sweet homes surrounding Dolores Park. Gaze at the downtown skyline after a walk through Dolores Park with the pooch. Not quite Noe Valley or the Castro and rising above Mission Dolores, Dolores Heights is home to some of central San Francisco's most expensive real estate.
[post_title] => Dolores Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => dolores-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-05 06:03:10
[post_modified_gmt] => 2022-12-05 14:03:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15603
[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, 350 Church Street #J, San Francisco, CA, 94114
ffd_mls_id, 423723125
ffd_salesforce_id, a0E8W00000bEZqGUAW
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 30
address2__c, 350 Church Street #J, San Francisco, CA, 94114
pba__address_pb__c, 350 Church Street #J, San Francisco, CA, 94114
agent_only_remarks__c, The disclosure packet is available on homelight/IO and here is the link: https://app.disclosures.io/link/350-Church-Street-J-lp4sn4qc Please email the listing agent to schedule appointments and follow advised health and safety protocols.
appliances__c, Dishwasher;Built-In Refrigerator;Built-In Electric Range
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Tub w/Shower Over;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1981
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-24T17:48:09.000+0000
days_on_market__c, 35
dom__c, 35
ffd_description_pb, Impressive top floor, two-level, updated home with an inviting and intelligent open floor plan, intimate outdoor space, located in a spectacular location on the border of four vibrant and indulgent neighborhoods: Eureka Valley, Mission Dolores, Duboce Triangle, and the Inner Mission! This modern unit offers a warm entryway with wood floors that leads to the lower level of the home with an updated bathroom, a large private and secluded bedroom, and a conveniently located laundry closet. The upper level opens to a spacious bi-level and open living area with gorgeous wood floors, wood beamed ceilings, an updated gourmet eat-in kitchen embraced by a wall of windows and skylight with cascading natural light. The living area is at the back of the unit, with an office nook and opens directly to the serene private patio and tranquil setting with partial views creating the perfect balance of indoor/outdoor living. There is a deeded parking space, deeded storage, a common area gym, hot-tub, and conference room that are also included with this contemporary home. Do not miss this special property that is close to shopping, world class restaurants, cafes, playgrounds, parks, MUNI, BART, HWY 101/280 and more!
district__c, SF District 5
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
hoa_fee_includes__c, Common Areas,Earthquake Insurance,Homeowners Insurance,Maintenance Exterior,Maintenance Grounds,Management,Roof,Sewer,Trash,Water
pba__hoafees__c, 713
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Church Street Terraces Condominium HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Baseboard;Electric
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-03-31T21:48:03.000+0000
pba__latitude_pb__c, 37.76535277
pba__latitude_property__c, 37.76535277
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-02-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jeffrey
pba__listing_agent_lastname__c, Salgado
listing_agent_mls_id__c, 805001
ffd_listingagentname, Jeffrey A Salgado
listing_agent_number__c, 166014760
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 995000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=9bFxW86RzNH&mls=1
pba__longitude_pb__c, -122.42880171
lower_level__c, Bedroom(s)
mls_id__c, 423723125
master_property__c, a0O8W00000HtC7UUAV
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-02-24
open_house_end__c, 2023-04-02T16:00:00.000+0000
open_house_start__c, 2023-04-02T14:00:00.000+0000
original_price__c, 1195000
overall_days_on_market__c, -81503
parking_access__c, Independent
parking_features__c, Covered,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Uncovered 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, 1198.8
pba__propertytype__c, Condominium
ListingId, a0E8W00000bEZqGUAW
room_type__c, Kitchen;Living Room;Family Room;Primary Bedroom
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, 830
size__c, 830
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Church
subdist__c, The Castro - Dolores Heights
ffd_name, 350 Church Street #J, San Francisco, CA, 94114
view__c, City Lights;Sutro Tower
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1981
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530583759-1.jpg