meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221121' 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, 758 Haight Street #2, San Francisco, CA, 94117
ffd_mls_id, 421595813
ffd_salesforce_id, a0E1I00000V0GzgUAF
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 5
address2__c, 758 Haight Street #2, San Francisco, CA, 94117
pba__address_pb__c, 758 Haight Street #2, San Francisco, CA, 94117
agent_only_remarks__c, Lockbox access available, please call/text Ted at 415.608.0794 or email [email protected] prior to showing. Escrow opened with Janette Marcelo at Old Republic Title. Disclosures available at https://app.disclosures.io/link/758-Haight-Street-2-ggs1p199
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Oven;Free Standing Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Matthew J Goulden CHS
pba__contingentdate__c, 2021-10-29
ffd_createddate, 2021-09-17T10:49:56.000+0000
days_on_market__c, 670
dom__c, 56
ffd_description_pb, Buy It Now / Transparent Pricing! Find your San Francisco sanctuary in this serene 1BR Condo in the heart of the vibrant Lower Haight. This light and bright home is located at the rear of the main level of a grand Queen Anne Victorian and offers respite from the world with its private setting overlooking the tranquil, shared rear yard. This elegant home is move-in ready with a remodeled Kitchen and Bathroom. Light pours into the spacious Living Room with high ceilings and dances across the warmth of the cherry hardwood floors throughout. At the rear of the unit is a generously-sized Bedroom with direct access to an exclusive use wraparound deck - perfect for morning coffee, afternoon lounging, or al fresco dining. A sizable storage closet awaits just outside your front door in the foyer of this 5-unit building. Parks, restaurants, nightlife, and shopping are abundant in this bustling area bordered by Divisadero & Hayes Valley, and Duboce Park & Alamo Square. Walk Score 98.
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 315
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T16:02:11.000+0000
pba__latitude_pb__c, 37.7717967
pba__latitude_property__c, 37.7717967
listed_date__c, 2021-08-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Edward
pba__listing_agent_lastname__c, O'Connell
listing_agent_mls_id__c, 813549
ffd_listingagentname, Ted O'Connell
listing_agent_number__c, 1062118
listing_co_agent_mls_id__c, 981562
listing_co_agent_number__c, 981562
listing_co_office_mls_id__c, CGL
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28240
listing_office_mls_id__c, CGL
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28240
pba__listingprice_pb__c, 900000
pba__listingtype__c, Sale
pba__listing_website__c, http://haightstreethideaway.com/
pba__longitude_pb__c, -122.4346922
mls_id__c, 421595813
master_property__c, a0O1I000004VXRZUA4
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-09-17
original_price__c, 849000
overall_days_on_market__c, 105
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-11-12
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, a0E1I00000V0GzgUAF
sale_date__c, 2021-12-01
sale_price__c, 843000
selling_agent_mls_id__c, MLSL5087433
selling_agent_number__c, 981367747
selling_co_agent_mls_id__c, MLSL5086785
selling_co_agent_number__c, 981363600
selling_co_office_mls_id__c, RVL-1
selling_co_office_name__c, Reveal Real Estate
selling_co_office_number__c, 981086523
selling_office_name__c, Reveal Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Haight
subdist__c, Hayes Valley
ffd_name, 758 Haight Street #2, San Francisco, CA, 94117
website_property_type__c, Condominium
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/530324689-1.jpg
ListingId, a0E1I00000V0GzgUAF