meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221334' 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, 8 Buchanan Street #409, San Francisco, CA, 94102
ffd_mls_id, 421598192
ffd_salesforce_id, a0E8W00000V0jqBUAR
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 115
address2__c, 8 Buchanan Street #409, San Francisco, CA, 94102
pba__address_pb__c, 8 Buchanan Street #409, San Francisco, CA, 94102
agent_only_remarks__c, Private showings through ShowingTime, if you have questions ask Eddie or Hayley. Pre-escrow open with Old Republic Title, Helen Dumont, [email protected]. HOA pet policy permits 2 dogs or 2 cats or a combination thereof (but not to exceed two total). HOA rental policy permits rentals for a term of not less than 180 days. Disclosures can be viewed at hayesvalleycondo409.com
appliances__c, Dishwasher;Built-In Gas Range;Built-In Refrigerator
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2014
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Hayley G Kerstein
pba__contingentdate__c, 2021-10-19
ffd_createddate, 2021-10-11T18:51:23.000+0000
days_on_market__c, 646
dom__c, 17
ffd_description_pb, Linea Building - sleek & sophisticated 1bd, 1ba condo with light filled open plan kitchen & living/dining with wood floors. Professional-grade kitchen with quartz counters, gas oven/range and d/w. Utility area with in-unit laundry & storage space. Master bed with plush carpet, walk-in closet & wonderful southern views. A sleek bathroom with shower over tub completes this elegant unit. Built in 2014, the Linea was designed by world-renowned architect, Bernardo Fort-Brescia. The building is concrete core providing reduced noise between units. Centrally located in the Upper Market corridor bordering the hip vibrant areas of Mission Dolores, Duboce Triangle, Castro and Hayes Valley. The Linea reflects a modern SF lifestyle.
district__c, SF District 6
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
hoa_fee_includes__c, Door Person,Management,Sewer,Trash,Water
pba__hoafees__c, 464
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Linea Homeowners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T16:03:16.000+0000
pba__latitude_pb__c, 37.770074
pba__latitude_property__c, 37.770074
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2021-09-10
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_mls_id__c, 811741
listing_co_agent_number__c, 1053391
listing_co_office_mls_id__c, ELEVATE
listing_co_office_name__c, Elevation Real Estate
listing_co_office_number__c, 27424
listing_office_mls_id__c, ELEVATE
listing_office_name__c, Elevation Real Estate
listing_office_number__c, 27424
pba__listingprice_pb__c, 829000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.hayesvalleycondo409.com/
pba__longitude_pb__c, -122.426208
mls_id__c, 421598192
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000001VhmeUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-10-11
original_price__c, 829000
overall_days_on_market__c, 150
pba__pendingdate__c, 2021-10-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1263.64
pba__propertytype__c, Condominium
id, a0E8W00000V0jqBUAR
sale_date__c, 2021-11-15
sale_price__c, 834000
selling_agent_mls_id__c, 810887
selling_agent_number__c, 1048607
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 660
size__c, 660
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Buchanan
subdist__c, Hayes Valley
ffd_name, 8 Buchanan Street #409, San Francisco, CA, 94102
view__c, City Lights;Water;Downtown;San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2014
pba__postalcode_pb__c, 94102
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530331506-1.jpg
ListingId, a0E8W00000V0jqBUAR