meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='222109' 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, 558 Ashbury Street, San Francisco, CA, 94117
ffd_mls_id, 421564934
ffd_salesforce_id, a0E1I00000UVhZdUAL
num_of_fireplaces__c, 2
num_of_rooms__c, 7
of_units__c, 3
address2__c, 558 Ashbury Street, San Francisco, CA, 94117
pba__address_pb__c, 558 Ashbury Street, San Francisco, CA, 94117
agent_only_remarks__c, In contract with a 5 day inspection contingency. Open to a back up offer. Uside potential to add a full-sized second bathroom creating an ensuite primary bedroom at the rear of the unit. Escrow is open with Elisabeth Davis, Fidelity 0312100282. Disclosures here: https://app.glide.com/share/s6G6NfbrYK0r5eJnkvAUi/ This is an As-Is sale. The information presented by 3rd parties has not and will not be verified by the listing agent. *Buyer to investigate all matters to their satisfaction.
appliances__c, Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over;Split Bath;Tile;Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1904
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Emery G Bushong
pba__contingentdate__c, 2021-11-30
ffd_createddate, 2021-08-05T01:51:31.000+0000
days_on_market__c, 714
dom__c, 122
ffd_description_pb, This gorgeous top-level condominium located near the vibrant, historic, and sought after Haight/North of Panhandle (NOPA) and Divisadero neighborhoods. You'll fall in love with the high ceilings, original period moldings, gleaming wood floors, and abundant natural light filtering through the windows from one end of the flat to the other. The 1,651sf* of space includes three separated bedrooms (one with an adjoining room that could potentially be a 2nd full bathroom!). You'll love the formal dining room with it's massive built-in, the huge pantry closet, the transom windows and 2 decorative fps, and the updated eat-in kitchen with granite countertops and maple cabinets. For the chef, enjoy a full array of stainless-steel appliances. In-unit washer/dryer and folding counter adds to your convenience. Huge private storage area below, and a shared yard, leased pkg 1/2 blk away. Easy access to restaurants, shopping, transport, and renowned parks.
district__c, SF District 5
driveway_sidewalks__c, Paved Sidewalk
electric__c, 220 Volts
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Decorative Only
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Electricity,Insurance on Structure,Sewer,Trash,Water
pba__hoafees__c, 325
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 554-556-558 Ashbury Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Wall Furnace;Gas;Fireplace Insert;MultiUnits
ffd_lastmodifieddate, 2022-01-25T23:46:52.000+0000
pba__latitude_pb__c, 37.770239
pba__latitude_property__c, 37.770239
laundry_features__c, In Kitchen;Washer Included;Dryer Included;Gas Hook-Up
listed_date__c, 2021-06-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mark
pba__listing_agent_lastname__c, McHale
listing_agent_mls_id__c, 800917
ffd_listingagentname, Mark D McHale
listing_agent_number__c, 800917
listing_co_agent_mls_id__c, 257280
listing_co_agent_number__c, 257280
listing_co_office_mls_id__c, VANG03
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 1228
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=iTaUx9u1nwk
pba__longitude_pb__c, -122.446685
mls_id__c, 421564934
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000004VWcCUAW
monthly_parking_fees__c, 350
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-08-04
original_price__c, 1495000
overall_days_on_market__c, 133
parking_access__c, Independent
parking_features__c, See Remarks
parking_type__c, On Site - Lease Available (Condo Only)
pba__pendingdate__c, 2021-12-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 844.94
pba__propertytype__c, Condominium
id, a0E1I00000UVhZdUAL
roof__c, Tar/Gravel
room_type__c, Storage;Office;Kitchen;Living Room;Dining Room
sale_date__c, 2021-12-30
sale_price__c, 1395000
security_features__c, Security Gate
selling_agent_mls_id__c, EB140023
selling_agent_number__c, 981308789
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1651
size__c, 1651
pba__state_pb__c, CA
stories__c, 1
pba__street_pb__c, Ashbury
subdist__c, Haight Ashbury
ffd_name, 558 Ashbury Street, San Francisco, CA, 94117
website_property_type__c, Condominium
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/530265766-1.jpg
ListingId, a0E1I00000UVhZdUAL