meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235502' 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, 508 Oak Street, San Francisco, CA, 94102
ffd_mls_id, 422643554
ffd_salesforce_id, a0E8W00000VvxOWUAZ
num_of_fireplaces__c, 2
num_of_rooms__c, 5
of_units__c, 3
address2__c, 508 Oak Street, San Francisco, CA, 94102
pba__address_pb__c, 508 Oak Street, San Francisco, CA, 94102
agent_only_remarks__c, Contact my team member, Hollis Bathen, for all showings and questions at 415-816-7227 or [email protected]. Disclosures are available here: https://app.disclosures.io/link/508-Oak-Street-ni7jzutq . Garage is on Hickory Street so very easy parking plus parking in driveway (see CCRs for details). Only room on Oak Street is the living room - bedrooms are quiet. Laundry for this unit is off the garage and is not shared with other units. Roof deck is shared.
appliances__c, Dishwasher;Microwave;Disposal;Built-In Gas Range;Built-In Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-03-31T00:47:14.000+0000
days_on_market__c, 476
dom__c, 8
ffd_description_pb, Welcome home to this romantic and re-imagined Victorian flat located in the hippest artistic district of SF, Hayes Valley. This airy condominium was recently updated with thoughtful modernity all while maintaining the elegant details of the period including charming wood wainscot, picture rails, soaring ceilings and bay windows. Enter the home into the open living room with floor-to-ceiling cabinets, gorgeous molding and original fireplace. Through the chic parlor doors enter the 1st of 2 BRs. Off BR #1 is the recently added full bathroom. The rear of the home boasts the primary BR w/ full bathroom and is adjacent up to the elegant living/dining room and expanded chef's kitchen. The modern eat-in kitchen features top-of-the line appliances & custom cabinets plus an office nook and lovely private deck. This exquisite home is crowned by a spectacular roof terrace w/ city views including the majestic City Hall and Salesforce Tower. 1+ parking in rear garage, tons of storage and laundry.
district__c, SF District 6
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Decorative Only
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Trash,Water
pba__hoafees__c, 45
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 508-510 Oak Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-04-27T01:48:25.000+0000
pba__latitude_pb__c, 37.7743366303055
pba__latitude_property__c, 37.7743366303055
laundry_features__c, In Basement
listed_date__c, 2022-03-30
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mary Lou
pba__listing_agent_lastname__c, Castellanos
listing_agent_mls_id__c, 301994
ffd_listingagentname, Mary Castellanos
listing_agent_number__c, 301994
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.428296025829
mls_id__c, 422643554
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room;Family Room;Street Entrance
master_bathroom_features__c, Tub w/Shower Over
master_property__c, a0O1I00000AOcW0UAL
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-03-30
original_price__c, 1395000
overall_days_on_market__c, -81172
parking_access__c, Independent
parking_features__c, Alley Access,Garage Door Opener,Garage Facing Rear,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2022-04-07
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-04-26T11:49:08.000+0000
price_per_square_foot__c, 1223.98
pba__propertytype__c, Condominium
id, a0E8W00000VvxOWUAZ
sale_date__c, 2022-04-25
sale_price__c, 1470000
selling_agent_mls_id__c, 806491
selling_agent_number__c, 166017065
selling_co_agent_mls_id__c, 802363
selling_co_agent_number__c, 802363
selling_co_office_mls_id__c, PACEDGE
selling_co_office_name__c, Pacific Edge
selling_co_office_number__c, 28507
selling_office_name__c, Pacific Edge
pba__status__c, Closed
pba__totalarea_pb__c, 1201
size__c, 1201
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Oak
subdist__c, Hayes Valley
ffd_name, 508 Oak Street, San Francisco, CA, 94102
view__c, City;Downtown
website_property_type__c, Condominium
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94102
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530428363-1.jpg
ListingId, a0E8W00000VvxOWUAZ