meta_query='key:subdist__c;value:Downtown|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215321' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70672
[post_author] => 4
[post_date] => 2018-11-30 20:30:47
[post_date_gmt] => 2018-11-30 20:30:47
[post_content] => Not quite as glamorous as the Financial District, not quite as tough as the Tenderloin. Midrise mixed-use buildings dominate in the district that includes tourist-heavy destinations and world-class shopping district Union Square.
[post_title] => Downtown
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => downtown
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:10:22
[post_modified_gmt] => 2024-04-09 18:10:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70672
[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, 1001 Pine Street #404, San Francisco, CA, 94109
ffd_mls_id, 507010
ffd_salesforce_id, a0E1I00000TRlr8UAD
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 161
address2__c, 1001 Pine Street #404, San Francisco, CA, 94109
pba__address_pb__c, 1001 Pine Street #404, San Francisco, CA, 94109
agent_only_remarks__c, COVID-19 compliant showing: Please contact Bill Mar 415-203-2363 for private showing. Provide signed PEAD prior to showing and follow NAR showing guidelines. Pre-Escrow open with Nancy Chan, First American Title #3802-6378408. Please visit http://www.1001pinestunit404.com/ for 3D Tours & videos. For disclosures: https://app.disclosures.io/link/1001-Pine-Street-404-djkjbtmf
appliances__c, Dishwasher;Electric Range;Disposal;Refrigerator;Hood Over Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1963
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Bill Mar
pba__contingentdate__c, 2021-01-07
ffd_createddate, 2020-10-06T12:45:53.000+0000
days_on_market__c, 1016
dom__c, 100
ffd_description_pb, Radiant and revitalized corner unit condo! Remodeled and richly adorned, this 1BR/1BA opulent home provides sheer comfort, an ideal location, and unparalleled cityscape views from the rooftop! Conveniently situated between Nob Hill, Union Square, and City Hall, you experience the very best of San Francisco, while having it all in a full-service building. Once inside, you are greeted with an open floor plan and tons of luminous flowing light. Eco-friendly engineered hardwood flooring spans the entirety of the living space, and the gourmet kitchen includes stainless steel appliances, quartz countertops, and a center island w/seating. Find serenity in the evening in the sizeable bedroom or opt to leisurely work from home. Relish in the external closet organization system and the chic full bathroom featuring a shower/tub combo. Other features include 1-parking space, additional storage, common roof deck, and walk score of 99 with steps away from Union Square, and much more!
district__c, SF District 8
entry_level__c, 4
external_listing__c, 1
pba__floor__c, 4
hoa_dues__c, 560
hoa_fee_includes__c, Management,Maintenance Exterior,Trash,Maintenance Grounds,Security,Water
pba__hoafees__c, 560
hoa_name__c, Pine Terrace Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Baseboard;Electric
ffd_lastmodifieddate, 2022-01-25T15:36:41.000+0000
pba__latitude_pb__c, 37.79034083
pba__latitude_property__c, 37.79034083
listed_date__c, 2020-09-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Susie
pba__listing_agent_lastname__c, Lee
listing_agent_mls_id__c, 814242
ffd_listingagentname, Susie Lee
listing_agent_number__c, 1065352
listing_co_agent_mls_id__c, 803381
listing_co_agent_number__c, 803381
listing_co_office_mls_id__c, COMP46
listing_co_office_name__c, Compass
listing_co_office_number__c, 28120
listing_office_mls_id__c, COMP46
listing_office_name__c, Compass
listing_office_number__c, 28120
pba__listingprice_pb__c, 769000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.1001pinestunit404.com/
pba__longitude_pb__c, -122.41252833
pba__lotsize_pb__c, 0
mls_id__c, 507010
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O8W00000DaguFUAR
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-10-06
original_price__c, 769000
overall_days_on_market__c, 176
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Interior Access,Side-by-Side,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-01-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1217.53
pba__propertytype__c, Condominium
id, a0E1I00000TRlr8UAD
sale_date__c, 2021-01-29
sale_price__c, 750000
selling_agent_mls_id__c, 814531
selling_agent_number__c, 1066731
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 616
size__c, 616
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Pine
subdist__c, Downtown
ffd_name, 1001 Pine Street #404, San Francisco, CA, 94109
unit_number__c, 404
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1963
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371702-1.jpg
ListingId, a0E1I00000TRlr8UAD