meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='223843' 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] => 2023-06-23 08:49:02
[post_modified_gmt] => 2023-06-23 15:49:02
[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, 525 Gough Street #104, San Francisco, CA, 94102
ffd_mls_id, 477763
ffd_salesforce_id, a0E1I000004u1xEUAQ
address2__c, 525 Gough Street #104, San Francisco, CA, 94102
pba__address_pb__c, 525 Gough Street #104, San Francisco, CA, 94102
agent_only_remarks__c, OFFERS DUE 10/31/19 by 2:00 pm. New floors in living area, new carpets upstairs. Freshly painted landscaped garden Feels like a brand new condo. Please note, HOA is going to be painting the common hallways. It has been approved by the HOA. TWO pet limit restriction with certain breeds not allowed. No weight limit. There is one prior owner suing commercial unit for back dues and insurance company is handling. Has NOTHING to do with construction/building.2 of the 23 units are commercial
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 2005
pba__city_pb__c, San Francisco
ffd_createddate, 2018-10-30T19:49:40.000+0000
days_on_market__c, 1734
dom__c, 31
ffd_description_pb, An oasis of calm in the middle of Hayes Valley! This modern 3 BDRM, 3 BTH, two-level condo in the heart of Hayes Valley,is steps from the boutiques, restaurants & neighborhood attractions, yet feels quiet & secluded. The main floor offers an open layout consisting of a spacious kitchen (boasting an island, granite countertops, & high-end appliances), a dining area, as well as a living area that has a gas fireplace & opens to the private, landscaped, rear terrace. Generous storage & a full bath complete this level. The second floor has two large master suites, one w/a private, sunny balcony & the other w/ a private entrance, as well as two baths & an additional BDRM.The deeded parking space is ideally situated. Not to be missed!
district__c, SF District 6
external_listing__c, 1
pba__floor__c, 0
hoa_dues__c, 513.14
hoa_fee_includes__c, Water,Garbage,Ext Bldg Maintenance,Homeowners Insurance,Outside Management
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-03-01T19:30:11.000+0000
pba__latitude_pb__c, 37.778294
pba__latitude_property__c, 37.778294
laundry_appliances__c, Washer/Dryer,In Closet
listed_date__c, 2018-08-27
pba__listing_agent_firstname__c, William
pba__listing_agent_lastname__c, Kitchen
listing_agent_mls_id__c, 803707
listing_agent_number__c, 803707
listing_co_agent_mls_id__c, 804346
listing_co_agent_number__c, 166013876
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1325000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.423660
pba__lotsize_pb__c, 0
mls_id__c, 477763
master_property__c, a0O1I000001VhuPUAS
monthly_parking_fees__c, 0
parkingspaces__c, 1
on_market_date__c, 2018-10-19
original_price__c, 1325000
overall_days_on_market__c, 1734
parking_access__c, Side-by-Side
parking_features__c, Enclosed,Attached,Interior Access,Automatic Door,Garage
parking_type__c, Designated On Site
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
id, a0E1I000004u1xEUAQ
sale_date__c, 2018-12-19
sale_price__c, 1490000
selling_agent_mls_id__c, 331733
selling_agent_name__c, James B. Hurley
selling_agent_number__c, 331733
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Sold
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
pba__street_pb__c, Gough
subdist__c, Hayes Valley
ffd_name, 525 Gough Street #104, San Francisco, CA, 94102
transportation__c, 1 Block
unit_number__c, 104
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2005
pba__postalcode_pb__c, 94102
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/343962-1.jpg
ListingId, a0E1I000004u1xEUAQ
