meta_query='key:subdist__c;value:Clarendon Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='228452' 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] => 2023-10-31 09:53:54
[post_modified_gmt] => 2023-10-31 16:53:54
[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, 167 Twin Peaks Boulevard, San Francisco, CA, 94114
ffd_mls_id, 481423
ffd_salesforce_id, a0E1I000006cFi6UAE
address2__c, 167 Twin Peaks Boulevard, San Francisco, CA, 94114
pba__address_pb__c, 167 Twin Peaks Boulevard, San Francisco, CA, 94114
agent_only_remarks__c, Offers due Wednesday, April 3rd by 11:00 am. Open Saturday and Sunday, March 30 & 31. On tour as repeat Tuesday, April 2nd. Other showing times by appointment with agent at (415) 656-6253. Planting photos courtesy of Scott F- Masterpiece Gardening.
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1996
pba__city_pb__c, San Francisco
ffd_createddate, 2019-03-22T15:45:46.000+0000
days_on_market__c, 1580
dom__c, 12
ffd_description_pb, With sweeping downtown, city and bay views, you'll be enchanted by this three bedroom, three and one half bath Clarendon Heights single family home. The inviting front entry leads to an elegant foyer with vaulted ceilings, skylights and stone floors. Walls of windows in the living room afford great light and more views. The formal dining room with french doors opens to a spacious deck - perfect for enjoying your morning coffee while overlooking the city, the bay and your serene garden. An eat-in kitchen with granite island also opens to the deck and boasts views to the east bay. All bedrooms are on one level, including a spacious master suite with private balcony, sitting area, jetted tub, separate shower, dual sinks and ample closet space. In addition, you'll find a large library/media room with separate entrance, a two-car attached garage providing interior access, and a sizable additional storage room.
district__c, SF District 5
external_listing__c, 1
hoa_dues__c, 0
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2022-03-01T19:57:36.000+0000
pba__latitude_pb__c, 0.000000
pba__latitude_property__c, 0.000000
listed_date__c, 2019-03-22
pba__listing_agent_firstname__c, Sheila
pba__listing_agent_lastname__c, Small
listing_agent_mls_id__c, 901870
listing_agent_number__c, 1016627
listing_co_agent_mls_id__c, 812707
listing_co_agent_number__c, 1057962
listing_co_office_mls_id__c, COLD23
listing_co_office_name__c, Coldwell Banker
listing_co_office_number__c, 166014098
listing_office_mls_id__c, COLD23
listing_office_name__c, Coldwell Banker
listing_office_number__c, 166014098
pba__listingprice_pb__c, 2100000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/323072457
pba__longitude_pb__c, 0.000000
pba__lotsize_pb__c, 0.05
mls_id__c, 481423
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2019-03-22
original_price__c, 2100000
overall_days_on_market__c, 1580
parking__c, Attached,Garage,Auto Door,Interior Access
parking_type__c, On Site
price_per_square_foot__c, 966.96
pba__propertytype__c, Single-Family Home
id, a0E1I000006cFi6UAE
sale_date__c, 2019-05-14
sale_price__c, 2400000
selling_agent_number__c, 980001715
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, RE/MAX Gold
pba__status__c, Closed
pba__totalarea_pb__c, 2482
size__c, 2482
pba__state_pb__c, CA
pba__street_pb__c, Twin Peaks
subdist__c, Clarendon Heights
ffd_name, 167 Twin Peaks Boulevard, San Francisco, CA, 94114
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1996
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/348159-1.jpg
ListingId, a0E1I000006cFi6UAE