meta_query='key:subdist__c;value:Clarendon Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='331228' 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] => 2018-11-06 17:57:53
[post_modified_gmt] => 2018-11-06 17:57:53
[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, 26 Graystone Terrace, San Francisco, CA, 94114
ffd_mls_id, 423726518
ffd_salesforce_id, a0E8W00000bcRddUAE
num_of_fireplaces__c, 2
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, Owner occupied. Shown by appointment only. Over $6,000,000 has been poured into the property over the years. The furniture is incredible! It is custom, solid hardwood, and in most instances, created specifically for each room, so it can come with the sale, or not; it's up to you. The trustees would love to include the property with the furniture if it is of interest to the buyer. The owners love for the home and its furnishes is apparent and they feel they belong together. The paintings and art is not included in the sale. Many photographs are not included due to security concerns. Please call with questions and for showings. Escrow is opened with DOMA and Kathie Ng. Escrow# 55905-23-03512. This is a trust sale. Keeping the escrow with DOMA is important to the trustees.
appliances__c, Hood Over Range
architectural_style__c, Spanish
bath_features__c, Tub w/Shower Over
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, 1800-01-01
ffd_createddate, 2023-05-08T16:49:03.000+0000
days_on_market__c, 23
dom__c, 22
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. 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, 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
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant Floor;Central
ffd_lastmodifieddate, 2023-05-31T01:47:57.000+0000
pba__latitude_pb__c, 37.758627
pba__latitude_property__c, 37.758627
laundry_features__c, Ground Floor;Washer Included;Dryer Included
listed_date__c, 2023-03-10
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, 4495000
pba__listingtype__c, Sale
pba__listing_website__c, http://clarendonlifestyles.com
pba__longitude_pb__c, -122.447692
lower_level__c, Family Room,Garage
mls_id__c, 423726518
main_level__c, Kitchen;Living Room;Dining Room
master_bathroom_features__c, Double Sinks;Tile;Stone
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-05-08
open_house_end__c, 2023-05-30T14:00:00.000+0000
open_house_start__c, 2023-05-30T12:00:00.000+0000
original_price__c, 4495000
overall_days_on_market__c, -81576
parking_access__c, Independent
parking_features__c, Garage Facing Front
parking_type__c, On Site (Single Family Only)
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, 1571.68
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bcRddUAE
roof__c, Bitumen;Spanish Tile
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security System Prewired;Security System Owned
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, 2860
size__c, 2860
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Graystone
subdist__c, Clarendon Heights
ffd_name, 26 Graystone Terrace, San Francisco, CA, 94114
view__c, City;Panoramic;Bay;Bay Bridge
website_property_type__c, Single Family Home
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/530589248-1.jpg