meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='378255' 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
(
)
)
_yoast_indexnow_last_ping, 1724979156
ffd_listing_title, 1001 17th Street #301, San Francisco, CA, 94107
ffd_mls_id, 424032664
ffd_salesforce_id, a0EUd0000027CswMAE
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 26
address2__c, 1001 17th Street #301, San Francisco, CA, 94107
pba__address_pb__c, 1001 17th Street #301, San Francisco, CA, 94107
agent_only_remarks__c, Seller will consider offers which requests for buyer concessions | Easy to Show - Book your tour on Calendly here > https://calendly.com/1001-17th-301/tour | Showing needs to be confirmed in separate email/text and Pls follow showing instructions you receive via email. Street parkings are extremely easy in Potrero Hill (obtain neighborhood sticker!)even for your guests or leased parking space available nearby. Minimum lease is only 30 days! Call/text Mia 415.728.2596 | [email protected] for more info. Offers to be on most recent SFAR contract. Escrow opened with Michael Yip at Chicago Title. Pls follow offer instructions on the disclosure.io https://app.disclosures.io/link/1001-17th-Street-301-ccyowy9v
appliances__c, Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Free Standing Freezer
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Tub w/Shower Over;Radiant Heat
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2016
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-05-23T19:48:38.000+0000
days_on_market__c, 98
dom__c, 98
ffd_description_pb, This chic corner residence offers a spacious living area w soaring ceilings & expansive windows that frame tranquil views of the beautifully landscaped courtyard. Situated in the sought-after north slope of Potrero Hill, on the cusp of Mission Bay and the Dogpatch waterfront, this serene home boasts sleek, contemporary interiors with wide-plank oak flooring throughout. The designer kitchen features Pental Quartz countertops & Bosch appliances, perfect for culinary enthusiasts. The luxurious bedroom showcases large windows and ample storage w custom organizers. Indulge in the modern bathroom w a spa-like tub & convenient in-unit laundry. This boutique building, designed by ELEVATION Architects, houses 26 residences. Benefit from low HOA dues that cover amenities like Radient Heat, a unit intercom system with a camera, security setup, Webpass Internet, and a vast communal courtyard with a fire pit, BBQ, garden furniture & bike storage. Street parking is easy, or onsite leasing avail. Enjoy the vibrant neighborhood with trendy shops, dining spots, Whole Foods, Plow, SF Design District, UCSF, Chase Center, Oracle Park, and the SF Bay waterfront. Located just blocks away from Caltrain and the 101 & 280 Freeways, this prime address is perfect for Peninsula and South Bay commuters
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Elevator,Gas,Heat,Insurance,Insurance on Structure,Internet,Maintenance Exterior,Maintenance Grounds,Management,Security,Sewer,Trash,Water
pba__hoafees__c, 473
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Radiant
ffd_lastmodifieddate, 2024-08-30T00:46:49.000+0000
pba__latitude_pb__c, 37.765037
pba__latitude_property__c, 37.765037
laundry_features__c, Laundry Closet;Hookups Only;Washer/Dryer Stacked Included
listed_date__c, 2024-05-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Miyuki Mia
pba__listing_agent_lastname__c, Takami
listing_agent_mls_id__c, 806485
ffd_listingagentname, Miyuki Mia Takami
listing_agent_number__c, 166017050
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, EXPRE
listing_office_name__c, eXp Realty of California, Inc
listing_office_number__c, 26334
pba__listingprice_pb__c, 639000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.394143
mls_id__c, 424032664
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Quartz;Tile;Soaking Tub
master_property__c, a0O1I000001VhnkUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-05-23
original_price__c, 669000
overall_days_on_market__c, -81957
parking_access__c, Side by Side
parking_features__c, See Remarks
parking_type__c, Other
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1000
pba__propertytype__c, Condominium
ListingId, a0EUd0000027CswMAE
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Video System;Security System Prewired;Security System Owned
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 639
size__c, 639
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 17th
subdist__c, Potrero Hill
ffd_name, 1001 17th Street #301, San Francisco, CA, 94107
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 2016
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530782855-1.jpg