meta_query='key:subdist__c;value:Corona Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212553' 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] => 2024-03-19 13:40:29
[post_modified_gmt] => 2024-03-19 20:40:29
[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, 4331 17th Street, San Francisco, CA, 94114
ffd_mls_id, 499253
ffd_salesforce_id, a0E1I00000SxxD9UAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 4331 17th Street, San Francisco, CA, 94114
pba__address_pb__c, 4331 17th Street, San Francisco, CA, 94114
agent_only_remarks__c, Disclosures are now available via MLS. Your offer is welcome at any time. Please have buyer's review all available media. Buyer's are encouraged to investigate all details to their satisfaction. Private showings are available with PA letter, signed PEAD and following all COVID-19 Health Guidelines.
appliances__c, Dishwasher;Gas Water Heater;Gas Range;Disposal;Refrigerator;Hood Over Range;Double Oven;Ice Maker
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Remodeled;Tile;Skylight/Solar Tube;Radiant Heat
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1922
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-07-08T16:46:12.000+0000
days_on_market__c, 1106
dom__c, 7
ffd_description_pb, This thoughtfully designed, 1,630 SF, 3-bed, 2-bath single-family home is all about indulging your passions. With a reverse floor plan and extensive renovation in 2015, you'll love the upper level great room with wide plank wood floors, skylights, and the custom-designed kitchen with top of the line s/s appliances and quartz counters. Showcase your culinary skills while entertaining friends around the over-sized island. An added balcony accommodates your grill and has beautiful overlooks of Eureka Valley and Twin Peaks. At the front is a huge bedroom with a quiet seating area and a gas fireplace. On the ground level is an updated 2nd bath and two additional bedrooms, each with french doors leading out to the lush rear yard and well maintained hot tub. Recent updates include high end appliances, a new roof, and upgraded electrics, some seismic work. Just a short distance up the hill from the shops, restaurants and transit options/shuttles of the Castro/Market Street Corridor.
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Gas Piped;Master Bedroom
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:24:11.000+0000
pba__latitude_pb__c, 37.7619931
pba__latitude_property__c, 37.7619931
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-06-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mark
pba__listing_agent_lastname__c, McHale
listing_agent_mls_id__c, 800917
ffd_listingagentname, Mark D McHale
listing_agent_number__c, 800917
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 1795000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?brand=0&m=GEaRv1jm3jZ
pba__longitude_pb__c, -122.4410335
pba__lotsize_pb__c, 0.03
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 499253
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-07-08
original_price__c, 1795000
overall_days_on_market__c, 116
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-07-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1257.67
pba__propertytype__c, Single Family Residence
id, a0E1I00000SxxD9UAJ
roof__c, Bitumen
sale_date__c, 2020-08-10
sale_price__c, 2050000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 802979
selling_agent_name__c, Brendon Kearney
selling_agent_number__c, 802979
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1630
size__c, 1630
spa__c, 1
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 17th
subdist__c, Corona Heights
ffd_name, 4331 17th Street, San Francisco, CA, 94114
transportation__c, 3 Blocks
view__c, Panoramic;Twin Peaks;Valley
website_property_type__c, Single Family Home
window_features__c, Dual Pane
pba__yearbuilt_pb__c, 1922
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/364147-1.jpg
ListingId, a0E1I00000SxxD9UAJ