meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='324065' 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.
[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] => 2018-11-02 19:54:56
[post_modified_gmt] => 2018-11-02 19:54:56
[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 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 0
dom__c 0
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-01-28T02:45:55.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 silvia@teambrannigan.com
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 1850000
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
open_house_end__c 2023-01-28T16:00:00.000+0000
open_house_start__c 2023-01-28T14:00:00.000+0000
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 1800-01-01
possible_bedrooms__c 0
pba__pricechangedat__c 1800-01-01T00:00:00.000+0000
price_per_square_foot__c 908.64
pba__propertytype__c Condominium
ListingId a0E8W00000a87DpUAI
roof__c Bitumen
room_type__c Kitchen;Living Room;Dining Room
sale_date__c 1800-01-01
sale_price__c 0
selling_agent_number__c 0
selling_co_agent_number__c 0
selling_co_office_number__c 0
pba__status__c Active
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