meta_query='key:subdist__c;value:Anza Vista|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237533' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15730
[post_author] => 4
[post_date] => 2018-11-02 19:54:54
[post_date_gmt] => 2018-11-02 19:54:54
[post_content] => Formerly a burial ground. If that's a deal breaker, cross it off quick cause there's nothing we can do to change that. Otherwise an oasis of mostly single-family homes with some surprising views in a central location that's become surprisingly walkable.
[post_title] => Anza Vista
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => anza-vista
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 08:54:34
[post_modified_gmt] => 2024-04-09 15:54:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15730
[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, 1880 Turk Boulevard, San Francisco, CA, 94115
ffd_mls_id, 422626477
ffd_salesforce_id, a0E8W00000Vt126UAB
num_of_fireplaces__c, 5
num_of_rooms__c, 0
of_units__c, 0
address2__c, 1880 Turk Boulevard, San Francisco, CA, 94115
pba__address_pb__c, 1880 Turk Boulevard, San Francisco, CA, 94115
agent_only_remarks__c, Offers welcome starting May 11, 2022 | www.SFMansion.com | Easy to show by appointment | A fantastic opportunity to create a custom compound. No For-Sale sign on property. Please note that tax report indicates SFR, 3R indicates occupancy unknown, and there are 2 sets of gas and electric meters. Seller and listing agent have not verified the legal number of bedrooms, bathrooms, property type/use, and square footage figures. These numbers are based on the current layout and appraisal report figures. It's unknown if any bedrooms and/or bathrooms are unwarranted. All interested parties should conduct their own investigation with the appropriate professionals to their satisfaction.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 7
pba__bedrooms_pb__c, 8
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-05-12
ffd_createddate, 2022-02-26T19:48:38.000+0000
days_on_market__c, 508
dom__c, 121
ffd_description_pb, This is a one of a kind Victorian estate on an extra wide lot with downtown views, high ceilings, 5 fireplaces, and many original details throughout. A mansion like no other offering 8 (possibly 10) bedrooms and 8 bathroom with an enormous pent level ready for your imagination. The building is on four levels with more than 7,500 sq.ft. of space (per appraisal). The ground level provides multiple use options for large extended family, home offices, businesses, or income property. Some of the notable features include an enormous 47' x 137' lot (per MLS records), expansive landscaped backyard & patio, spa, 1-car attached garage, 3 off-street parking areas, EV charger, and much more.
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, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-07-13T17:05:31.000+0000
pba__latitude_pb__c, 37.779729
pba__latitude_property__c, 37.779729
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2022-01-27
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Oggi
pba__listing_agent_lastname__c, Kashi
listing_agent_mls_id__c, 807155
ffd_listingagentname, Oggi Kashi
listing_agent_number__c, 166018317
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, NORTH-PT
listing_office_name__c, North Point Real Estate
listing_office_number__c, 27699
pba__listingprice_pb__c, 4488000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.sfmansion.com
pba__longitude_pb__c, -122.440196
lower_level__c, Garage,Full Bath(s),Bedroom(s)
mls_id__c, 422626477
main_level__c, Full Bath(s);Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2022-02-26
original_price__c, 4650000
overall_days_on_market__c, -81140
parking_access__c, Independent
parking_features__c, See Remarks,Interior Access,Garage Door Opener,EV Charging
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Front Porch
pba__pendingdate__c, 2022-06-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 599.87
pba__propertytype__c, Single Family Residence
record_id, a0E8W00000Vt126UAB
room_type__c, Storage;Office;Laundry;Living Room;Dining Room;Family Room;Possible Guest;Great Room;Primary Bedroom 2+
sale_date__c, 2022-08-12
sale_price__c, 4499000
security_features__c, Smoke Detector;Security System Owned;Window Security Bars
selling_agent_mls_id__c, 807976
selling_agent_number__c, 1029359
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, 7500
size__c, 7500
spa__c, 1
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Turk
subdist__c, Anza Vista
ffd_name, 1880 Turk Boulevard, San Francisco, CA, 94115
view__c, City;City Lights;Downtown
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94115
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530395993-1.jpg
ListingId, a0E8W00000Vt126UAB