meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217746' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15734
[post_author] => 4
[post_date] => 2018-11-02 19:54:59
[post_date_gmt] => 2018-11-02 19:54:59
[post_content] => Jimi Hendrix, Janis Joplin, The Grateful Dead. 1968. Victorians, Edwardians, street punks, and skater kids. Everyone has an idea of what the Haight should be. Come discover what it actually is for yourself.
[post_title] => Haight Ashbury
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => haight-ashbury
[to_ping] =>
[pinged] =>
[post_modified] => 2023-10-31 09:46:57
[post_modified_gmt] => 2023-10-31 16:46:57
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15734
[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, 720 Clayton Street, San Francisco, CA, 94117
ffd_mls_id, 421526183
ffd_salesforce_id, a0E1I00000TwyDcUAJ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 4
address2__c, 720 Clayton Street, San Francisco, CA, 94117
pba__address_pb__c, 720 Clayton Street, San Francisco, CA, 94117
agent_only_remarks__c, In contract (with contingencies), but still showing for backup offer purposes. **Please send PEAD to [email protected] within 24 hours of your showing to obtain lockbox CBS code.** Pet policy: one dog (weight limit 35 lbs) or two cats. Common HOA expenses, averaging $320/month, are paid as incurred and cover insurance and water. Per sellers' request, no preemptive offers. This is a four unit HOA, three of the units are owned by the same person and are rented out. Please check with your client's lender that this will not be an issue before submitting an offer.
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Range;Free Standing Refrigerator;Wine Refrigerator
architectural_style__c, Edwardian
bath_features__c, Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1906
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-03-25
ffd_createddate, 2021-03-20T21:49:24.000+0000
days_on_market__c, 854
dom__c, 16
ffd_description_pb, Classic, updated, top floor Edwardian 3BR/2BA light and bright condominium with a private deck and partial downtown views - perfect for outdoor dining! Prime location on the border of Cole Valley and Haight Ashbury. Stylishly remodeled bathrooms and kitchen with stainless steel appliances (Bosch, Verona) and Ann Sacks tiles. Many period details such as decorative fireplaces, coved ceilings, bay windows, built-in cabinetry, and wainscoting, in addition to beautiful custom latticework oak door and newer double-paned windows throughout. In-unit full-size washer and dryer, skylight, and abundant ground floor storage space. The shared garden with citrus and fig trees is accessed from the south- and east-facing exclusive use deck off of the kitchen. Close proximity to LFSF, Grattan Elementary School, and New Traditions Elementary School. Easy access to shops, restaurants, Whole Foods, public transportation, and Golden Gate Park; walk score: 97.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 320
pba__hoafrequency_pb__c, See Remarks
hoa_name__c, 720-720A-722-722A Clayton St
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:47:26.000+0000
pba__latitude_pb__c, 37.768437
pba__latitude_property__c, 37.768437
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included;Inside Area;Washer Included;Dryer Included
listed_date__c, 2021-03-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Erik
pba__listing_agent_lastname__c, Reider
listing_agent_mls_id__c, 802810
ffd_listingagentname, Erik Reider
listing_agent_number__c, 802810
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CGL
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28240
pba__listingprice_pb__c, 1450000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=auaF4p5fjEr&brand=0
pba__longitude_pb__c, -122.447997
mls_id__c, 421526183
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000004VXqmUAG
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-03-17
original_price__c, 1450000
overall_days_on_market__c, 174
parking_features__c, No Garage
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-04-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1100.07
pba__propertytype__c, Condominium
id, a0E1I00000TwyDcUAJ
room_type__c, Storage;Kitchen;Living Room;Dining Room
sale_date__c, 2021-04-26
sale_price__c, 1550000
selling_agent_mls_id__c, B406400
selling_agent_number__c, 981343299
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Luxe Places International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1409
size__c, 1409
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Clayton
subdist__c, Haight Ashbury
ffd_name, 720 Clayton Street, San Francisco, CA, 94117
view__c, City Lights
website_property_type__c, Condominium
window_features__c, Dual Pane Partial
pba__yearbuilt_pb__c, 1906
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530201520-1.jpg
ListingId, a0E1I00000TwyDcUAJ