meta_query='key:subdist__c;value:Downtown|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216612' 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] => 2023-10-31 09:49:09
[post_modified_gmt] => 2023-10-31 16:49:09
[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, 631 Ofarrell Street #1604, San Francisco, CA, 94109
ffd_mls_id, 512226
ffd_salesforce_id, a0E1I00000TvYj1UAF
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 186
address2__c, 631 Ofarrell Street #1604, San Francisco, CA, 94109
pba__address_pb__c, 631 Ofarrell Street #1604, San Francisco, CA, 94109
agent_only_remarks__c, Agent lives in building. Call Tom at (415)254-1672 for showing.Follow Covid-19 guidelines. Agent,buyer must submit PEAD-V form to listing agent prior to viewing.
appliances__c, Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Art Deco
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 1930
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-04-14
ffd_createddate, 2021-01-16T20:46:20.000+0000
days_on_market__c, 915
dom__c, 108
ffd_description_pb, EXCITING NEW PRICE!!!!Photos are virtually staged - Roomy alcove studio with lovely details in the legendary Hamilton building. 16th floor unit with easy access to view sky deck on same level. There are only 5 units on the 16th floor so hallways are short and bright. Three large windows with spectacular Northern views fill the unit with glorious light. 9' ceilings add spacious feeling. Bedroom alcove is large enough to hold a queen bed. Kitchen has been opened up and nicely updated. New paint and carpeting! Building is an Art-Deco gem featuring a soaring lobby, ballroom with adjacent kitchen for parties, patio, fitness center, 24-hour desk, view sky deck. Newer washers and dryers are in the basement laundry room. Convenient location close to Union Square and burgeoning Mid-Market. Walk to BART/MUNI. Parking is on a waitlist but no need for a car in this location! Pictures are of the view from unit, and the common areas of the building. Video tour coming shortly!!!
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
pba__floortype_pb__c, Carpet
hoa_dues__c, 779
hoa_fee_includes__c, Door Person,Electricity,Heat,Maintenance Exterior,Management,Trash,Water
pba__hoafees__c, 779
pba__hoafrequency_pb__c, Monthly
hoa_name__c, The Hamilton Associate
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Steam;Central
ffd_lastmodifieddate, 2022-01-25T15:42:42.000+0000
pba__latitude_pb__c, 37.785223
pba__latitude_property__c, 37.785223
laundry_appliances__c, In Laundry Room
laundry_features__c, In Basement
listed_date__c, 2020-12-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Thomas
pba__listing_agent_lastname__c, Cacciotti
listing_agent_mls_id__c, 805037
ffd_listingagentname, Thomas Cacciotti
listing_agent_number__c, 166014809
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG
listing_office_name__c, Vanguard Properties
listing_office_number__c, 2172
pba__listingprice_pb__c, 495000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/8k3MaB3mCKQ
pba__longitude_pb__c, -122.415097
pba__lotsize_pb__c, 0
mls_id__c, 512226
master_property__c, a0O8W00000DagtgUAB
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-01-15
original_price__c, 539000
overall_days_on_market__c, 180
parking_features__c, No Garage
parking_type__c, None
pba__pendingdate__c, 2021-05-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 938.46
pba__propertytype__c, Condominium
id, a0E1I00000TvYj1UAF
sale_date__c, 2021-05-18
sale_price__c, 488000
security_features__c, Smoke Detector;Guarded Gate
selling_agent_mls_id__c, 805037
selling_agent_number__c, 166014809
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 520
size__c, 520
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Ofarrell
subdist__c, Downtown
ffd_name, 631 Ofarrell Street #1604, San Francisco, CA, 94109
transportation__c, 1 Block
unit_number__c, 1604
view__c, Panoramic
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1930
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/375782-1.jpg
ListingId, a0E1I00000TvYj1UAF