meta_query='key:subdist__c;value:Downtown|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='325104' 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] => 2018-11-30 20:30:47
[post_modified_gmt] => 2018-11-30 20:30:47
[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, 1158 Sutter Street #8, San Francisco, CA, 94109
ffd_mls_id, 423720394
ffd_salesforce_id, a0E8W00000bDlEsUAK
num_of_fireplaces__c, 1
num_of_rooms__c, 4
of_units__c, 15
address2__c, 1158 Sutter Street #8, San Francisco, CA, 94109
pba__address_pb__c, 1158 Sutter Street #8, San Francisco, CA, 94109
agent_only_remarks__c, Property is vacant and shows great. Some of the pics in mls are virtually staged along with vacant pictures of the same rooms. This is a trust sale. Offer instructions are included in the disclosure package; please review in preparation for an offer. Offers are to be written on the latest version of the SFAR purchase contract; if you don't have access to one, we will provide one to you. Please email both Eric and Peter and we'll arrange to get you in. No Showing Time please.
appliances__c, Dishwasher;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2008
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Peter J Grady
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-09T19:49:48.000+0000
days_on_market__c, 42
dom__c, 42
ffd_description_pb, Contemporary condo surrounded by urban amenities. The association is small (15 units) and professionally managed. The building itself is interesting, in that it used to be a taxi garage; upgraded and converted to condos in 2008. The structure is concrete column and beam and is visible throughout the units and common areas, which creates an interesting architecture and lofty feel in the units. Common areas include a lush courtyard with gurgling fountain, roof deck, intercom system and two elevators - one for people and one for cars! Home #8 has a welcoming, open concept, lofty living/dining/ kitchen, with cozy gas fireplace and a quiet courtyard view. You have all you need, in this vibrant area; two bedrooms, two baths, (one bed and bath is ensuite), in-unit stackable washer/dryer, gas stove, engineered floors and parking. The location is convenient; near restaurants, grocery stores, theaters, gyms, coffee shops and a climbing wall! The recently completed Van Ness Bus Rapid Transit corridor connects you to the SF Symphony, Opera House, Herbst Theater, SF Jazz Center, SF Main Library, the Asian Art Museum and other public transit lines. Freeway to points both north and south including Marin and the Peninsula.
district__c, SF District 8
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
fireplace_features__c, Living Room;Gas Log
pba__floortype_pb__c, Tile;Simulated Wood
hoa_fee_includes__c, Common Areas,Elevator,Insurance on Structure,Internet,Maintenance Exterior,Management,Trash,Water
pba__hoafees__c, 761
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 1158 Sutter Owners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant Floor
interior_features__c, Open Beam Ceiling
ffd_lastmodifieddate, 2023-03-23T10:48:20.000+0000
pba__latitude_pb__c, 37.788094
pba__latitude_property__c, 37.788094
laundry_features__c, Laundry Closet
listed_date__c, 2023-02-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Eric
pba__listing_agent_lastname__c, Castongia
listing_agent_mls_id__c, 393127
ffd_listingagentname, Eric Castongia
listing_agent_number__c, 393127
listing_co_agent_mls_id__c, 805411
listing_co_agent_number__c, 166015332
listing_co_office_mls_id__c, CIP
listing_co_office_name__c, Corcoran Icon Properties
listing_co_office_number__c, 28936
listing_office_mls_id__c, CIP
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28936
pba__listingprice_pb__c, 849000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.419617
mls_id__c, 423720394
master_property__c, a0O1I000001Vi1cUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-02-09
open_house_end__c, 2023-03-26T15:30:00.000+0000
open_house_start__c, 2023-03-26T14:00:00.000+0000
original_price__c, 849000
overall_days_on_market__c, -81488
parking_access__c, Independent
parking_features__c, Enclosed,Interior Access
parking_type__c, On Site - Mapped (Condo Only)
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, 1048.15
pba__propertytype__c, Condominium
ListingId, a0E8W00000bDlEsUAK
sale_date__c, 1800-01-01
sale_price__c, 0
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, 810
size__c, 810
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Sutter
subdist__c, Downtown
ffd_name, 1158 Sutter Street #8, San Francisco, CA, 94109
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2008
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530578035-1.jpg
