meta_query='key:subdist__c;value:Corona Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330760' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15601
[post_author] => 4
[post_date] => 2018-11-02 02:29:46
[post_date_gmt] => 2018-11-02 02:29:46
[post_content] => Above it all but still in the thick of it, with a great neighborhood dog run, park, and community museum/center. Winding curves, steep hills, jaw-dropping views, sudden changes in direction. You aren't lost. You're in Corona Heights.
[post_title] => Corona Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => corona-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 02:29:46
[post_modified_gmt] => 2018-11-02 02:29:46
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15601
[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, 114 Douglass Street, San Francisco, CA, 94114
ffd_mls_id, 423726895
ffd_salesforce_id, a0E8W00000bGCQ3UAO
num_of_fireplaces__c, 3
num_of_rooms__c, 7
of_units__c, 0
address2__c, 114 Douglass Street, San Francisco, CA, 94114
pba__address_pb__c, 114 Douglass Street, San Francisco, CA, 94114
agent_only_remarks__c, Abundant street parking available. Upstairs is tenant occupied with monthly rents of ~$5,300, downstairs is vacant. Upstairs Tenants (2) are on one lease and have both indicated that they are not members of a protected class. Tax records for upstairs levels show a 2 bedroom residence although it currently lives as a three bedroom - Buyer to investigate to their own satisfaction. Although classified as a SFH per city records, the owner historically rented both levels to separate tenants. Agents and Seller believe the downstairs level is not warranted space and we received a bid to legalize the downstairs into either a one or two bedroom level. Opportunity abounds and a future owner may wish to integrate the downstairs with the upstairs level. 1965 sqft, per graphic artist, combines both levels. Out of consideration for tenants, we ask buyers and agents to attend public opens versus scheduling private showings. Disclosures will be available Monday, March 27th. For showing and disclosure requests please contact David Alexander at [email protected] or 415.900.9068. For all other questions, contact Alexander Lurie at 415.696.0288. Offer date to be established after first Broker Tour (3/28).
appliances__c, Dishwasher;Microwave;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over;Tile;Jack & Jill
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, David J Alexander
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-24T01:48:26.000+0000
days_on_market__c, 40
dom__c, 12
ffd_description_pb, Exquisite 4-bedroom Victorian Single Family Home in Corona Heights. The primary level offers 3 bedrooms, 1.5 bathrooms and soaring ceilings, superb period details, historic light fixtures including a magnificent crystal chandelier, large open kitchen, formal dining room, bright living room, ample built-in closets and storage space, original flooring, and two beautiful fireplaces. An expansive and well-manicured magical garden features verdant trees and plant life and a level patio for entertaining and relaxation. The upstairs is currently tenant occupied. The vacant one-bedroom, one bathroom downstairs level with its own separate entrance has been extensively upgraded and features fabulous lighting, moldings, hardwood floors, luxurious carpeting, fireplace, ample storage and its own separate garden. This pristine Victorian is centrally located with an ideal 98 walk-score and blocks to beloved restaurants, parks and shops in Cole Valley and Castro.
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced
fireplace_features__c, Living Room;Gas Piped;Dining Room;Insert
pba__floortype_pb__c, Carpet;Tile;Wood;Stone
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Fireplace(s);Fireplace Insert
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2023-05-02T10:51:00.000+0000
pba__latitude_pb__c, 37.7618689
pba__latitude_property__c, 37.7618689
laundry_features__c, In Basement;Washer Included;Dryer Included
listed_date__c, 2023-03-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Alexander
pba__listing_agent_lastname__c, Lurie
listing_agent_mls_id__c, 810063
ffd_listingagentname, Alexander F Lurie
listing_agent_number__c, 1044526
listing_co_agent_mls_id__c, 808444
listing_co_agent_number__c, 1035112
listing_co_office_mls_id__c, GAETA
listing_co_office_name__c, Gaetani Real Estate
listing_co_office_number__c, 25971
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1599000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4396514
lower_level__c, Bedroom(s),Kitchen,Living Room
mls_id__c, 423726895
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over;Tile;Window;Stone
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-03-23
original_price__c, 1599000
overall_days_on_market__c, -81530
patio_and_porch_features__c, Back Porch
pba__pendingdate__c, 2023-04-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-05-01T15:32:17.000+0000
price_per_square_foot__c, 842.24
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bGCQ3UAO
road_surface_type__c, Paved
roof__c, Composition
room_type__c, Storage;Bonus Room;Kitchen;In Law Apartment;Living Room;Dining Room;Wine Storage Area;Primary Bedroom 2+
sale_date__c, 2023-04-25
sale_price__c, 1655000
security_features__c, Security Gate
selling_agent_mls_id__c, 812317
selling_agent_number__c, 1056202
selling_co_agent_mls_id__c, 804756
selling_co_agent_number__c, 166014430
selling_co_office_mls_id__c, COMP12
selling_co_office_name__c, Compass
selling_co_office_number__c, 28739
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1965
size__c, 1965
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Douglass
subdist__c, Corona Heights
ffd_name, 114 Douglass Street, San Francisco, CA, 94114
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530594540-1.jpg