meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='384476' 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
(
)
)
_yoast_indexnow_last_ping, 1724151480
ffd_listing_title, 461 Oak Street #2, San Francisco, CA, 94102
ffd_mls_id, 424043077
ffd_salesforce_id, a0EUd000002RBXlMAO
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 3
address2__c, 461 Oak Street #2, San Francisco, CA, 94102
pba__address_pb__c, 461 Oak Street #2, San Francisco, CA, 94102
agent_only_remarks__c, Sirkin TIC agreement is in place, this will be a newly formed TIC. HOA dues include approximate water, garbage, insurance & common area bi-monthly cleaning. Pre- sale escrow opened w/ Paula Siegel at Fidelity National Title, (no relation). Square footage by appraiser 1052 sq. feet, by graphic artist 990 sq ft. Buyer's to do their own due diligence. Contact Claudia for disclosures and private showings other than posted times. Pls use SF purchase agreement, can furnish if needed.Buyers to cooperate with Sellers 1031 exchange at no cost to buyer. Looking for potential back up offers.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Tankless Water Heater;Built-In Gas Oven;Ice Maker
architectural_style__c, Victorian
bath_features__c, Shower Stall(s);Tile;Low-Flow Toilet(s);Dual Flush Toilet;Low-Flow Shower(s);Quartz;Window;Stone
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-07-23
cooling__c, Ceiling Fan(s),Wall Unit(s)
ffd_createddate, 2024-06-28T10:49:18.000+0000
days_on_market__c, 53
dom__c, 36
ffd_description_pb, Absolutely beautiful 3 bedroom 1.5-bathroom flat in the heart of Hayes Valley! Situated in an impeccably maintained building, this residence boasts high ceilings, exquisite stained glass windows, and bay windows offering unexpected downtown views. The triple-paned windows ensure a serene and quiet living environment. Relish the newly remodeled kitchen, featuring Caesarstone countertops and stylish subway tile, perfect for culinary enthusiasts and dinner parties. The updated bathroom showcases elegant subway tile and double showerheads, adding a touch of luxury to your daily routine. Conveniently plumbed for an in-unit washer and dryer, laundry day is a breeze. Entire building had a seismic retrofit in 2013. This unit includes a huge exclusive-use storage room (272 square feet!), and a fabulous shared bike room, catering to all your storage needs. The location is unbeatable, just steps away from Hayes Valley's vibrant shopping scene, world-class dining, and a plethora of cultural options. Enjoy nearby Alamo Square Park, Golden Gate Park, and the famous Wiggle bike route. Transit Score of 100, Bike and Walk Score 99, commuting is a breeze. Experience the perfect blend of historic charm and modern convenience. A great value and a must-see to believe!
district__c, SF District 6
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Bamboo;Tile
hoa_fee_includes__c, Common Areas,Homeowners Insurance,Insurance,Maintenance Grounds,Property Tax,Trash,Water
pba__hoafees__c, 535
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 461 Oak St. Homeowners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Electric;Wall Furnace
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2024-08-20T10:49:46.000+0000
pba__latitude_pb__c, 37.7743092
pba__latitude_property__c, 37.7743092
laundry_features__c, Inside Room;Laundry Closet;Hookups Only;Other;Gas Hook-Up
listed_date__c, 2024-06-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Claudia
pba__listing_agent_lastname__c, Siegel
listing_agent_mls_id__c, 804416
ffd_listingagentname, Claudia L Siegel
listing_agent_number__c, 166013962
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 949000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/969999972
pba__longitude_pb__c, -122.426869
mls_id__c, 424043077
main_level__c, Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Quartz;Tile;Window;Stone;Multiple Shower Heads
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-06-28
original_price__c, 949000
overall_days_on_market__c, -81993
pba__pendingdate__c, 2024-08-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-08-19T18:37:49.000+0000
price_per_square_foot__c, 855.51
pba__propertytype__c, Tenancy In Common
ListingId, a0EUd000002RBXlMAO
road_surface_type__c, Paved
roof__c, Bitumen;Shingle
room_type__c, Laundry;Kitchen;Living Room;Possible Guest
sale_date__c, 2024-08-19
sale_price__c, 900000
security_features__c, Smoke Detector;Fire Alarm;Double Strapped Water Heater
selling_agent_mls_id__c, 816926
selling_agent_number__c, 1075857
selling_co_agent_mls_id__c, 818061
selling_co_agent_number__c, 1076856
selling_co_office_mls_id__c, COMP49
selling_co_office_name__c, Compass
selling_co_office_number__c, 28585
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1052
size__c, 1052
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Oak
subdist__c, Hayes Valley
ffd_name, 461 Oak Street #2, San Francisco, CA, 94102
view__c, City Lights;Downtown
website_property_type__c, Tenancy In Common
window_features__c, Dual Pane Full;Window Coverings;Bay Window(s);Weather Stripped;Triple Pane Partial
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/530801244-1.jpg