meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215039' 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, 518 Page Street, San Francisco, CA, 94117
ffd_mls_id, 506076
ffd_salesforce_id, a0E1I00000THo6YUAT
num_of_fireplaces__c, 2
num_of_rooms__c, 0
of_units__c, 3
address2__c, 518 Page Street, San Francisco, CA, 94117
pba__address_pb__c, 518 Page Street, San Francisco, CA, 94117
agent_only_remarks__c, Please email [email protected] for showing request and questions. Property website with floor plan here: www.518Page.com. Showings by appointment under state and local guidelines for qualified prospects. Contact listing agent for showing protocol. All visitors to execute the PEAD addendum. Compass Shown Property COVID-19 Plan: https://drive.google.com/file/d/1KOevjT-8R-lvBdn79akm1p0DMhBIHvrY/view. 1,500 sqft per graphic artist.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Freestanding Range;Hood Over Range
bath_features__c, Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Todd Montgomery
pba__contingentdate__c, 2020-12-18
ffd_createddate, 2020-09-24T20:46:31.000+0000
days_on_market__c, 1028
dom__c, 111
ffd_description_pb, This marvelous, full floor 3 BD, 1.5 BA home offers a classic, grand-scale floor-plan with excellent separation of space in an amazing central Hayes Valley location. 518 Page Street features a quintessential SF flat layout with wonderful light, high ceilings, charming traditional details (original hardwood flooring, large bay windows, fireplaces) and a fully renovated chef-grade kitchen with quartz counters, new stainless steel appliances, and more. Ideal for entertaining but also living, working, and teaching from home with three large enclosed bedrooms. Page Street's central location in Hayes Valley offers an array of retail and fun boutiques, a diverse selection of the city's top restaurants, and a lively cultural scene (jazz, opera, theater, symphony). Close to public transportation, Muni/BART, and freeways.
district__c, SF District 6
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floor__c, 0
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 396.38
pba__hoafees__c, 396
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:35:32.000+0000
pba__latitude_pb__c, 37.773207333
pba__latitude_property__c, 37.773207333
listed_date__c, 2020-09-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Marcus
pba__listing_agent_lastname__c, Lee
listing_agent_mls_id__c, 804756
ffd_listingagentname, Marcus A Lee
listing_agent_number__c, 166014430
listing_co_agent_mls_id__c, 807753
listing_co_agent_number__c, 1025356
listing_co_office_mls_id__c, COMP47
listing_co_office_name__c, Compass
listing_co_office_number__c, 28243
listing_office_mls_id__c, COMP47
listing_office_name__c, Compass
listing_office_number__c, 28243
pba__listingprice_pb__c, 1295000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.518page.com
pba__longitude_pb__c, -122.42936116
pba__lotsize_pb__c, 0
mls_id__c, 506076
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000004VWn4UAG
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-24
original_price__c, 1295000
overall_days_on_market__c, 188
parking_access__c, Tandem
parking_features__c, Attached,Tandem Garage,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-01-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 833.33
pba__propertytype__c, Tenancy In Common
id, a0E1I00000THo6YUAT
room_type__c, Storage
sale_date__c, 2021-01-25
sale_price__c, 1250000
selling_agent_mls_id__c, 813548
selling_agent_number__c, 1062097
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Redfin
pba__status__c, Closed
pba__totalarea_pb__c, 1500
size__c, 1500
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Page
subdist__c, Hayes Valley
ffd_name, 518 Page Street, San Francisco, CA, 94117
transportation__c, 2 Blocks
website_property_type__c, Tenancy In Common
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/370958-1.jpg
ListingId, a0E1I00000THo6YUAT