meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217291' 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, 818 Steiner Street, San Francisco, CA, 94117
ffd_mls_id, 421522066
ffd_salesforce_id, a0E1I00000Tw3vLUAR
num_of_fireplaces__c, 3
num_of_rooms__c, 0
of_units__c, 0
address2__c, 818 Steiner Street, San Francisco, CA, 94117
pba__address_pb__c, 818 Steiner Street, San Francisco, CA, 94117
agent_only_remarks__c, Shown By Appointment Only. Please call Mollie Poe directly to schedule a showing. www.818Steiner.com for more info.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Built-In Electric Oven
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over;Tub;Tile;Double Sinks;Stone
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 7
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Declan J Hickey
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-02-24T18:58:21.000+0000
days_on_market__c, 875
dom__c, 5
ffd_description_pb, Built for the Hartter Family in 1899, this revitalized Queen Anne is one of the finest, most historically significant homes surrounding Alamo Square Park. Statelier than a typical painted lady in size & grandeur, it also offers a full-scale renovation to suit today's living. Stunning views of the Park's greenery paired w/ striking panoramic Dwntwn views from all 4 lvls. Original woodwork, a deep lot perfect for entertaining & a garage for 4 -6 cars help make this a quintessential SF place to call home. The main floor offers an inviting living room, a remodeled kitchen w/Carrera marble counters, casual dining area & white oak plank flooring. A walk-out deck w/glass railings flows onto the home's stunning landscaped backyard.Upstairs you'll find 4 full-sized bdrms & 2 full baths, including a luxurious master suite. Light floods in through skylights @ the attic level; a perfect media room/play space. You'll find an art room, an add'l bonus room + lrg office w/panoramic City views.
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Gas Piped
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:45:39.000+0000
pba__latitude_pb__c, 37.777173
pba__latitude_property__c, 37.777173
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2021-02-01
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, COMP3
listing_co_office_name__c, Compass
listing_co_office_number__c, 27342
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 7250000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=3DhP6TkhWak
pba__longitude_pb__c, -122.4328868
lower_level__c, Bedroom(s),Family Room
mls_id__c, 421522066
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Shower Stall(s);Double Sinks;Tile;Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 4
on_market_date__c, 2021-02-24
original_price__c, 7250000
overall_days_on_market__c, 157
parking_access__c, Independent
parking_features__c, Covered,Enclosed,Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-03-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1214.44
pba__propertytype__c, Single Family Residence
id, a0E1I00000Tw3vLUAR
room_type__c, Office;Kitchen;Living Room;Master Bathroom;Game Room;Dining Room;Attic;Family Room;Master Bedroom;Wine Storage Area
sale_date__c, 2021-03-26
sale_price__c, 7300000
selling_agent_mls_id__c, 808802
selling_agent_number__c, 1037619
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 6011
size__c, 6011
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Steiner
subdist__c, Alamo Square
ffd_name, 818 Steiner Street, San Francisco, CA, 94117
view__c, City;Park;City Lights;Garden/Greenbelt;Downtown;San Francisco
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530187949-1.jpg
ListingId, a0E1I00000Tw3vLUAR