meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='380762' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15731
[post_author] => 4
[post_date] => 2018-11-02 19:54:56
[post_date_gmt] => 2018-11-02 19:54:56
[post_content] => The site of perhaps the most photographed vista in San Francisco, Alamo Square is home to the world-famous Painted Ladies. The row of iconic Victorian homes, with the city skyline as the backdrop, provides a picture-perfect postcard view of San Francisco.
Equally famous in movies is Alamo Square Park; on a hilltop overlooking the Painted Ladies, locals and tourists frequent the green space, playgrounds, walking trails, dog park, and tennis courts.
Architecture in Alamo Square is predominately Victorian and has the distinct honor of being the location of numerous homes exceeding 10,000 square feet of living space.
[post_title] => Alamo Square
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => alamo-square
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 08:50:23
[post_modified_gmt] => 2024-04-09 15:50:23
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15731
[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, 1718456223
ffd_listing_title, 877 Hayes Street, San Francisco, CA, 94117
ffd_mls_id, 424031706
ffd_salesforce_id, a0EUd000001zA0LMAU
num_of_fireplaces__c, 0
num_of_rooms__c, 10
of_units__c, 0
address2__c, 877 Hayes Street, San Francisco, CA, 94117
pba__address_pb__c, 877 Hayes Street, San Francisco, CA, 94117
agent_only_remarks__c, Down to the studs full remodel! Offer Date is Tuesday, May 21 at 2pm. However, seller will consider strong pre-emptive offers. Leased parking spot located at 780 Hayes St. small / medium sized car. Neighbor on Fillmore St is currently repairing retaining wall at rear of yard. Completion expected within a few weeks.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Tankless Water Heater;Built-In Gas Oven;Free Standing Refrigerator;Wine Refrigerator;Gas Cook Top
architectural_style__c, Victorian
bath_features__c, Dual Flush Toilet
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-05-21
cooling__c, Central
ffd_createddate, 2024-05-10T14:46:59.000+0000
days_on_market__c, 36
dom__c, 12
ffd_description_pb, Hot! Hot! Location! Like new Victorian Home + in-law unit perfectly positioned between Alamo Square & Hayes Valley. Fully updated 4 bed, 4.5 bath home, melds chic design with modern amenities while retaining original craftsmanship of this gorgeous home. Main floor: entry foyer opens into the grand double parlor featuring high ceilings, gorgeous bay windows, original crown molding and Victorian detailing. Open concept chef's kitchen features Thermador appliance suite, wine fridge, quartz countertops and fun kitchen island. The dining area seamlessly opens to a sunny patio and HUGE south-facing backyard with shade tree, perfect lawn, & space to plant a vegetable garden. 3 bedrooms upstairs, 2 with ensuite baths & walk-in closets, plus additional bathroom. On the ground level with a separate entrance: 1 Bed, 1 Bath in-law unit. Perfect for home office, yoga studio, guests, media room or extra income. Ethernet, new HVAC, plumbing & electric, double-paned windows, Ring doorbell. Laundry room and powder room, too. Leased parking block away, pre-paid for a full year. WalkScore of 100! Just 1 block to Alamo Square, and 3 blocks to Hayes Valley shops, dining and entertainment. Moments to all the amenities of Divisadero Corridor, Muni & Octavia Blvd for easy commute. Don't Miss!
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Skylight(s)
ffd_lastmodifieddate, 2024-06-15T12:47:16.000+0000
pba__latitude_pb__c, 37.7757014
pba__latitude_property__c, 37.7757014
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2024-05-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lisa
pba__listing_agent_lastname__c, Zahner
listing_agent_mls_id__c, 813762
ffd_listingagentname, Lisa Zahner
listing_agent_number__c, 1062990
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CITYRE
listing_office_name__c, City Real Estate
listing_office_number__c, 27425
pba__listingprice_pb__c, 2500000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=nDTBG8nLWnJ&mls=1
pba__longitude_pb__c, -122.4306937
mls_id__c, 424031706
master_bathroom_features__c, Double Sinks;Dual Flush Toilet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-05-10
original_price__c, 2500000
overall_days_on_market__c, -81944
parking_access__c, Independent
parking_features__c, Assigned,Garage Door Opener
parking_type__c, Other
pba__pendingdate__c, 2024-05-22
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-06-14T23:18:41.000+0000
price_per_square_foot__c, 909.09
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001zA0LMAU
room_type__c, Kitchen;In Law Apartment;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom 2+
sale_date__c, 2024-06-14
sale_price__c, 3000000
selling_agent_mls_id__c, 811731
selling_agent_number__c, 1053350
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, 3300
size__c, 3300
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Hayes
subdist__c, Alamo Square
ffd_name, 877 Hayes Street, San Francisco, CA, 94117
view__c, City
website_property_type__c, Single Family Home
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/530775861-1.jpg