meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='337020' 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-06-23 08:37:02
[post_modified_gmt] => 2023-06-23 15:37:02
[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, 63 Delmar Street, San Francisco, CA, 94117
ffd_mls_id, 423900409
ffd_salesforce_id, a0E8W00000cpetsUAA
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 2
address2__c, 63 Delmar Street, San Francisco, CA, 94117
pba__address_pb__c, 63 Delmar Street, San Francisco, CA, 94117
agent_only_remarks__c, Tandem garage parking, but the retired friendly owners downstairs tend to park their vintage Porsche at the rear of the garage, allowing in/out access convenience for the upper unit owners. Neighbors have expressed that they are more than happy to meet and chat with potential new owners. Presale escrow opened with Connie Choy, WFG National Title Insurance Co., [email protected], Esc#23-155116. Owner-occupied but easy to show; please contact listing agents by text/email. Disclosures here: https://app.disclosures.io/link/63-Delmar-Street-2ldyky3h
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1903
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Natalie Rome
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-08-26T02:53:26.000+0000
days_on_market__c, 28
dom__c, 28
ffd_description_pb, Located in a highly sought-after, serene enclave where Cole Valley, Ashbury Heights, the Haight, and Buena Vista Park converge, you'll discover this impeccably renovated and maintained upper flat within a charming, two-unit structure. This delightful home has been thoughtfully transformed to offer an inviting ambiance at every turn. Step inside and be greeted by the warm embrace of the living room, complete with a cozy fireplace. Adjacent to this is a dining room that opens onto a charming patio, creating an ideal space for al fresco meals. The heart of this home is the exquisite chef's kitchen, featuring a slate floor and resplendent quartz countertops. It also features a convenient adjacent office nook, making it a versatile hub for work and an ideal space for productivity. Every corner of this condominium exudes a sense of welcome and comfort. Outside you'll find a shared yard with a brick patio & a venerable fig tree, perfect for relaxation and outdoor gatherings. Tandem garage parking ensures your convenience, while a shared separate laundry room, complete with a recreational space, adds practicality to your everyday life. Abundant storage space ensures a clutter-free environment. This exceptional location offers unbeatable access to shopping, dining & much, much more.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Slate;Wood
hoa_fee_includes__c, Common Areas,Electricity,Homeowners Insurance,Trash,Water
pba__hoafees__c, 375
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 63-65 DELMAR STREET HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-09-23T01:47:22.000+0000
pba__latitude_pb__c, 37.76796
pba__latitude_property__c, 37.76796
laundry_features__c, In Basement
listed_date__c, 2023-08-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Derek
pba__listing_agent_lastname__c, Chin
listing_agent_mls_id__c, 189082
ffd_listingagentname, Derek Chin
listing_agent_number__c, 189082
listing_co_agent_mls_id__c, 803584
listing_co_agent_number__c, 803584
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1249000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.63delmar.com/mls
pba__longitude_pb__c, -122.44588
mls_id__c, 423900409
main_level__c, Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Marble
master_property__c, a0O8W00000KSKF1UAP
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-08-25
open_house_end__c, 2023-09-23T16:00:00.000+0000
open_house_start__c, 2023-09-23T14:30:00.000+0000
original_price__c, 1329000
overall_days_on_market__c, -81685
parking_access__c, Tandem
parking_features__c, Garage Door Opener,Garage Facing Front,Interior Access,Tandem Garage,Unassigned
parking_type__c, On Site - Unassigned (Condo Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-09-21T16:16:19.000+0000
price_per_square_foot__c, 1200.96
price_reduced__c, 1
pba__propertytype__c, Condominium
ListingId, a0E8W00000cpetsUAA
room_type__c, Storage;Bonus Room;Wine Storage Area
sale_date__c, 1800-01-01
sale_price__c, 0
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, 1040
size__c, 1040
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Delmar
subdist__c, Haight Ashbury
ffd_name, 63 Delmar Street, San Francisco, CA, 94117
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1903
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530661782-1.jpg