meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='427732' 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] => 2024-11-19 12:01:01
[post_modified_gmt] => 2024-11-19 20:01:01
[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
(
)
)
_yoast_indexnow_last_ping, 1746789581
ffd_listing_title, 959 Church Street, San Francisco, CA, 94114
ffd_mls_id, 425033211
ffd_salesforce_id, a0EUd000004q9cpMAA
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 2
pba__address_pb__c, 959 Church Street, San Francisco, CA, 94114
address2__c, 959 Church Street, San Francisco, CA, 94114
agent_only_remarks__c, Offer date will be set after Sunday, 5/11. Please DO NOT text for showings. Showing instructions can be found here: https://calendly.com/957-959churchst/showings Email [email protected] to request for disclosures. Laundry is shared with 957. Escrow must stay with [email protected] for condo conversion. All buyers to use the most current 10-page SFAR contract. 957 Church St. is also available for sale. Opportunity to purchase full building with 2 condos. If purchasing both units, 2 separate offers must be made - 1 for each unit. Both units have to close simultaneously due to the condo conversion. Units will close escrow as condos. Some photos of the rooftop are renderings. Buyer must verify with city to build out rooftop. Per CC&R's, short-term rentals are allowed. *All info herein is not guaranteed. Prospective purchasers are advised to verify accuracy independently and to review any disclosure information before submitting offers.*
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Shower Stall(s);Tub;Split Bath
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1940
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Yesenia Rogers
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-04-24T22:47:36.000+0000
days_on_market__c, 15
dom__c, 15
ffd_description_pb, Chic and sunlit, this beautifully updated 2BD/1BA, sits at the vibrant intersection of Noe Valley, Eureka Valley, and the Mission. Spanning 1,395 SF (per graphic artist). The layout flows effortlessly from a gracious formal living room and elegant dining area to an expansive, updated kitchen with generous counter space and a bright, cheerful breakfast nook perfect for slow, sunny mornings. Two peaceful rear bedrooms offer charming views, while the split bath provide style and functionality. Soaring windows and courtyard-facing natural light enhance the warm, airy vibe throughout. Shared laundry included. Per CC&Rs, the buyer may investigate the potential for a rooftop deck (buyer to verify with the City). With a stellar 95 Walk Score, you're just 3 blocks from Dolores Park, 24th Street's village charm, and the buzz of the Mission's top eateries. Ideal access to the J Church MUNI line, tech shuttles, and freeways. 957 Church is also available. An exceptional chance to own two condos in the same building.
district__c, SF District 5
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa_name__c, TBD
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Other
ffd_lastmodifieddate, 2025-05-09T10:47:51.000+0000
pba__latitude_pb__c, 37.7556025
pba__latitude_property__c, 37.7556025
laundry_features__c, In Garage;See Remarks;Washer Included;Dryer Included
listed_date__c, 2025-04-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ruth
pba__listing_agent_lastname__c, Krishnan
listing_agent_mls_id__c, 400593
ffd_listingagentname, Ruth Krishnan
listing_agent_number__c, 1019790
listing_co_agent_mls_id__c, 813900
listing_co_agent_number__c, 1063314
listing_co_office_mls_id__c, COMP2
listing_co_office_name__c, Compass
listing_co_office_number__c, 27341
listing_office_mls_id__c, COMP41
listing_office_name__c, Compass
listing_office_number__c, 27887
pba__listingprice_pb__c, 999000
pba__listingtype__c, Sale
pba__listing_website__c, https://ruthkrishnan.com/property-listings/959-church-st-eureka-valley-dolores/
pba__longitude_pb__c, -122.4276411
mls_id__c, 425033211
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0OUd00000KRdJhMAL
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2025-04-24
open_house_end__c, 2025-05-11T16:00:00.000+0000
open_house_start__c, 2025-05-11T14:00:00.000+0000
original_price__c, 1399000
overall_days_on_market__c, -82293
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2025-05-08T17:57:02.000+0000
price_per_square_foot__c, 716.13
price_reduced__c, 1
pba__propertytype__c, Condominium
ListingId, a0EUd000004q9cpMAA
road_surface_type__c, Paved
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security Gate
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, 1395
size__c, 1395
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Church
subdist__c, The Castro - Dolores Heights
ffd_name, 959 Church Street, San Francisco, CA, 94114
view__c, City;City Lights;Bay;San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530986120-1.jpg