meta_query='key:subdist__c;value:Clarendon Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327633' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 16083
[post_author] => 4
[post_date] => 2018-11-06 17:57:53
[post_date_gmt] => 2018-11-06 17:57:53
[post_content] => Clarendon Heights is what it would look like if you re-built Pacific Heights at the top of Twin Peaks in the 1960s. Large, sloping lots that assume you have at least two cars. Bridge to bridge views. The land of former mayors and current moguls.
[post_title] => Clarendon Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => clarendon-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 10:53:08
[post_modified_gmt] => 2024-04-09 17:53:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=16083
[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, 20 Graystone Terrace, San Francisco, CA, 94114
ffd_mls_id, 423719008
ffd_salesforce_id, a0E8W00000a8PubUAE
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 20 Graystone Terrace, San Francisco, CA, 94114
pba__address_pb__c, 20 Graystone Terrace, San Francisco, CA, 94114
agent_only_remarks__c, Seller intends to sell Off-Market. Easy to show. Contact Shane (415.225.5990) Julie (415.730.6387) Stephen (415.307.9698). Escrow with Gerrie Brindley at Chicago Title.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1924
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Julie F Rogers
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-04T11:48:23.000+0000
days_on_market__c, 166
dom__c, 0
ffd_description_pb, 20 Graystone Terrace is a stunning 3BR+/2.5BA Craftsman home located on one of the most sought-after blocks in San Francisco. The property boasts breathtaking downtown and east bay views and has undergone substantial upgrades over the years, preserving its classic beauty. As you enter the home, a wide and elegant foyer leads to a sun-filled living room with Bay windows & wood-burning fireplace. The spacious dining rm faces a gorgeous garden and retains its original Craftsman details. The well-appointed kitchen is complete with modern cabinets, white quartz counters, and doors to the garden. There's also a lounge area within the kitchen for family and friends to interact and help prepare meals. A half bath is also on the first floor. Upstairs, the bedrooms are accessed by a staircase that mirrors the elegance of the foyer. The primary bedroom boasts spectacular views and features a spacious en-suite bath with a walk-in closet and French doors leading to the updated balcony/deck. The middle bedroom is spacious and the 3rd bedroom is surrounded by windows overlooking the garden. A separate office adds ultimate function to this level. Large garage with room for parking + storage. It's conveniently located near Cole Valley, Tank Hill, Upper Market, and the Pemberton steps.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
ffd_lastmodifieddate, 2023-07-13T18:21:32.000+0000
pba__latitude_pb__c, 37.758693
pba__latitude_property__c, 37.758693
listed_date__c, 2023-02-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Shane
pba__listing_agent_lastname__c, Ray
listing_agent_mls_id__c, 807674
ffd_listingagentname, Shane R Ray
listing_agent_number__c, 1023667
listing_co_agent_mls_id__c, 803159
listing_co_agent_number__c, 803159
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 3000000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=883hwBRtVhN&mls=1
pba__longitude_pb__c, -122.447719
mls_id__c, 423719008
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-02-03
original_price__c, 3000000
overall_days_on_market__c, -81482
parking_access__c, Independent
parking_features__c, Garage Door Opener,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-02-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1391.18
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000a8PubUAE
sale_date__c, 2023-03-06
sale_price__c, 3030000
selling_agent_mls_id__c, 807826
selling_agent_number__c, 1027255
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2178
size__c, 2178
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Graystone
subdist__c, Clarendon Heights
ffd_name, 20 Graystone Terrace, San Francisco, CA, 94114
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1924
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530575132-1.jpg