meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209447' 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, 160 Germania, San Francisco, CA, 94117
ffd_mls_id, 490755
ffd_salesforce_id, a0E1I00000KHZ0pUAH
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 160 Germania, San Francisco, CA, 94117
pba__address_pb__c, 160 Germania, San Francisco, CA, 94117
agent_only_remarks__c, While listed in MLS as a SFR, this new stand-alone building is technically a 25% interest in the existing TIC project of 457-459-461 Waller. The new owners will have the opportunity to convert just this building to its own condominium (with its own single-unit HOA). Feel free to show this blind as the staging is great and it shows and feels terrifically!
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;ENERGY STAR Qualified Appliances
architectural_style__c, Contemporary;Craftsman
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Barry A Brostoff
pba__contingentdate__c, 2019-11-19
ffd_createddate, 2019-10-21T18:45:59.000+0000
days_on_market__c, 1389
dom__c, 110
ffd_description_pb, NEW PRICE! Come see this spectacular, new stand-alone property just a block away from Duboce Park! On a site where there once was nothing but dirt, this brand new residence with top end finishes has it all from a terrific open floor plan on the upper level, an awesome rooftop deck with outstanding city views to its own private rear patio to one car parking. Need bedrooms? This place has four of them! Need bathrooms? This house has three of them plus a powder room on the upper entertaining level. It even has a dumbwaiter to bring your groceries up to the kitchen! Bathed in natural light, this is one property not to be missed if you want a special home close to the vibrant Duboce Triangle/Hayes Valley areas and all these neighborhoods have to offer including wonderful restaurants, cafes and parks. No wonder it has a Walk Score of 93! Zip downtown on Muni light rail which is just a block away.
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2022-01-12T15:25:04.000+0000
pba__latitude_pb__c, 37.7707979
pba__latitude_property__c, 37.7707979
laundry_features__c, Laundry Closet;Hookups Only
listed_date__c, 2019-09-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Bruce
pba__listing_agent_lastname__c, Lyon
listing_agent_mls_id__c, 802384
ffd_listingagentname, Bruce Lyon
listing_agent_number__c, 802384
listing_co_agent_mls_id__c, 276168
listing_co_agent_number__c, 276168
listing_co_office_mls_id__c, CBLUXURY
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 2128
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 2695000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4311589
pba__lotsize_pb__c, 0
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 490755
main_level__c, Full Bath(s);Bedroom(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2019-09-29
original_price__c, 2900000
overall_days_on_market__c, 180
parking__c, Garage
parking_access__c, Independent
parking_features__c, Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-02-07
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1017.61
pba__propertytype__c, Single Family Residence
id, a0E1I00000KHZ0pUAH
sale_date__c, 2020-02-19
sale_price__c, 2600000
selling_agent_mls_id__c, 813002
selling_agent_name__c, Tracy Hsieh
selling_agent_number__c, 1058962
selling_co_agent_mls_id__c, 808482
selling_co_agent_name__c, Michael Minson
selling_co_agent_number__c, 1035858
selling_co_office_mls_id__c, KWRSF
selling_co_office_name__c, Keller Williams San Francisco
selling_co_office_number__c, 26158
selling_office_name__c, Keller Williams San Francisco
pba__status__c, Closed
pba__totalarea_pb__c, 2555
size__c, 2555
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Germania
subdist__c, Hayes Valley
ffd_name, 160 Germania, San Francisco, CA, 94117
transportation__c, 1 Block
view__c, City Lights
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/356588-1.jpg
ListingId, a0E1I00000KHZ0pUAH