meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214710' 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 #W606, San Francisco, CA, 94107
ffd_mls_id, 505018
ffd_salesforce_id, a0E1I00000TvOwVUAV
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 71
address2__c, 25 Sierra Street #W606, San Francisco, CA, 94107
pba__address_pb__c, 25 Sierra Street #W606, San Francisco, CA, 94107
agent_only_remarks__c, Www.25sierra-606.com. COVID Compliant showings only by private appt with PEAD-V. Pre sale escrow opened with Kelley Kish at FATCO, escrow # 6258112. Disclosure package available. Tax records state 1751 square feet and appraisal states 1762; buyer to investigate to their satisfaction. Offers to be submitted on SFAR 7 page contract only.
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Hood Over Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Remodeled;Dual Flush Toilet;Skylight/Solar Tube
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2006
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-02-02
ffd_createddate, 2021-01-08T17:46:59.000+0000
days_on_market__c, 1036
dom__c, 143
ffd_description_pb, Luxurious elegance meets modern practicality in this renovated, top floor corner unit that checks all the boxes for today's lifestyle! Direct elevator access from the garage takes you to an open floor plan w/walls of windows drawing in Potrero's abundant sunshine. There is seamless indoor/outdoor living between the sunny PRIVATE deck & the great room, w/ample space for Netflix on the flat screen, dining, & relaxing by the frplc. Cooking is easy with a custom island in the renovated chef's kitchen w/SS appls, quartz counters, & generous storage. A large pantry w/2nd fridge is essential for stocking up. Down the hall are 3 bdrms + 2 gorgeous baths. The lavish suite boasts 3 closets + bath w/ dbl sink vanity, spa shower & skylight. The southern bdrm has a built-in desk for WFH, reclaimed wood flrs & balcony. Detached on 3 sides, w/recessed lights, bamboo floors, W/D, 2 car pking + storage, and near chic cafes + transportation, this is the ideal city home. Priced less than sellers paid!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Piped
pba__floor__c, 0
pba__floortype_pb__c, Wood;Reclaimed
hoa_dues__c, 911.32
hoa_fee_includes__c, Management,Maintenance Exterior,Trash,Maintenance Grounds,Homeowners Insurance,Water
pba__hoafees__c, 911
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace
ffd_lastmodifieddate, 2022-01-25T15:34:03.000+0000
pba__latitude_pb__c, 37.7577997
pba__latitude_property__c, 37.7577997
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-09-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Elizabeth
pba__listing_agent_lastname__c, Branham
listing_agent_mls_id__c, 802276
ffd_listingagentname, Elizabeth C Branham
listing_agent_number__c, 802276
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 1595000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.25sierra-606.com/
pba__longitude_pb__c, -122.3955308
pba__lotsize_pb__c, 0
mls_id__c, 505018
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_property__c, a0O1I000001VhmkUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-09-16
original_price__c, 1715000
overall_days_on_market__c, 196
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Interior Access,Side-by-Side,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-02-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 883.09
pba__propertytype__c, Condominium
id, a0E1I00000TvOwVUAV
sale_date__c, 2021-04-01
sale_price__c, 1556000
selling_agent_mls_id__c, 666666
selling_agent_number__c, 666666
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, N/A
pba__status__c, Closed
pba__totalarea_pb__c, 1762
size__c, 1762
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Sierra
subdist__c, Potrero Hill
ffd_name, 25 Sierra Street #W606, San Francisco, CA, 94107
transportation__c, 2 Blocks
unit_number__c, W606
view__c, Panoramic;Bay;San Francisco
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/370048-1.jpg
ListingId, a0E1I00000TvOwVUAV