meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219071' 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
(
)
)
ffd_listing_title, 857 Fell Street, San Francisco, CA, 94117
ffd_mls_id, 421554244
ffd_salesforce_id, a0E1I00000UTVxnUAH
num_of_fireplaces__c, 2
num_of_rooms__c, 0
of_units__c, 3
address2__c, 857 Fell Street, San Francisco, CA, 94117
pba__address_pb__c, 857 Fell Street, San Francisco, CA, 94117
agent_only_remarks__c, Good news! Seller is going to credit $9900 toward HOA quarterly payments! 1. Property is vacant and may be shown per COVID19 regulations. (2. Please sign up directly for an appointment through: https://calendly.com/mollie-poe-properties/private-showing-at-857-fell-st (3. Please send PEAD to [email protected] prior to showing (4. You can review disclosures @ https://app.disclosures.io/link/857-Fell-Street-zriwxpma (5. Escrow Officer: Amy Edberg ([email protected], 415-796-6114) (6. All COVID precautions to be strictly followed - visitors to supply own Personal Protective Equipment. The HOA has a special assessment of $1650/quarter in order to increase reserves. www.857Fell.com Yard is deeded to lower level. HOA Dues are paid quarterly. A second fee was established @ $1650/quarter to fund the reserves. There is a combo igloo lockbox attached to the building at the front door of unit. The code is 1969.
appliances__c, Dishwasher;Microwave;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Wine Refrigerator
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1917
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Declan J Hickey
pba__contingentdate__c, 2021-06-09
ffd_createddate, 2021-05-21T10:49:46.000+0000
days_on_market__c, 789
dom__c, 24
ffd_description_pb, A recent update reveals all of the charm you would hope to find in a beautiful Alamo Square/ Hayes Valley Edwardian condo. Flooded with natural light and beaming with blue sky views, the open floor plan is an entertainer's dream. With 1751 square feet, 3 full-sized bedrooms and 2 full bathrooms plus an open-plan kitchen / dining / living room, there is plenty of room to unwind. A spacious bedroom cleverly located in the rear of the condo has room for a home office area. An additional living room located in the front of the unit features dual-paned street-facing windows, and the ultimate flexible floor plan. A walker and commuters paradise, you'll thrive in Alamo Square 1 block away, Hayes Valley, Duboce Park, and Divisadero Corridor's wildly popular restaurants and hotspots, and love easy access to freeways, public transportation and more!
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Electric
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Insurance,Sewer,Water,Other
pba__hoafees__c, 300
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 855-857-859 Fell St HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:53:12.000+0000
pba__latitude_pb__c, 37.774505
pba__latitude_property__c, 37.774505
laundry_features__c, Washer/Dryer Stacked Included;Inside Area
listed_date__c, 2021-05-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mollie
pba__listing_agent_lastname__c, Poe
listing_agent_mls_id__c, 802851
ffd_listingagentname, Mollie W Poe
listing_agent_number__c, 802851
listing_co_agent_mls_id__c, 808252
listing_co_agent_number__c, 1032461
listing_co_office_mls_id__c, INDIGO
listing_co_office_name__c, Indigo Real Estate
listing_co_office_number__c, 28648
listing_office_mls_id__c, INDIGO
listing_office_name__c, Indigo Real Estate
listing_office_number__c, 28648
pba__listingprice_pb__c, 1299000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.857Fell.com
pba__longitude_pb__c, -122.431884
mls_id__c, 421554244
master_bathroom_features__c, Shower Stall(s)
master_property__c, a0O1I00000C6rtOUAR
monthly_parking_fees__c, 350
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-05-21
original_price__c, 1299000
overall_days_on_market__c, 65
parking_access__c, Independent
parking_features__c, No Garage
parking_type__c, On Site - Lease Available (Condo Only)
pba__pendingdate__c, 2021-06-14
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 727.64
pba__propertytype__c, Condominium
id, a0E1I00000UTVxnUAH
room_type__c, Kitchen;Living Room
sale_date__c, 2021-07-22
sale_price__c, 1274100
selling_agent_mls_id__c, A335454
selling_agent_number__c, 981092052
selling_co_agent_mls_id__c, A338171
selling_co_agent_number__c, 981092854
selling_co_office_mls_id__c, 7B2189
selling_co_office_name__c, Outpost Real Estate
selling_co_office_number__c, 981085432
selling_office_name__c, Outpost Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1751
size__c, 1751
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fell
subdist__c, Alamo Square
ffd_name, 857 Fell Street, San Francisco, CA, 94117
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1917
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530246736-1.jpg
ListingId, a0E1I00000UTVxnUAH