meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319413' 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, 25 Sierra Street #E307, San Francisco, CA, 94107
ffd_mls_id, 422693335
ffd_salesforce_id, a0E8W00000Ya3YQUAZ
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 71
address2__c, 25 Sierra Street #E307, San Francisco, CA, 94107
pba__address_pb__c, 25 Sierra Street #E307, San Francisco, CA, 94107
agent_only_remarks__c, Easy to show. Text Brandea at 310-291-8006 for instructions. Pre-escrow opened with Steve Salviejo at DOMA. Contact Brandea at [email protected] / 310-291-8006 for showing instructions, disclosures and questions.
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2006
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Brandea Bunnag
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-09-21T17:48:01.000+0000
days_on_market__c, 301
dom__c, 26
ffd_description_pb, Situated in Potrero Hill, this exquisite top floor 2bd plus office/2ba home is a light-filled, modern retreat featuring radiant bay views and private balcony. On the main level, the open-concept kitchen, dining and living area is framed by a gas fireplace, floor to ceiling windows and skylights. The sliding glass doors open to the charming East facing balcony, perfect for seamless indoor-outdoor living. A bedroom, full bath & W/D complete this level. Retreat upstairs to the primary suite offering en-suite bath and generous closets. Enjoy sweeping Bay views while working from home from the separate bonus office space. This home is complete with one car dedicated garage parking, plus extra storage and a large, lush community courtyard with BBQ, lounge area, and mail room. Conveniently located near 18th Street cafes, restaurants, shops, 22nd Street Caltrain station, Crane Cove, Chase Center and the 280 freeway.
district__c, SF District 9
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Living Room;Gas Log
pba__floortype_pb__c, Laminate;Wood
hoa_fee_includes__c, Insurance,Maintenance Grounds,Management,Trash,Water
pba__hoafees__c, 785
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Sierra Texas Homeowners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Electric;Gas;Fireplace(s)
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-07-13T17:47:50.000+0000
pba__latitude_pb__c, 37.7577997
pba__latitude_property__c, 37.7577997
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2022-08-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Connie
pba__listing_agent_lastname__c, Chung
listing_agent_mls_id__c, 809137
ffd_listingagentname, Connie Chung
listing_agent_number__c, 1040715
listing_co_agent_mls_id__c, 816302
listing_co_agent_number__c, 1075266
listing_co_office_mls_id__c, WILLMAR
listing_co_office_name__c, Willowmar Real Estate
listing_co_office_number__c, 28843
listing_office_mls_id__c, WILLMAR
listing_office_name__c, Willowmar Real Estate
listing_office_number__c, 28843
pba__listingprice_pb__c, 1049000
pba__listingtype__c, Sale
pba__listing_website__c, https://player.vimeo.com/video/752686475
pba__longitude_pb__c, -122.3955308
mls_id__c, 422693335
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Skylight/Solar Tube
master_property__c, a0O1I000001VhmkUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-09-21
original_price__c, 1049000
overall_days_on_market__c, -81347
parking_access__c, Side by Side
parking_features__c, Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2022-10-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 950.52
pba__propertytype__c, Condominium
ListingId, a0E8W00000Ya3YQUAZ
room_type__c, Office
sale_date__c, 2022-11-16
sale_price__c, 999000
security_features__c, Secured Access
selling_agent_mls_id__c, 810551
selling_agent_number__c, 1046889
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Chance Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1051
size__c, 1051
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Sierra
subdist__c, Potrero Hill
ffd_name, 25 Sierra Street #E307, San Francisco, CA, 94107
view__c, City;Bay;Water;Mt Diablo
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2006
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530531389-1.jpg