meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='325764' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15729
[post_author] => 4
[post_date] => 2018-11-02 19:54:53
[post_date_gmt] => 2018-11-02 19:54:53
[post_content] => From freeway-bisected loser to urban renaissance pedestrian paradise winner. Sunny. Central. Flat. Where Victorians make friends with modern condos. Great shops, boutiques, and restaurants served by great transit. A San Francisco success story.
[post_title] => Hayes Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => hayes-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:31:42
[post_modified_gmt] => 2024-04-09 18:31:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15729
[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, 64 Waller Street, San Francisco, CA, 94102
ffd_mls_id, 423714180
ffd_salesforce_id, a0E8W00000a6h7LUAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 2
address2__c, 64 Waller Street, San Francisco, CA, 94102
pba__address_pb__c, 64 Waller Street, San Francisco, CA, 94102
agent_only_remarks__c, This Hayes Valley home checks ALL the boxes! 64 Waller is vacant and easy to show by appointment. Please schedule using the ShowingTime app (the lockbox access will be provided in the ShowingTime instructions). Preliminary escrow #0216037050-HD has been opened at Old Republic Title. Contact Maria Smith, Escrow Officer, at [email protected] or at 415.570.0872. Property disclosures available - use this access link: https://app.disclosures.io/link/64-Waller-Street-526tytk1. Contact the listing agent regarding offering instructions. Pet Policy: limit of 2 four-legged household pets (no size or breed restrictions). No rental restrictions. www.64waller.com.
appliances__c, Free Standing Gas Range
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1890
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-01-06T01:47:01.000+0000
days_on_market__c, 195
dom__c, 13
ffd_description_pb, A must-see for the buyer who wants it all - San Francisco charm w/modern aesthetic & just steps from the vibrancy of Hayes Valley! Outstanding 2-level house-like condo exudes bygone attention-to-detail w/a modern remodel throughout. The sun-drenched FLR w/gleaming wood floors, high ceilings, picture rails, bay windows & deco frplc defines elegance. At the rear of the home is the spacious kitchen w/formal dining area. Featured are beautiful Caesarstone counters, abundant wood cabinets, glass tile backsplash, professional stainless steel appliances & breakfast bar. From the kitchen is direct French door access to a deeded deck & large shared yard w/exquisite al fresco dining area draped w/string lights leading to the manicured lawn. The primary suite also has French doors leading to the rear yard & includes a large walk-in closet w/closet system & spa-like en-suite BA w/stall shower, custom subway tile & vanity with Caesarstone counters & wood cabinets. There is a 2nd guest BD & 2nd full remodeled BA w/shower-over-jetted tub, subway tile & Caesarstone vanity. Newer systems throughout. Ideally located just steps from Hayes Valley's chic restaurants & boutique shopping. Enjoy easy access to the I-80/US-101 freeways as well as public transportation. Walk score=99; Transit=100; Bike=86
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 370
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 64-66 Waller St HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2023-07-13T18:12:46.000+0000
pba__latitude_pb__c, 37.7721511
pba__latitude_property__c, 37.7721511
laundry_features__c, Inside Area;Washer Included;Dryer Included;Cabinets
listed_date__c, 2023-01-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Edmond
pba__listing_agent_lastname__c, O'Sullivan
listing_agent_mls_id__c, 804421
ffd_listingagentname, Eddie O'Sullivan
listing_agent_number__c, 166013970
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, ELEVATE
listing_office_name__c, Elevation Real Estate
listing_office_number__c, 27424
pba__listingprice_pb__c, 1675000
pba__listingtype__c, Sale
pba__listing_website__c, http://64waller.com
pba__longitude_pb__c, -122.4247404
lower_level__c, Full Bath(s),Garage,Primary Bedroom
mls_id__c, 423714180
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Dining Room;Family Room;Street Entrance
master_bathroom_features__c, Quartz;Walk-In Closet
master_property__c, a0O8W00000FrgxVUAR
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-01-05
original_price__c, 1675000
overall_days_on_market__c, -81453
parking_access__c, Side by Side
parking_features__c, Enclosed,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
pba__pendingdate__c, 2023-01-18
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 991.12
pba__propertytype__c, Condominium
ListingId, a0E8W00000a6h7LUAQ
sale_date__c, 2023-02-17
sale_price__c, 1675000
security_features__c, Carbon Mon Detector;Video System
selling_agent_mls_id__c, 811361
selling_agent_number__c, 1051130
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, City Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1690
size__c, 1690
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Waller
subdist__c, Hayes Valley
ffd_name, 64 Waller Street, San Francisco, CA, 94102
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1890
pba__postalcode_pb__c, 94102
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530566340-1.jpg