meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217731' 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, 882 Grove Street, San Francisco, CA, 94117
ffd_mls_id, 421529692
ffd_salesforce_id, a0E1I00000Tx5JBUAZ
num_of_fireplaces__c, 5
num_of_rooms__c, 14
of_units__c, 0
address2__c, 882 Grove Street, San Francisco, CA, 94117
pba__address_pb__c, 882 Grove Street, San Francisco, CA, 94117
agent_only_remarks__c, Please contact Mimi Sparrow by phone/text 415.728.4219 for a showing appointment. Secondary contact: Bonnie Spindler: 415.706.6660. Send PEAD to [email protected] Offers if any are due Tuesday, April 6, 2021, at 2 PM. No preemptives, please. Property website: https://www.882GroveSt.com/mls. This is a trust sale with no court confirmation. The owner did not die in the building. Sale is As Is.
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over;Shower Stall(s);Split Bath;Marble;Tile
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 8
year_build_text__c, 1893
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-03-23T12:44:20.000+0000
days_on_market__c, 576
dom__c, 15
ffd_description_pb, Constucted in 1893 as a custom build by Hugh Keenan, a promenent Victorian contractor. Very original Queen Anne with corner turret. This home is desinged for entertaining/multi-generational use. Grand foyer and a triple parlor leads to the kitchen with butler's pantry. Elabaorate Bradbury & Bradbury wallpapers, stunning Gas-o-lier bronze light fixtures with Vasoline glass shades, plaster medallions and brackets embellish this floor. Oak fretwork arch and winding three story banister and newel posts grace the entry way leading the eye up to higher floors. The main bedroom has a fireplace, south facing double paned windows, and pond scene wallpaper. The original bathroom has oak surround claw foot tub, hex tile floor and wallpaper with dragonflies, birds, cat tails and cranes. There are 4 bedrooms on this floor. One massive child's/nanny room on the top floor. Panoramic views of downtown from 3rd Fl. Skylit inaccessible attic above 3rd floor. Brick yd, 2 Bed apt, W/D.
district__c, SF District 6
driveway_sidewalks__c, Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Wood Burning;Decorative Only;Brick;Wood Stove
pba__floortype_pb__c, Carpet;Linoleum;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 4
pba__heatingtype_pb__c, Central;Gas;See Remarks;Wood Stove
interior_features__c, Formal Entry;Skylight(s)
ffd_lastmodifieddate, 2022-01-25T15:47:26.000+0000
pba__latitude_pb__c, 37.776996
pba__latitude_property__c, 37.776996
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2021-02-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Bonnie
pba__listing_agent_lastname__c, Spindler
listing_agent_mls_id__c, 389338
ffd_listingagentname, Bonnie K Spindler
listing_agent_number__c, 389338
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CGL
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28240
pba__listingprice_pb__c, 2499000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/528213425
pba__longitude_pb__c, -122.43111
lower_level__c, Bedroom(s),Full Bath(s),Kitchen,Living Room,Street Entrance
mls_id__c, 421529692
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-03-23
original_price__c, 2499000
overall_days_on_market__c, 161
parking_features__c, No Garage
pba__pendingdate__c, 2021-04-07
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 660.33
pba__propertytype__c, Single Family Residence
id, a0E1I00000Tx5JBUAZ
room_type__c, Bonus Room;Kitchen;In Law Apartment;Master Bedrooms 2+;Living Room;Dining Room;Attic
sale_date__c, 2021-04-30
sale_price__c, 2500000
selling_agent_mls_id__c, 802876
selling_agent_number__c, 802876
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Jackson Fuller Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 3786
size__c, 3786
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Grove
subdist__c, Alamo Square
ffd_name, 882 Grove Street, San Francisco, CA, 94117
view__c, City;Downtown;San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1893
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530202122-1.jpg
ListingId, a0E1I00000Tx5JBUAZ