meta_query='key:subdist__c;value:Clarendon Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217854' 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, 2 Mountain Spring Avenue, San Francisco, CA, 94114
ffd_mls_id, 421531193
ffd_salesforce_id, a0E1I00000TxI1jUAF
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2 Mountain Spring Avenue, San Francisco, CA, 94114
pba__address_pb__c, 2 Mountain Spring Avenue, San Francisco, CA, 94114
agent_only_remarks__c, Buyers paid both listing and selling agent commissions. Escrow opened with Michelle Patterson at First American. Please use https://calendly.com/2mtspringshowings/20min to schedule showings. For additional times email [email protected] or call Alla at 415.748.2550 for more information.All entrants must sign a PEAD/BPPP before entry, acknowledge the Compass Covid Showing Protocol, and bring their own masks and gloves.
appliances__c, Dishwasher;Microwave;Double Oven;Built-In Refrigerator;Gas Cook Top
architectural_style__c, Contemporary;Modern/High Tech;Mid-Century
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1956
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Alla Gershberg
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-03-26T21:24:29.000+0000
days_on_market__c, 845
dom__c, 6
ffd_description_pb, Unparalleled panoramic views span every level of this mid-century modern home nestled in desirable Clarendon Heights. Lovingly updated, this fabulous abode has panache & style beyond measure! An entertainer's delight, wow your guests in the massive open LR/DR w/breathtaking views of the city. The expansive, chef's kitchen is equipped w/top of the line appliances. The main lvl is completed by a family room, a large bdrm and a remodeled bath w/steam shower. Follow the dramatic staircase up to the primary suite, a luxurious oasis w/private deck and stunning views! Enjoy serenity in the spa-like bath w/soaking tub, shower w/dual shower heads; ample closet space & dressing area. Downstairs you will find 2 additional spacious bedrooms & a full bath w/space for guests, home office & more. A two-car s/s garage w/generous storage space. Take a break from the urban scene to hike nearby Twin Peaks. Ez access to trans, live the SF dream while tucked into this beautiful quiet hillside community!
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:48:02.000+0000
pba__latitude_pb__c, 37.758147
pba__latitude_property__c, 37.758147
laundry_features__c, In Garage
listed_date__c, 2021-01-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dale
pba__listing_agent_lastname__c, Boutiette
listing_agent_mls_id__c, 806303
ffd_listingagentname, Dale T Boutiette
listing_agent_number__c, 166016715
listing_co_agent_mls_id__c, 803120
listing_co_agent_number__c, 803120
listing_co_office_mls_id__c, COMP7PAR
listing_co_office_name__c, Compass SF
listing_co_office_number__c, 27677
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 3950000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=nwBWvjvXbof
pba__longitude_pb__c, -122.448508
lower_level__c, Bedroom(s)
mls_id__c, 421531193
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Double Sinks;Soaking Tub;Multiple Shower Heads
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-03-26
original_price__c, 3950000
overall_days_on_market__c, 188
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-04-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1145.72
pba__propertytype__c, Single Family Residence
id, a0E1I00000TxI1jUAF
room_type__c, Storage;Bonus Room;Kitchen;Master Bedrooms 2+;Living Room;Master Bathroom;Dining Room;Family Room;Master Bedroom;Possible Guest
sale_date__c, 2021-04-30
sale_price__c, 4037500
selling_agent_mls_id__c, 352637
selling_agent_number__c, 352637
selling_co_agent_mls_id__c, 812389
selling_co_agent_number__c, 1056371
selling_co_office_mls_id__c, COMP7PAR
selling_co_office_name__c, Compass SF
selling_co_office_number__c, 27677
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 3524
size__c, 3524
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Mountain Spring
subdist__c, Clarendon Heights
ffd_name, 2 Mountain Spring Avenue, San Francisco, CA, 94114
view__c, City;Panoramic;City Lights;Bay;Downtown;Bay Bridge;San Francisco;Twin Peaks;Bridges
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1956
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530205696-1.jpg
ListingId, a0E1I00000TxI1jUAF