meta_query='key:subdist__c;value:Downtown|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235744' 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 #712, San Francisco, CA, 94109
ffd_mls_id, 422636413
ffd_salesforce_id, a0E8W00000VtuuzUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 186
address2__c, 631 Ofarrell Street #712, San Francisco, CA, 94109
pba__address_pb__c, 631 Ofarrell Street #712, San Francisco, CA, 94109
agent_only_remarks__c, Offers due Tuesday March. 22 at 2:00PM. Will look at all offers at that time. Please contact Tom for showings (415-254-1672) Building protocol requires wearing of masks in the public areas.
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 1930
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-03-22
ffd_createddate, 2022-03-12T02:49:57.000+0000
days_on_market__c, 495
dom__c, 28
ffd_description_pb, *Please look at the video to see unit* Move-in ready roomy alcove studio with lovely details in the legendary Hamilton building.Three large windows fill the unit with glorious light.9' ceilings add spacious feeling. Wood floors add to the feeling of spaciousness. Sellers added some beautiful custom touches to make this a special home.Bedroom alcove is large enough to hold a queen bed. Galley kitchen has been nicely updated,including gorgeous wood cabinets and under-counter freezer. Bathroom has been remodeled as well and is quite charming. 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!LINK TO VIDEO https://youtu.be/ac_ex_6erKU
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Door Person,Electricity,Elevator,Insurance on Structure,Maintenance Exterior,Management,Trash,Water
pba__hoafees__c, 619
pba__hoafrequency_pb__c, Monthly
hoa_name__c, The Hamilton Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Steam
ffd_lastmodifieddate, 2022-05-07T01:49:07.000+0000
pba__latitude_pb__c, 37.785223
pba__latitude_property__c, 37.785223
laundry_features__c, In Basement
listed_date__c, 2022-03-07
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, 399000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/ac_ex_6erKU
pba__longitude_pb__c, -122.415097
mls_id__c, 422636413
master_property__c, a0O8W00000DagtgUAB
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2022-03-11
original_price__c, 399000
overall_days_on_market__c, -81153
pba__pendingdate__c, 2022-04-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-05-06T10:31:33.000+0000
price_per_square_foot__c, 798.08
pba__propertytype__c, Condominium
id, a0E8W00000VtuuzUAB
sale_date__c, 2022-05-06
sale_price__c, 415000
selling_agent_mls_id__c, 811130
selling_agent_number__c, 1049993
selling_co_agent_mls_id__c, 811187
selling_co_agent_number__c, 1050296
selling_co_office_mls_id__c, VANG06
selling_co_office_name__c, Vanguard Properties
selling_co_office_number__c, 25987
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 #712, San Francisco, CA, 94109
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/530417549-1.jpg
ListingId, a0E8W00000VtuuzUAB