meta_query='key:subdist__c;value:North Panhandle|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219302' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15727
[post_author] => 4
[post_date] => 2018-11-02 19:54:51
[post_date_gmt] => 2018-11-02 19:54:51
[post_content] => Flat streets dotted with gingerbread Victorians and unashamedly modern interpretations of Edwardians run parallel to the panhandle of Golden Gate Park. It's all you love about Golden Gate Park, just a little more central.
[post_title] => North Panhandle
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => north-panhandle
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-15 08:13:16
[post_modified_gmt] => 2024-04-15 15:13:16
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15727
[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, 133 Clayton Street, San Francisco, CA, 94117
ffd_mls_id, 421558730
ffd_salesforce_id, a0E1I00000UTvMwUAL
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 3
address2__c, 133 Clayton Street, San Francisco, CA, 94117
pba__address_pb__c, 133 Clayton Street, San Francisco, CA, 94117
agent_only_remarks__c, OFFERS DUE on Wednesday, 6/16 at 10AM. Please DO NOT text or use Showingtime for showings. Showing instructions can be found here https://calendly.com/133claytonst/showings . Please send your PEAD to [email protected] prior to your showing. Please review disclosures in advance: https://app.glide.com/share/1HgUvGYX1FMO6gGmpu6bSn/. All COVID documents, as well as our detailed showing instructions, are available in the disclosure packet. COVID compliant showings are available every half hour from 8am-8pm and are limited to 30 minutes. Escrow is opened with [email protected]. All buyers to use the most current 7-page SFAR contract. If needed one will be provided. *All info herein is not guaranteed. Prospective purchasers are advised to independently verify accuracy and to review any disclosure information before submitting offers.*
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Built-In Gas Range
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1909
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-06-04T00:49:13.000+0000
days_on_market__c, 776
dom__c, 13
ffd_description_pb, This 3bd/2.5ba (plus a spacious bonus room!) TIC is located in the heart of NoPa, just blocks from Golden Gate Park. Extensive renovations have infused a contemporary feel while preserving the legacy of its 1909 Edwardian structure. The backyard & garden patio make a lovely retreat, beautifully landscaped and shared with only 2 other units. Follow the walkway to reach the bonus room, a bright, airy space that can serve as an office, media room, or rec area. Large bay windows flood the home with light, highlighting period details like coffered ceilings, dentil trim, and wainscoting. Built-ins flank a decorative fireplace in the formal DR, & you'll find another decorative fireplace in the LR, perfect for gatherings or quiet nights at home. A chef's kitchen boasts original hardwood floors. The primary en suite bedroom fts a Juliet balcony, walk-through closet, full bath, & garden views. Down the hall is a second full bath, powder room, huge storage closet, & laundry closet with W/D.
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Electricity,Gas,Insurance,Water
pba__hoafees__c, 350
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:54:14.000+0000
pba__latitude_pb__c, 37.7740012
pba__latitude_property__c, 37.7740012
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2021-06-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ruth
pba__listing_agent_lastname__c, Krishnan
listing_agent_mls_id__c, 400593
ffd_listingagentname, Ruth Krishnan
listing_agent_number__c, 1019790
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 1345000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=atG2t4T9p5z
pba__longitude_pb__c, -122.4493438
mls_id__c, 421558730
master_bathroom_features__c, Tub w/Shower Over;Tile
master_property__c, a0O8W00000DaE5NUAV
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-06-03
original_price__c, 1345000
overall_days_on_market__c, 154
parking_features__c, Other
pba__pendingdate__c, 2021-06-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1035.5
pba__propertytype__c, Tenancy In Common
id, a0E1I00000UTvMwUAL
sale_date__c, 2021-07-01
sale_price__c, 1750000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, MLSL5086246
selling_agent_number__c, 981361324
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Intero Real Estate Services
pba__status__c, Closed
pba__totalarea_pb__c, 1690
size__c, 1690
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Clayton
subdist__c, North Panhandle
ffd_name, 133 Clayton Street, San Francisco, CA, 94117
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1909
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530255726-1.jpg
ListingId, a0E1I00000UTvMwUAL