meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327056' 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] => 2018-11-02 19:54:59
[post_modified_gmt] => 2018-11-02 19:54:59
[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, 41 Delmar Street, San Francisco, CA, 94117
ffd_mls_id, 423724832
ffd_salesforce_id, a0E8W00000bEzXIUA0
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 2
address2__c, 41 Delmar Street, San Francisco, CA, 94117
pba__address_pb__c, 41 Delmar Street, San Francisco, CA, 94117
agent_only_remarks__c, Rare Condo with Fully Deeded Garden - Call John for highest best use of bonus lower level rooms.
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;Free Standing Refrigerator;Gas Cook Top;Free Standing Freezer;Warming Drawer
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1904
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-03T16:49:27.000+0000
days_on_market__c, 28
dom__c, 28
ffd_description_pb, Sophisticated finishes, custom design, full floor 2BD/1.5BA condo w/ DEEDED GARDEN; the condo also includes two spacious, deeded, unwarranted rooms and a bath on the garden level with awesome potential. Lavish detail in spa-like baths, professionally equipped Italian Scavolini kitchen: Stainless Chef's range Range, Carrera bar, cherry cabinets, custom stainless counters. Full size, in-unit laundry custom closets & polished period detail create the ultimate, practical, urban retreat. Deeded to the property on the lower level are two unwarranted rooms and a bath with high ceilings, & direct walkout access to a landscaped exclusive-use garden. Parking for 1 car + storage. This perfect neighborly location keeps you firmly in the mix at the intersection of Cole Valley, Buena Vista Park, Ashbury Heights & the Divisadero Corridor.
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Dog Run
external_listing__c, 1
fencing__c, Back Yard;Fenced
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 400
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 39-41 Delmar HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-03-30T10:48:16.000+0000
pba__latitude_pb__c, 37.768377
pba__latitude_property__c, 37.768377
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included;Inside Area;Washer Included
listed_date__c, 2023-03-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, DiDomenico
listing_agent_mls_id__c, 276181
ffd_listingagentname, John R DiDomenico
listing_agent_number__c, 276181
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 1695000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/803954984/41fa1d55d8
pba__longitude_pb__c, -122.44598
lower_level__c, Family Room,Full Bath(s),Retreat
mls_id__c, 423724832
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_property__c, a0O8W00000HtdcZUAR
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-02
open_house_end__c, 2023-04-01T16:00:00.000+0000
open_house_start__c, 2023-04-01T14:00:00.000+0000
original_price__c, 1695000
overall_days_on_market__c, -81509
parking_access__c, Tandem
parking_features__c, Tandem Garage
parking_type__c, On Site - Unassigned (Condo 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, 1070.08
pba__propertytype__c, Condominium
ListingId, a0E8W00000bEzXIUA0
roof__c, Flat
room_type__c, Bonus Room;Kitchen;Living Room;Dining Room;Possible Guest;Primary Bathroom;Primary Bedroom
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, 1584
size__c, 1584
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Delmar
subdist__c, Haight Ashbury
ffd_name, 41 Delmar Street, San Francisco, CA, 94117
website_property_type__c, Condominium
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1904
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530586463-1.jpg