meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217915' 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, 388 Fulton Street #508, San Francisco, CA, 94102
ffd_mls_id, 421526433
ffd_salesforce_id, a0E1I00000TxGN0UAN
num_of_fireplaces__c, 0
num_of_rooms__c, 2
of_units__c, 69
address2__c, 388 Fulton Street #508, San Francisco, CA, 94102
pba__address_pb__c, 388 Fulton Street #508, San Francisco, CA, 94102
agent_only_remarks__c, Please DO NOT text or use Showingtime for showings. Showing instructions can be found here https://calendly.com/388fulton508/388-fulton-st-508-showings. Please send your PEAD to [email protected] prior to your showing. Please review disclosures in advance: https://app.disclosures.io/link/388-Fulton-Street-508-188znf3r. All COVID documents, as well as our detailed showing instructions, are available in the disclosure packet. Escrow is opened with [email protected]. All buyers to use the most current 7-page SFAR contract. If needed, one will be provided. This is NOT a BMR-- *All info herein is not guaranteed. Prospective purchasers are advised to independently verify accuracy and to review any disclosure information before submitting offers.*
appliances__c, Disposal;Hood Over Range;Built-In Refrigerator;Built-In Electric Range
architectural_style__c, Modern/High Tech
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 2016
pba__city_pb__c, San Francisco
listing_co_agent_name__c, yesenia Rogers
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-03-26T12:40:02.000+0000
days_on_market__c, 846
dom__c, 9
ffd_description_pb, Hayes Valley is the pulsing heart of elevated city living. A luxury 6-story building, 388 Fulton fits right in while standing out with a unique black tile exterior by David Baker Architects and designer interiors by Charles de Lisle. This spacious studio's sleek interior shines with wide plank European Oak flooring, Caesarstone counters, and integrated Bosch and Bertazzoni appliances. West-facing floor-to-ceiling windows offer an abundance of natural light. Come golden hour, a dreamy glow saturates the interior; you'll soon find yourself adding basking'' to your ever-growing list of pandemic hobbies. Building amenities include cyber entry, panoramic rooftop terrace, BBQ, fire pit outdoor screening area, lush courtyard, styled work lounge, bike workstation and storage, automated trash chutes on each floor that separate trash, recycling, and compost. In-unit Bosch washer/dryer in laundry closet.
district__c, SF District 6
driveway_sidewalks__c, Gated,Paved Sidewalk
electric__c, 220 Volts
entry_level__c, 0
exterior_features__c, Uncovered Courtyard;Entry Gate
external_listing__c, 1
fencing__c, Fenced;Metal
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas,Insurance on Structure,Maintenance Grounds,Management,Trash,Water,Other
pba__hoafees__c, 498
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Baseboard
ffd_lastmodifieddate, 2022-01-25T15:48:13.000+0000
pba__latitude_pb__c, 37.779041
pba__latitude_property__c, 37.779041
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2021-03-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ruth
pba__listing_agent_lastname__c, Krishnan
listing_agent_mls_id__c, 400593
ffd_listingagentname, Ruth Krishnan
listing_agent_number__c, 1019790
listing_co_agent_mls_id__c, 813900
listing_co_agent_number__c, 1063314
listing_co_office_mls_id__c, COMP7PAR
listing_co_office_name__c, Compass SF
listing_co_office_number__c, 27677
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 499000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=JMyJTztq89N
pba__longitude_pb__c, -122.42311
mls_id__c, 421526433
master_property__c, a0O1I000001VhwPUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-03-25
original_price__c, 499000
overall_days_on_market__c, 232
parking_features__c, Other
pba__pendingdate__c, 2021-04-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1254.9
pba__propertytype__c, Condominium
id, a0E1I00000TxGN0UAN
road_surface_type__c, Paved
roof__c, Other
room_type__c, Studio
sale_date__c, 2021-04-14
sale_price__c, 640000
security_features__c, Security Gate;Fire Alarm;Carbon Mon Detector
selling_agent_mls_id__c, 981493
selling_agent_number__c, 981493
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 510
size__c, 510
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fulton
subdist__c, Hayes Valley
ffd_name, 388 Fulton Street #508, San Francisco, CA, 94102
view__c, City;Downtown;San Francisco;Hills;Sutro Tower
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Window Coverings
pba__yearbuilt_pb__c, 2016
pba__postalcode_pb__c, 94102
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530206674-1.jpg
ListingId, a0E1I00000TxGN0UAN