meta_query='key:subdist__c;value:Clarendon Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='374092' 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
(
)
)
_yoast_indexnow_last_ping, 1710464119
ffd_listing_title, 26 Graystone Terrace, San Francisco, CA, 94114
ffd_mls_id, 423922494
ffd_salesforce_id, a0EUd0000005GXBMA2
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 26 Graystone Terrace, San Francisco, CA, 94114
pba__address_pb__c, 26 Graystone Terrace, San Francisco, CA, 94114
agent_only_remarks__c, Still showing and looking for back ups. There's a condition involving our tree and the neighbor in Crown Terrace that needs resolution for this buyer to perform. Shown by appointment only outside of open house times - no lockbox. Over $6,000,000 has been poured into the property over the years. Please call with questions to 415-317-5888 (Todd) or 415-519-5595(Kim). Escrow is opened with WFG Title and Kathie Ng. Escrow# 55905-23-03512. This is a trust sale. Keeping the escrow with WFG Title is important to the trustees.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Refrigerator
architectural_style__c, Mediterranean
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1926
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kim M Wiley
pba__contingentdate__c, 2024-02-04
ffd_createddate, 2023-11-11T19:47:28.000+0000
days_on_market__c, 124
dom__c, 115
ffd_description_pb, One of Clarendon Heights greatest treasures; like a passage through time, each floor displays finishes of the owner's rich life and travels built into the home with craftsmanship and an attention to detail that seems to have been lost in this modern age. Though 2 bedrooms, note how simply the library can be transformed into a 3rd bedroom. See rendering. This home does not disappoint, so if you are looking for something that can truly be considered a work of art; look no further. Some details: intricate tile work, meticulously detailed hardwood flooring, stone carved sinks, abalone pendant inlays in the box-beamed ceiling, an ELEVATOR on 3 levels, media room, radiant heating, and panoramic views of the City and East Bay from the massive roof deck (and all floors), are only a small representation of the many nuances that set this property apart from anything you have ever seen. As original as a fingerprint, every hinge is hand forged; every window's stained glass unique to the room; the vision for the home was crafted over a lifetime of travel, curiosity, and exploration. Passion is a word that best describes this home. If you are a buyer who is looking for a home filled with passion, warmth and artistic detail; this home is for you.
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant
interior_features__c, Open Beam Ceiling
ffd_lastmodifieddate, 2024-03-15T00:47:10.000+0000
pba__latitude_pb__c, 37.758627
pba__latitude_property__c, 37.758627
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2023-11-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Todd
pba__listing_agent_lastname__c, Wiley
listing_agent_mls_id__c, 804390
ffd_listingagentname, Todd Wiley
listing_agent_number__c, 166013929
listing_co_agent_mls_id__c, 810458
listing_co_agent_number__c, 1046408
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, 3295000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=xsHQzcB6RwQ
pba__longitude_pb__c, -122.447692
mls_id__c, 423922494
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Stone;Multiple Shower Heads;Outside Access
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-11-11
original_price__c, 3295000
overall_days_on_market__c, -81763
parking_access__c, Independent
parking_features__c, Garage Door Opener,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-03-05
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-03-14T11:05:09.000+0000
price_per_square_foot__c, 1048.95
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000005GXBMA2
roof__c, Bitumen
room_type__c, Dining Room;Media Room
sale_date__c, 2024-03-14
sale_price__c, 3000000
security_features__c, Security System Owned
selling_agent_mls_id__c, 802977
selling_agent_number__c, 802977
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, 2860
size__c, 2860
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Graystone
subdist__c, Clarendon Heights
ffd_name, 26 Graystone Terrace, San Francisco, CA, 94114
view__c, City;Panoramic;City Lights;Bay;Water;Downtown;San Francisco;Twin Peaks;Mountains;Sutro Tower
website_property_type__c, Single Family Home
window_features__c, Dual Pane Partial
pba__yearbuilt_pb__c, 1926
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530703631-1.jpg
