meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215587' 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] => 2024-04-09 11:28:05
[post_modified_gmt] => 2024-04-09 18:28:05
[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, 508 Cole Street, San Francisco, CA, 94117
ffd_mls_id, 507667
ffd_salesforce_id, a0E1I00000TTKyNUAX
num_of_fireplaces__c, 4
num_of_rooms__c, 10
of_units__c, 0
address2__c, 508 Cole Street, San Francisco, CA, 94117
pba__address_pb__c, 508 Cole Street, San Francisco, CA, 94117
agent_only_remarks__c, Easy to sow by appointment to arrange for private showings after viewing all media at VictorianOn Cole.com + providing PreApproval/VOF + PEAD. per COVID Compliant Showing rules. www.VictorianOnCole.com
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Freestanding Range;Hood Over Range;Self/Cont Clean Oven
architectural_style__c, Victorian
bath_features__c, Marble;Radiant Heat
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sharon S Bacigalupi
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-10-16T22:45:20.000+0000
days_on_market__c, 1006
dom__c, 11
ffd_description_pb, Rarely does a home of such prominence and impeccable condition become available.This exceptional 4 level Victorian was painstakingly redeveloped with the finest attention to detail, combining the best of modern living while keeping intact the exquisite quintessential details of the Queen Anne Victorian era.Boasting a little over 3800 square feet on 5 levels of living space, this magnificent home features grand rooms with an open flow perfect for today's lifestyle,soaring ceilings 5 bedrooms,3 full bathrooms and two half baths,4 restored fireplaces,a spectacular kitchen designed for the most discriminating chef,a dog washing station,home office for two, home gym, large laundry room and a dramatic top level primary suite showcasing a luxurious marble bath with private terrace,extensive closet space,fireplace and second laundry area.
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, 220 Volts in Kitchen
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Master Bedroom;Dining Room
pba__floortype_pb__c, Carpet;Linoleum;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Hot Water;Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:37:58.000+0000
pba__latitude_pb__c, 37.770324
pba__latitude_property__c, 37.770324
laundry_features__c, In Garage;Inside Room;Laundry Closet
listed_date__c, 2020-08-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Marianne
pba__listing_agent_lastname__c, Bacigalupi Schier
listing_agent_mls_id__c, 971052
ffd_listingagentname, Marianne Bacigalupi Schier
listing_agent_number__c, 971052
listing_co_agent_mls_id__c, 369072
listing_co_agent_number__c, 369072
listing_co_office_mls_id__c, COMP12PUI
listing_co_office_name__c, Compass
listing_co_office_number__c, 27690
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 2999000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/465370795
pba__longitude_pb__c, -122.450107
pba__lotsize_pb__c, 0.05
lower_level__c, Family Room,Partial Bath(s)
mls_id__c, 507667
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-10-16
original_price__c, 2999000
overall_days_on_market__c, 133
parking__c, Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Enclosed Patio
pba__pendingdate__c, 2020-10-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 854.59
pba__propertytype__c, Single Family Residence
id, a0E1I00000TTKyNUAX
room_type__c, Storage;Office;Laundry;Den
sale_date__c, 2020-11-03
sale_price__c, 3250000
security_features__c, Smoke Detector;Fire Suppression System
selling_agent_mls_id__c, 807341
selling_agent_name__c, Myrick Tantiado
selling_agent_number__c, 1016143
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 3803
size__c, 3803
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Cole
subdist__c, Haight Ashbury
ffd_name, 508 Cole Street, San Francisco, CA, 94117
transportation__c, 1 Block
website_property_type__c, Single Family Home
window_features__c, Window Coverings;Bay Window(s)
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/372398-1.jpg
ListingId, a0E1I00000TTKyNUAX