meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319368' 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, 1998 25th Street, San Francisco, CA, 94107
ffd_mls_id, 422680248
ffd_salesforce_id, a0E8W00000XlMAvUAN
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 1998 25th Street, San Francisco, CA, 94107
pba__address_pb__c, 1998 25th Street, San Francisco, CA, 94107
agent_only_remarks__c, The disclosure packet is available on homelight/IO and here is the link: https://app.disclosures.io/link/1998-25th-Street-d44f4fm6 Please email the listing agent to schedule appointments and follow advised health safety protocols.
appliances__c, Built-In Gas Range;Built-In Refrigerator
architectural_style__c, Edwardian;Victorian
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 5
year_build_text__c, 1908
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-07-22T16:47:05.000+0000
days_on_market__c, 362
dom__c, 47
ffd_description_pb, Incredible opportunity to purchase a semi-attached, five-bedroom single-family view home on the border of two of San Francisco's most desirable neighborhoods: Potrero Hill and Dogpatch! This unique offering is situated on a corner lot, replete with period details, steeped in Potrero Hill/San Francisco history, and graced with natural light and views from three sides. The home has a flexible floor plan with four bedrooms, a living area, dining room, bathroom in the upper level, and the lower level has a bedroom/workshop/studio and bathroom with separate access. This home is ready for the imagination of a new owner to create their own oasis, influenced by their own tastes, and with a sundrenched yard/garden ideal for entertaining or relaxation. There is a large basement with possible potential for expansion as well. Don't miss this great opportunity that is close to shopping, cafes, public transportation, world class dining, playgrounds, Chase center, Crane cove, HWY 101/280 and more!
district__c, SF District 9
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
fencing__c, Back Yard;Wood
pba__floortype_pb__c, Other;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace
ffd_lastmodifieddate, 2023-07-13T17:23:47.000+0000
pba__latitude_pb__c, 37.7523693
pba__latitude_property__c, 37.7523693
laundry_features__c, Hookups Only
listed_date__c, 2022-07-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jeffrey
pba__listing_agent_lastname__c, Salgado
listing_agent_mls_id__c, 805001
ffd_listingagentname, Jeffrey A Salgado
listing_agent_number__c, 166014760
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 895000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.3983042
lower_level__c, Bedroom(s),Living Room,Street Entrance
mls_id__c, 422680248
main_level__c, Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Tub w/Shower Over
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2022-07-22
original_price__c, 895000
overall_days_on_market__c, -81286
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2022-10-14
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 371.99
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000XlMAvUAN
room_type__c, Storage;Bonus Room;Den;Kitchen;Baths Other;Dining Room
sale_date__c, 2022-11-14
sale_price__c, 850000
security_features__c, Security Gate
selling_agent_mls_id__c, 816926
selling_agent_number__c, 1075857
selling_co_agent_mls_id__c, MLSL5074832
selling_co_agent_number__c, 981226005
selling_co_office_mls_id__c, COMPS-1
selling_co_office_name__c, Compass
selling_co_office_number__c, 981053516
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2285
size__c, 2285
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 25th
subdist__c, Potrero Hill
ffd_name, 1998 25th Street, San Francisco, CA, 94107
view__c, City Lights;Hills
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530500991-1.jpg