meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210030' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15714
[post_author] => 4
[post_date] => 2018-11-02 19:54:27
[post_date_gmt] => 2018-11-02 19:54:27
[post_content] => Meet Potrero Hill, where you can check out but you can never really leave. Sunny weather, jaw-dropping views of the downtown skyline and San Francisco Bay. Friendly, charming, and filled with more than you'd expect, it's a hill unto itself.
[post_title] => Potrero Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => potrero-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:08:25
[post_modified_gmt] => 2024-03-19 21:08:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15714
[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, 2244 19th Street, San Francisco, CA, 94107
ffd_mls_id, 494690
ffd_salesforce_id, a0E1I00000QqTzjUAF
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2244 19th Street, San Francisco, CA, 94107
pba__address_pb__c, 2244 19th Street, San Francisco, CA, 94107
agent_only_remarks__c, Sellers' appraisal shows 1,307 square feet of living space. When they bought in 2006 that Seller's appraisal showed 1,349 square feet. Buyers should satisfy themselves as to the size of the home. The room and bath down do not appear on the 3R report so we believe they are unpermitted. Disclosures are available on Disclosures IO including pre-sale property and pest inspections. The offer date has been set for Wednesday February 19th at 5:00 p.m. Please use pre-sale escrow opened with Ria and Joanne at Chicago Title. Escrow # 3652000053. [email protected] 415-252-2757.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Refrigerator;Hood Over Range;Cooktop Stove
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1913
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Jonathan Davis
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-02-07T11:45:51.000+0000
days_on_market__c, 1259
dom__c, 13
ffd_description_pb, Behind the modest facade there is a modern home boasting downtown views. The unusually wide & deep garage will accommodate 2 cars side by side. Ascend the entry stairs to find a wide open living & dining space at the front, with a wall of custom shelving. South facing windows drink in the sunshine all day long. For cold nights there's a gas fireplace. The upstairs bedroom features a huge closet & over sized windows that enjoy sweeping downtown views. The designer en-suite bath is dazzling & unique. The updated kitchen offers abundant counter & cabinet space, a gas cooktop, breakfast bar & spacious eating area. There's a step out deck with downtown views that would be a perfect spot for a BBQ! Down the spiral stair you'll find the 2nd bedroom & bath with a deep walk-in closet. There is direct access to the rear deck & garden where there's plenty of space to relax or entertain. Easy freeway access & a Walk Score of 91 make this your perfect spot in the city whether on foot or in the car.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Gas Piped
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-12T15:27:32.000+0000
pba__latitude_pb__c, 37.76098
pba__latitude_property__c, 37.76098
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-01-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Gullicksen
listing_agent_mls_id__c, 802842
ffd_listingagentname, Tim J Gullicksen
listing_agent_number__c, 802842
listing_co_agent_mls_id__c, 803962
listing_co_agent_number__c, 166013341
listing_co_office_mls_id__c, ZEPH06
listing_co_office_name__c, Zephyr Real Estate
listing_co_office_number__c, 166014343
listing_office_mls_id__c, ZEPH06
listing_office_name__c, Zephyr Real Estate
listing_office_number__c, 166014343
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=MLPxZSRWTj1&mls=1
pba__longitude_pb__c, -122.40484
pba__lotsize_pb__c, 0.04
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 494690
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-02-06
original_price__c, 1495000
overall_days_on_market__c, 64
parking__c, Attached,Garage,Auto Door,Interior Access
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-02-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1329
pba__propertytype__c, Single Family Residence
id, a0E1I00000QqTzjUAF
sale_date__c, 2020-03-05
sale_price__c, 1737000
selling_agent_mls_id__c, 804416
selling_agent_name__c, Claudia L. Siegel
selling_agent_number__c, 166013962
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, 1307
size__c, 1307
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 19th
subdist__c, Potrero Hill
ffd_name, 2244 19th Street, San Francisco, CA, 94107
view__c, Downtown;San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1913
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/360055-1.jpg
ListingId, a0E1I00000QqTzjUAF