meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329210' 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, 847 Hayes Street, San Francisco, CA, 94117
ffd_mls_id, 423718173
ffd_salesforce_id, a0E8W00000a87DpUAI
num_of_fireplaces__c, 3
num_of_rooms__c, 7
of_units__c, 3
address2__c, 847 Hayes Street, San Francisco, CA, 94117
pba__address_pb__c, 847 Hayes Street, San Francisco, CA, 94117
agent_only_remarks__c, 100k price adjustment! Motivated Seller. Schedule a time to view the property: https://calendly.com/silvia-tb/847hayes Disclosure package is available upon request. Please call/text Silvia at 415-335-3975 with questions or showing requests. Visit https://847hayes.com for more virtual media. Condo converted in 2008, large structural beam installed and brick foundation was reinforced at that time. Chase Bank said they will loan on it.
appliances__c, Dishwasher;Microwave;Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, Victorian
bath_features__c, Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-01-28T02:45:55.000+0000
days_on_market__c, 173
dom__c, 52
ffd_description_pb, Classy and elegant, this 4BD/2.5BA TOP FLOOR condo unit is bursting with rich history, timeless Victorian details, and sparkling VIEWS of Downtown! The WOW-FACTOR of this unit is unparalleled, enhanced by its vibrant and central Alamo Square location. The grand scale rooms, bright natural light, and striking 11ft ceilings inspire countless hours of pure enjoyment & fond memories with friends & family. As you meander through the unit's 2,100+ sqft of space, you'll relish in the Victorian architecture: stately double parlor doors, decorative fireplaces, graceful curved walls & era-specific moulding. The expansive, exclusive-use deck overlooks the shared yard on an oversized lot & perfectly complements the flexible & functional flrpln. In-unit W/D, storage, shared yard & the best pkg space in the building come with this unit. Endless entertainment surrounds - 95 Walk & 98 Transit Scores! You're 1.5 blocks to Alamo Square Park & the famed Painted Ladies, & 4 blocks to numerous dining, shopping, & cafes on Divisadero, Haight, Hayes Valley corridors! Available for the first time on market in 30 yrs, this unit exudes pride of ownership w/ thoughtful updates made in the last 10 yrs which keep in the same endearing Victorian style. Make this living treasure your own for years to come!
district__c, SF District 6
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Decorative Only
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Insurance,Maintenance Grounds,Management,Sewer,Trash,Water
pba__hoafees__c, 500
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 847-849-851 Hayes Street
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T18:20:12.000+0000
pba__latitude_pb__c, 37.775661
pba__latitude_property__c, 37.775661
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2022-06-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Silvia
pba__listing_agent_lastname__c, Zeng
listing_agent_mls_id__c, 812389
ffd_listingagentname, Silvia Zeng
listing_agent_number__c, 1056371
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 1750000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.847hayes.com/
pba__longitude_pb__c, -122.430307
mls_id__c, 423718173
master_property__c, a0O8W00000FsIXGUA3
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-01-27
original_price__c, 1850000
overall_days_on_market__c, -81475
parking_access__c, Side by Side
parking_features__c, Enclosed,Garage Facing Front
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Covered Deck
pba__pendingdate__c, 2023-03-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 785.85
pba__propertytype__c, Condominium
ListingId, a0E8W00000a87DpUAI
roof__c, Bitumen
room_type__c, Kitchen;Living Room;Dining Room
sale_date__c, 2023-03-31
sale_price__c, 1600000
selling_agent_mls_id__c, 804728
selling_agent_number__c, 166014390
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2036
size__c, 2036
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Hayes
subdist__c, Alamo Square
ffd_name, 847 Hayes Street, San Francisco, CA, 94117
view__c, Downtown
website_property_type__c, Condominium
window_features__c, Bay Window(s)
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/530573616-1.jpg
