meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319444' 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-11-07 09:28:38
[post_modified_gmt] => 2024-11-07 17:28:38
[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, 809 Fell Street, San Francisco, CA, 94117
ffd_mls_id, 422706328
ffd_salesforce_id, a0E8W00000ZMbyxUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 4
of_units__c, 2
address2__c, 809 Fell Street, San Francisco, CA, 94117
pba__address_pb__c, 809 Fell Street, San Francisco, CA, 94117
agent_only_remarks__c, Please use the 7 page SFAR purchase contract. For more info, please visit www.809Fell.com
appliances__c, Dishwasher;Microwave;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1905
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Declan J Hickey
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-11-04T19:46:41.000+0000
days_on_market__c, 788
dom__c, 8
ffd_description_pb, Ultimate Urban Living in this Hayes Valley Victorian. Swing your French doors open and take in the sunshine in this charming Victorian condo, flush with beautiful details such as stunning box beam trimmed ceilings. Historical in nature, yet modified to open up its double-parlor to a large exclusive-use walk-out deck, and common-use patio with hot tub. The bedroom and living room are spacious enough to set up your home office. Although this is a location fit for foodies; just two blocks from Hayes Valley restaurants, 2 blocks from Alamo square, and 4 blocks from Divisadero's hotspots, this condo's kitchen features an eat-in opportunity for time when you're retreating from the hustle and bustle of neighborhood gems. Garage parking is side-by-side for 1-car, where you'll find your washer/dryer conveniently located amongst a vast storage area. With an established HOA of only 2 condos, this property is plug-and-play for any discerning buyer!
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Decorative Only
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Insurance on Structure,Sewer,Trash,Water
pba__hoafees__c, 399
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Electric;Wall Furnace
ffd_lastmodifieddate, 2023-07-13T18:05:13.000+0000
pba__latitude_pb__c, 37.774691
pba__latitude_property__c, 37.774691
laundry_features__c, In Garage
listed_date__c, 2022-09-25
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, 949000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.809Fell.com
pba__longitude_pb__c, -122.431221
mls_id__c, 422706328
main_level__c, Bedroom(s);Family Room
master_bathroom_features__c, Tub w/Shower Over
master_property__c, a0O8W00000FsgUcUAJ
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-11-04
original_price__c, 949000
overall_days_on_market__c, -81391
parking_access__c, Side by Side
parking_features__c, Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2022-11-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1125.3
pba__propertytype__c, Condominium
ListingId, a0E8W00000ZMbyxUAD
sale_date__c, 2022-11-18
sale_price__c, 925000
selling_agent_mls_id__c, 802851
selling_agent_number__c, 802851
selling_co_agent_mls_id__c, 808252
selling_co_agent_number__c, 1032461
selling_co_office_mls_id__c, INDIGO
selling_co_office_name__c, Indigo Real Estate
selling_co_office_number__c, 28648
selling_office_name__c, Indigo Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 822
size__c, 822
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fell
subdist__c, Alamo Square
ffd_name, 809 Fell Street, San Francisco, CA, 94117
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1905
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530551104-1.jpg
_yoast_indexnow_last_ping, 1735678737