meta_query='key:subdist__c;value:Clarendon Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='333009' 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, 1 Twin Peaks Boulevard, San Francisco, CA, 94114
ffd_mls_id, 423747124
ffd_salesforce_id, a0E8W00000cJHX7UAO
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 1 Twin Peaks Boulevard, San Francisco, CA, 94114
pba__address_pb__c, 1 Twin Peaks Boulevard, San Francisco, CA, 94114
agent_only_remarks__c, Home is available to be shown at anytime. Full inspections included in disclosure package. Call Andrew Warren for more info/showings. Buyer to verify SQFT and keep escrow with DOMA.
appliances__c, Dishwasher;Disposal;Tankless Water Heater;Gas Cook Top
architectural_style__c, Mid-Century
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1951
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Andrew J Warren
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-06-08T21:49:10.000+0000
days_on_market__c, 0
dom__c, 0
ffd_description_pb, Welcome to your dream residence nestled on the corner of Twin Peaks Blvd and Clayton Street in San Francisco. This magnificent four-bedroom, four-bathroom view home offers an unparalleled living experience, showcasing breathtaking vistas from every angle. With its expansive triangle-shaped lot and an abundance of rugged-resistant plantings, this property boasts a unique and captivating outdoor space. As you step inside this architectural masterpiece, you'll be immediately struck by the seamless blend of contemporary design and timeless elegance. The open-concept floor plan creates a fluid transition between the living, dining, and kitchen areas, enhancing the spaciousness and inviting natural light to flood the interiors. The gourmet kitchen is a chef's delight, featuring high-end appliances, sleek cabinetry, and ample counter space for preparing culinary delights. The adjacent dining area offers a serene atmosphere for enjoying meals, with the ever-changing San Francisco landscape serving as the perfect backdrop.
district__c, SF District 5
driveway_sidewalks__c, Gated
entry_level__c, 0
exterior_features__c, Fire Pit
external_listing__c, 1
fencing__c, Fenced
pba__floortype_pb__c, Wood;See Remarks
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-06-09T02:48:52.000+0000
pba__latitude_pb__c, 37.7604718
pba__latitude_property__c, 37.7604718
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2023-06-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Frank
pba__listing_agent_lastname__c, Nolan
listing_agent_mls_id__c, 803037
ffd_listingagentname, Frank A Nolan
listing_agent_number__c, 803037
listing_co_agent_mls_id__c, 807776
listing_co_agent_number__c, 1025907
listing_co_office_mls_id__c, VANG02
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 166013449
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 4550000
pba__listingtype__c, Sale
pba__listing_website__c, http://OneTwinPeaks.com
pba__longitude_pb__c, -122.4466367
lower_level__c, Family Room,Street Entrance
mls_id__c, 423747124
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Double Sinks;Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2023-06-08
open_house_end__c, 2023-06-11T14:00:00.000+0000
open_house_start__c, 2023-06-11T12:00:00.000+0000
original_price__c, 4550000
overall_days_on_market__c, -81607
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access,Side-by-Side
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, 1452.75
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cJHX7UAO
roof__c, Elastomeric
room_type__c, Kitchen;Family Room;Great Room;Primary Bedroom;Primary Bedroom 2+
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
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, 3132
size__c, 3132
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Twin Peaks
subdist__c, Clarendon Heights
ffd_name, 1 Twin Peaks Boulevard, San Francisco, CA, 94114
view__c, City;Panoramic;City Lights;Bay;Downtown;San Francisco;Mt Diablo;Bridges
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1951
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530630442-1.jpg