meta_query='key:subdist__c;value:Nob Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376886' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15722
[post_author] => 4
[post_date] => 2018-11-02 19:54:40
[post_date_gmt] => 2018-11-02 19:54:40
[post_content] => The Comstock. Jones St. Drop-dead downtown views. Polk Street. When elegant begins to get a bit denser and estates become co-ops and full-floor penthouse homes, you'll know you've crossed Van Ness and arrived in Nob Hill.
[post_title] => Nob Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => nob-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:43:12
[post_modified_gmt] => 2024-03-19 21:43:12
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15722
[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, 1717185512
ffd_listing_title, 1788 Clay Street #702, San Francisco, CA, 94109
ffd_mls_id, 424010487
ffd_salesforce_id, a0EUd000001J618MAC
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 98
address2__c, 1788 Clay Street #702, San Francisco, CA, 94109
pba__address_pb__c, 1788 Clay Street #702, San Francisco, CA, 94109
agent_only_remarks__c, Pre-escrow opened with Fidelity National Title.
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Ice Maker;Self/Cont Clean Oven;Built-In Refrigerator;Plumbed For Ice Maker;Built-In Electric Oven;Gas Plumbed
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Lesley Mattos
pba__contingentdate__c, 2024-05-17
cooling__c, Central
ffd_createddate, 2024-02-29T19:47:04.000+0000
days_on_market__c, 92
dom__c, 89
ffd_description_pb, Stylish residence with luxurious finishes and dark wood floors throughout. Features oversized windows, a bright and spacious living area with beautiful open views of Nob Hill and Russian Hill. The open kitchen has dark walnut cabinetry, quartz counters, top of the line stainless steel appliances including a Bertazzoni cooktop. Gracious master bedroom has ample walk in closet with custom organizers. The spa bath is spacious and modern. Central air and heating, custom drapes and shades in all rooms. Comes with in-unit washer/dryer and 1-car XL deeded parking space. At the juncture of Nob Hill, Russian Hill and Pacific Heights, the building has an attended lobby and courtyard with firepit lounge area, bocce ball, gas BBQ and two dining areas. Transportation just outside your door and steps away from restaurants, nightlife, shopping and other amenities of the Polk Corridor.
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 793
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2024-05-31T19:47:24.000+0000
pba__latitude_pb__c, 37.7925085
pba__latitude_property__c, 37.7925085
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included;Stacked Only
listed_date__c, 2024-02-19
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michael
pba__listing_agent_lastname__c, Machado
listing_agent_mls_id__c, 803708
ffd_listingagentname, Mike Machado
listing_agent_number__c, 803708
listing_co_agent_mls_id__c, 816981
listing_co_agent_number__c, 1075899
listing_co_office_mls_id__c, CBLUXURY
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 2128
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 779000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4223823
mls_id__c, 424010487
master_bathroom_features__c, Tub w/Shower Over
master_property__c, a0O1I000001VhhFUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-02-29
original_price__c, 899000
overall_days_on_market__c, -81873
parking_access__c, Side by Side
parking_features__c, Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-05-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-05-31T05:51:14.000+0000
price_per_square_foot__c, 1122.45
pba__propertytype__c, Condominium
ListingId, a0EUd000001J618MAC
sale_date__c, 2024-05-30
sale_price__c, 770000
selling_agent_mls_id__c, 816343
selling_agent_number__c, 1075304
selling_co_agent_mls_id__c, 814798
selling_co_agent_number__c, 1068324
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, 686
size__c, 686
pba__state_pb__c, CA
stories__c, 8
pba__street_pb__c, Clay
subdist__c, Nob Hill
ffd_name, 1788 Clay Street #702, San Francisco, CA, 94109
view__c, San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530734868-1.jpg