meta_query='key:subdist__c;value:Yerba Buena|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='238813' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15736
[post_author] => 4
[post_date] => 2018-11-02 20:00:55
[post_date_gmt] => 2018-11-02 20:00:55
[post_content] => Cultural haven. Home to that high-rise. If any SF neighborhood comes remotely close to vaguely feeling like Manhattan, the hustle and bustle of Yerba Buena probably comes closest. Yes, you are south of Market. But this is Yerba Buena.
[post_title] => Yerba Buena
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => yerba-buena
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 20:00:55
[post_modified_gmt] => 2018-11-02 20:00:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15736
[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, 74 New Montgomery Street #410, San Francisco, CA, 94105
ffd_mls_id, 421605242
ffd_salesforce_id, a0E8W00000V0u3xUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 107
address2__c, 74 New Montgomery Street #410, San Francisco, CA, 94105
pba__address_pb__c, 74 New Montgomery Street #410, San Francisco, CA, 94105
agent_only_remarks__c, Show by appointment only
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Refrigerator;Self/Cont Clean Oven;Built-In Electric Range;Free Standing Electric Range;Built-In Electric Oven
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Quartz;Stone
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1914
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-10-19
ffd_createddate, 2021-10-20T10:50:15.000+0000
days_on_market__c, 371
dom__c, 31
ffd_description_pb, Rare opportunity to own a one of the Luxury residence in SOMA, one of the city's most upscale & vibrant area. The Montgomery integrates historic architecture with elegant, modern interior elements. The unit has natural light with soaring lofty ceiling, contemporary kitchen with granite countertops, teak cabinets and stainless steal appliances. Assigned storage locker in the building, Washer/dryer in the unit. Amenities includes: 24 hours front desk concierge, dry cleaning service, secured bike storage, pano view roof top terrace with lounge area. Walk to Embarcadero, Financial district, Ferry Building, SF MOMA, Metreon, Union SQ! 1/2 block to public transportation. 98 Walk score. This unit has it ALL!
district__c, SF District 9
electric__c, 220 Volts,220 Volts in Kitchen
entry_level__c, 0
exterior_features__c, Uncovered Courtyard;BBQ Built-In;Fire Pit
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas,Door Person,Insurance,Insurance on Structure,Maintenance Exterior,Management,Roof,Security,Trash
pba__hoafees__c, 907
pba__hoafrequency_pb__c, Monthly
hoa_name__c, The Montgomery
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Hot Water;Central;Electric
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-10-24T14:38:56.000+0000
pba__latitude_pb__c, 37.787549
pba__latitude_property__c, 37.787549
laundry_features__c, In Kitchen;Washer/Dryer Stacked Included
listed_date__c, 2021-10-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Emiko
pba__listing_agent_lastname__c, Frye
listing_agent_mls_id__c, 800716
ffd_listingagentname, Emiko Y Frye
listing_agent_number__c, 800716
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CYUE
listing_office_name__c, C. Yuen Realty & Investments
listing_office_number__c, 947
pba__listingprice_pb__c, 749000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.401113
mls_id__c, 421605242
main_level__c, Bedroom(s);Kitchen;Living Room
master_property__c, a0O1I000001VhiAUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-10-18
original_price__c, 749000
overall_days_on_market__c, -81009
patio_and_porch_features__c, Roof Deck;Uncovered Deck
pba__pendingdate__c, 2021-11-18
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1150.54
pba__propertytype__c, Condominium
ListingId, a0E8W00000V0u3xUAB
road_surface_type__c, Asphalt
room_type__c, Kitchen;Living Room;Primary Bathroom
sale_date__c, 2021-11-23
sale_price__c, 749000
security_features__c, Smoke Detector;Fire Alarm;Carbon Mon Detector;Guarded Gate;Security Patrol
selling_agent_mls_id__c, 800716
selling_agent_number__c, 800716
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, C. Yuen Realty & Investments
pba__status__c, Closed
pba__totalarea_pb__c, 651
size__c, 651
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, New Montgomery
subdist__c, Yerba Buena
ffd_name, 74 New Montgomery Street #410, San Francisco, CA, 94105
view__c, City
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Window Coverings
pba__yearbuilt_pb__c, 1914
pba__postalcode_pb__c, 94105