meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221855' 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, 119 Frederick Street, San Francisco, CA, 94117
ffd_mls_id, 421608409
ffd_salesforce_id, a0E8W00000V1a6AUAR
num_of_fireplaces__c, 4
num_of_rooms__c, 11
of_units__c, 0
address2__c, 119 Frederick Street, San Francisco, CA, 94117
pba__address_pb__c, 119 Frederick Street, San Francisco, CA, 94117
agent_only_remarks__c, No showings before Friday, November 5, please don't even ask...email [email protected] to arrange. We are finishing up work on the house this week and inspections are early next week. Security cameras not included in sale. 2 car parking, one in garage with internal access, and one in driveway. Pre-escrow open with Joanne Kung at Chicago Title. Seller has requested no pre-emptives. Offers to be reviewed Wednesday Nov 17 at Noon.
appliances__c, Wine Refrigerator;Gas Cook Top
architectural_style__c, Edwardian;Craftsman
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 6
year_build_text__c, 1910
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2021-11-03T10:48:55.000+0000
days_on_market__c, 623
dom__c, 15
ffd_description_pb, Stunning Cole Valley home w/grand entrance, high ceilings, gorgeous wood trim & floors throughout. Massive remodeled eat-in kitchen w/island, Carrera countertops/backsplash & tons of windows. Grand LR & DR are as period perfect as they come. Newly renovated powder room completes this level. Upstairs you'll find 3 huge bedrooms, a family room/office (could easily be 4th bedroom) & a full bathroom, with plenty of flexibility for how each room is used. Off of the den is a south facing deck, perfect to soak in the sunshine. W/D complete this level. On 3rd floor are 3 more flexible use bedrooms, one running the width of the house with beautiful north facing views of GGB, St. Ignatius and the Marin Headlands and another full bath with soaking tub. All can be used as office space, workout room, primary bedroom or family room. Full garage w/1-car pkg & tons of storage below. Mere blocks away from Cole Valley's vibrant dining, shopping & N-Judah and corporate shuttles are just blocks away.
district__c, SF District 5
electric__c, 220 Volts in Kitchen,220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Dining Room;Kitchen
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Skylight(s)
ffd_lastmodifieddate, 2022-01-25T16:05:34.000+0000
pba__latitude_pb__c, 37.767064
pba__latitude_property__c, 37.767064
laundry_features__c, Washer/Dryer Stacked Included;Upper Floor
listed_date__c, 2021-10-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ilana
pba__listing_agent_lastname__c, Minkoff
listing_agent_mls_id__c, 807966
ffd_listingagentname, Ilana D Minkoff
listing_agent_number__c, 1029271
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 3990000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/640612014
pba__longitude_pb__c, -122.445721
lower_level__c, Dining Room,Kitchen,Living Room,Partial Bath(s)
mls_id__c, 421608409
main_level__c, Full Bath(s);Bedroom(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-11-03
original_price__c, 3990000
overall_days_on_market__c, 58
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Uncovered Parking Space
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch
pba__pendingdate__c, 2021-11-18
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1306.12
pba__propertytype__c, Single Family Residence
id, a0E8W00000V1a6AUAR
room_type__c, Storage;Den;Kitchen;Master Bedrooms 2+;Living Room;Dining Room;Family Room;Great Room;Media Room
sale_date__c, 2021-11-29
sale_price__c, 4800000
selling_agent_mls_id__c, 803037
selling_agent_number__c, 803037
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 3675
size__c, 3675
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Frederick
subdist__c, Haight Ashbury
ffd_name, 119 Frederick Street, San Francisco, CA, 94117
view__c, Mt Tamalpais
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1910
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530351390-1.jpg
ListingId, a0E8W00000V1a6AUAR