meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219792' 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, 863 Haight Street #4, San Francisco, CA, 94117
ffd_mls_id, 421568540
ffd_salesforce_id, a0E1I00000UUnaXUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 5
address2__c, 863 Haight Street #4, San Francisco, CA, 94117
pba__address_pb__c, 863 Haight Street #4, San Francisco, CA, 94117
agent_only_remarks__c, Quiet & lovely top floor condo located in the rear of the building. Unit feels spacious and serene. Please try to make the open houses. Private showings are available by appointment with pre-approval letters. Current COVID protocol. OPEN HOUSE SCHEDULE: TH Twilight 5:30-6:30pm (7/8) TUES Tour (7/13) SAT 11am-1pm (7/10) SUN 11am-1pm (7/11) Pre-Escrow with Sylvia Wong @ Fidelity Title. Escrow #FSFM-0062101845-SW. Offers, if any, will be reviewed on Wednesday 7/14 @ 5pm.
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Range;Free Standing Refrigerator;Gas Cook Top
architectural_style__c, Edwardian
bath_features__c, Tile;Radiant Heat;Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-07-14
cooling__c, Wall Unit(s)
ffd_createddate, 2021-07-07T10:50:36.000+0000
days_on_market__c, 742
dom__c, 16
ffd_description_pb, 863 Haight is a spacious 1 bed, 1 bath south-facing top-floor condo with deeded parking on iconic Haight Street in the historic heart of San Francisco. Tastefully remodeled bathroom features double sinks, radiant heat flooring, Caesarstone countertops, and high-end fixtures. Updated kitchen has stainless steel appliances and a romantic dining nook. In-unit washer and dryer or use the common laundry adjacent to an ample-sized dedicated storage room large enough to be a mini-gym or project space. Tucked away in the rear of the building, this home is a sanctuary with treetop views and an ultra-convenient location for biking, walking, shuttles, or public transport. You will find the city's most-loved parks and neighborhoods at your doorstep along with well-known restaurants and shops just steps away. 863 Haight is a fabulous San Francisco home awaiting your ownership!
district__c, SF District 6
driveway_sidewalks__c, Gated,Paved Driveway,Shared Driveway
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Insurance on Structure,Sewer,Trash,Water
pba__hoafees__c, 469
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 863 Haight St HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant Floor;Fireplace Insert
ffd_lastmodifieddate, 2022-01-25T15:56:25.000+0000
pba__latitude_pb__c, 37.7712082
pba__latitude_property__c, 37.7712082
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2021-04-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sunae
pba__listing_agent_lastname__c, Chon
listing_agent_mls_id__c, 802621
ffd_listingagentname, Sunae Chon
listing_agent_number__c, 802621
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, AVNU
listing_office_name__c, Avenue 8 Inc.
listing_office_number__c, 28244
pba__listingprice_pb__c, 899000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.863haight.com/mls
pba__longitude_pb__c, -122.4364207
mls_id__c, 421568540
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_property__c, a0O1I000001ViUlUAK
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-07-07
original_price__c, 899000
overall_days_on_market__c, 116
parking_access__c, Side by Side
parking_features__c, Assigned,Covered,Detached,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-07-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
id, a0E1I00000UUnaXUAT
roof__c, Bitumen
room_type__c, Storage
sale_date__c, 2021-08-30
sale_price__c, 1015000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 808858
selling_agent_number__c, 1038063
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Haight
subdist__c, Hayes Valley
ffd_name, 863 Haight Street #4, San Francisco, CA, 94117
view__c, Other
website_property_type__c, Condominium
window_features__c, Window Coverings;Bay Window(s);Window Screens
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/530276041-1.jpg
ListingId, a0E1I00000UUnaXUAT